库存MTA代码,OracleEBS代码库,德仔网

代码语言

代码分类

【OracleEBS】库存MTA

作者:Dezai.CN / 发布于2013/1/7/ 1082

-- 库存MTA
SELECT c.code_combination_id,
       c.segment1,
       c.segment2,
       c.segment3,
       c.segment4,
       c.segment5,
       h.currency_code,
       h.period_name,
       to_number(to_char(h.default_effective_date, 'YYYY')) AS je_year,
       to_number(to_char(h.default_effective_date, 'MM')) AS je_month,
       to_number(to_char(h.default_effective_date, 'DD')) AS je_day,
       to_char(h.doc_sequence_value) AS voucher,
       'TRANSACTION_ID:' || to_char(mta.transaction_id) AS explanation,
       b.NAME AS batch,
       h.NAME AS account_name,
       '库存' AS origin,
       sign(l.entered_dr) * abs(mta.base_transaction_value) AS entered_dr,
       sign(l.entered_cr) * abs(mta.base_transaction_value) AS entered_cr,
       sign(l.entered_dr) * abs(mta.base_transaction_value) AS accounted_dr,
       sign(l.entered_cr) * abs(mta.base_transaction_value) AS accounted_cr,
       mta.currency_conversion_rate AS rate,
       mta.transaction_id AS je_line_num
  FROM gl.gl_code_combinations      c,
       gl.gl_je_headers             h,
       gl.gl_je_lines               l,
       gl.gl_je_batches             b,
       gl.gl_import_references      i,
       inv.mtl_transaction_accounts mta
WHERE i.je_batch_id = b.je_batch_id
   AND i.je_header_id = h.je_header_id
   AND i.je_line_num = l.je_line_num
   AND h.je_header_id = l.je_header_id
   AND h.je_batch_id = b.je_batch_id
   AND h.je_source = 'Inventory'
   AND l.code_combination_id = c.code_combination_id
   AND l.period_name = rec_period.period_name
   AND l.status = 'P'
   AND i.gl_sl_link_table = 'MTA'
   AND i.gl_sl_link_id = mta.gl_sl_link_id
   AND mta.organization_id = p_organization_id
   AND h.set_of_books_id = p_set_of_books_id
   AND h.period_name = rec_period.period_name
   AND mta.transaction_date >= rec_period.start_date
   AND c.segment1 = nvl(p_segment1, c.segment1)
   AND c.segment2 = nvl(p_segment2, c.segment2)
   AND to_char(h.doc_sequence_value) LIKE p_segment1 || '%'

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　MTA　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)