APPS.OPI_DBI_OPM_COGS_PKG dependencies on GL_SUBR_LED

Line 67: gl_subr_led tst

63: AND tst.subledger_id = l.transaction_id
64: UNION
65: SELECT tst.gl_trans_date from_date
66: FROM opi_dbi_cogs_log l,
67: gl_subr_led tst
68: WHERE l.extraction_type = 'COGS_SUBLEDGER'
69: AND tst.subledger_id = l.transaction_id
70: UNION
71: SELECT aid.accounting_date from_date

Line 401: from gl_subr_led tst,

397: Decode(lines.source_type_code, 'EXTERNAL', 'OPM_RO_DROP', --drop ship
398: Decode(ou.ship_ou_id, lines.org_id, 'OPM_RO', -- Same OU,
399: Decode(check_ici(ou.ship_ou_id, lines.org_id), 1, 'OPM_RO_ICI',
400: 0, 'OPM_RO_NOICI', 'OPM') ) ) ) SOURCE
401: from gl_subr_led tst,
402: oe_order_lines_all lines,
403: ic_whse_mst whse,
404: (
405: SELECT hou.organization_id organization_id,

Line 997: from gl_subr_led tst,

993: Decode( lines.line_category_code, 'RETURN', 'OPM_RMA',
994: Decode(lines.source_type_code, 'EXTERNAL', 'OPM_RO_DROP', --drop ship
995: Decode(ou.ship_ou_id, lines.org_id, 'OPM_RO', -- Same OU,
996: 'OPM_CHECK_ICI' ) ) ) SOURCE
997: from gl_subr_led tst,
998: oe_order_lines_all lines,
999: ic_whse_mst whse,
1000: (
1001: SELECT /*+ PARALLEL(HOU) PARALLEL(HOI) PARALLEL(GSOB) */

Line 1511: from gl_subr_led tst

1507:
1508:
1509: SELECT Nvl(MAX(subledger_id),l_last_trx_id)
1510: INTO l_new_trx_id
1511: from gl_subr_led tst
1512: where tst.doc_type in ( 'OMSO', 'PORC')
1513: and tst.acct_ttl_type = 5200
1514: AND tst.gl_trans_date >= global_start_date
1515: AND tst.subledger_id >= l_last_trx_id;

Line 1527: from gl_subr_led tst

1523: SELECT Nvl(MIN(subledger_id),0) - 1,
1524: Nvl(MAX(subledger_id),0)
1525: INTO l_last_trx_id,
1526: l_new_trx_id
1527: from gl_subr_led tst
1528: where tst.doc_type in ( 'OMSO', 'PORC')
1529: and tst.acct_ttl_type = 5200
1530: AND tst.gl_trans_date >= global_start_date;
1531:

Line 1637: from gl_subr_led tst

1633: SELECT Nvl(MIN(subledger_id),0),
1634: Nvl(MAX(subledger_id),0)
1635: INTO l_last_trx_id,
1636: l_new_trx_id
1637: from gl_subr_led tst
1638: where tst.doc_type in ( 'OMSO', 'PORC' )
1639: and tst.acct_ttl_type = 5200
1640: AND tst.gl_trans_date >= global_start_date;
1641: