APPS.OPI_DBI_INV_VALUE_OPM_INCR_PKG dependencies on GL_SUBR_LED

Line 92: FROM gl_subr_led led

88: SELECT ' || lv_led_hint || '
89: led.doc_type, led.doc_id, led.line_id,
90: TRUNC(led.gl_trans_date) gl_trans_date,
91: SUM(led.amount_base * led.debit_credit_sign) amount_base
92: FROM gl_subr_led led
93: WHERE
94: led.acct_ttl_type = 1500
95: AND led.subledger_id BETWEEN :1 AND :2
96: AND led.gl_trans_date >= :3

Line 222: FROM gl_subr_led led

218: led.doc_id,
219: led.line_id,
220: TRUNC(led.gl_doc_date) gl_doc_date,
221: SUM(led.amount_base * led.debit_credit_sign) amount_base
222: FROM gl_subr_led led
223: WHERE
224: led.acct_ttl_type = 6250 -- IRV ACCT
225: AND led.subledger_id BETWEEN :1 AND :2
226: AND led.gl_doc_date >= :3

Line 401: gl_subr_led led,

397: AND gl_posted_ind = 1 -- completed+posted transaction
398: GROUP BY doc_type, doc_id, line_id, whse_code, item_id,
399: trans_um, gl_posted_ind, 1
400: ) pnd,
401: gl_subr_led led,
402: ic_whse_mst whse_mst,
403: mtl_system_items_b msi,
404: ic_item_mst_b ic_item,
405: ic_xfer_mst xfer

Line 529: -- gl_subr_led?

525: -- Additionally, for the pnd table, we need to pick up only completed
526: -- transactions, i.e. ones with completed_ind = 1
527: --
528: -- Why does the ic_tran_pnd/cmp have to be collapsed before matching to
529: -- gl_subr_led?
530: -- Why do we not need a date join between the ic_tran_pnd/cmp and
531: -- gl_subr_led?
532: -- There can be a N-N mapping between the tran tables and the ledger.
533: -- The N in the ledger can be because of some adjustment accounts etc.

Line 531: -- gl_subr_led?

527: --
528: -- Why does the ic_tran_pnd/cmp have to be collapsed before matching to
529: -- gl_subr_led?
530: -- Why do we not need a date join between the ic_tran_pnd/cmp and
531: -- gl_subr_led?
532: -- There can be a N-N mapping between the tran tables and the ledger.
533: -- The N in the ledger can be because of some adjustment accounts etc.
534: -- where one line in the tran tables generates multiple lines in the
535: -- ledger. So far, all but one such multiple lines I have seen have a

Line 660: FROM gl_subr_led subr

656: trunc (gl_trans_date) gl_trans_date, doc_id,
657: doc_type, line_id, acct_ttl_type,
658: amount_base, debit_credit_sign, exchange_rate,
659: mul_div_sign
660: FROM gl_subr_led subr
661: WHERE subledger_id BETWEEN :1
662: AND :2
663: AND trunc(subr.gl_trans_date) >= :3
664: AND acct_ttl_type = 1590

Line 742: FROM gl_subr_led subr

738: trunc (gl_trans_date) gl_trans_date, doc_id,
739: doc_type, line_id, acct_ttl_type,
740: amount_base, debit_credit_sign, exchange_rate,
741: mul_div_sign
742: FROM gl_subr_led subr
743: WHERE subledger_id BETWEEN :4
744: AND :5
745: AND trunc(subr.gl_trans_date) >= :6
746: AND acct_ttl_type = 1590 -- internal order account

Line 827: FROM gl_subr_led l, gme_batch_header h

823: SELECT ' || lv_led_hint || '
824: doc_id, h.wip_whse_code whse_code,
825: TRUNC(l.gl_trans_date) transaction_date,
826: SUM(l.amount_base * l.debit_credit_sign) amount_base
827: FROM gl_subr_led l, gme_batch_header h
828: WHERE
829: l.doc_type = ''PROD''
830: AND l.acct_ttl_type = 1530
831: AND l.doc_id = h.batch_id

Line 1006: FROM gl_subr_led

1002: l_to_transaction_id
1003: FROM
1004: (
1005: SELECT /*+ NO_MERGE MAX(subledger_id) to_transaction_id
1006: FROM gl_subr_led
1007: ) led,
1008: opi_dbi_inv_value_log log
1009: WHERE
1010: log.type = 'GSL'

Line 1015: FROM gl_subr_led

1011: AND log.organization_id = 0
1012: AND log.source = 2;*/
1013:
1014: select MAX(subledger_id),MIN(subledger_id) into l_to_transaction_id , l_from_transaction_id
1015: FROM gl_subr_led
1016: where gl_trans_date > g_global_start_date;
1017:
1018:
1019: EXCEPTION