[Home] [Help]
166: /*
167: Differences between this procedure and collect_opm_LED_current:
168:
169: * target table is opi_dbi_opm_wip_TST_current (rather than ... LED_current)
170: * subr table is gl_subr_TST (rather than gl_subr_LED)
171: * ic_tran_pnd.gl_posted_ind = 0 (rather than 1)
172:
173: Noting these differences here makes it possible to propagate maintenance to the
174: led_current procedure by copying it and applying the differences. This is a
218: line_id,
219: TRUNC(gl_trans_date) gl_trans_date,
220: SUM(amount_base * debit_credit_sign) amount_base
221: FROM
222: gl_subr_tst
223: WHERE
224: gl_trans_date >= p_global_start_date
225: AND acct_ttl_type = 1500
226: AND doc_type = 'PROD'
336: --
337: -- When joining to ITP, ITP should be restricted to GL_POSTED_IND = 1,
338: -- since corrections may have been made (with balancing inventory transactions)
339: -- that have not yet been posted to GSL. Those corrections can only be picked up
340: -- in the extraction from GST (gl_subr_tst).
341: --
342: -- There is no restriction on the appearance of Expense Items in GSL, GST, or ITP.
343: --
344: -- Note that it is necessary to pre-aggregate (via in-line view) GSL and ITP,
547: --
548: -- When joining to ITP, ITP should be restricted to GL_POSTED_IND = 1,
549: -- since corrections may have been made (with balancing inventory transactions)
550: -- that have not yet been posted to GSL. Those corrections can only be picked up
551: -- in the extraction from GST (gl_subr_tst).
552: --
553: -- There is no restriction on the appearance of Expense Items in GSL, GST, or ITP.
554: --
555: -- Note that it is necessary to pre-aggregate (via in-line view) GSL and ITP,