APPS.OPI_DBI_OPM_COGS_PKG dependencies on GL_SUBR_TST

Line 61: gl_subr_tst tst

57:
58: SELECT NVL(MIN(from_date), global_start_date) INTO l_from_date
59: FROM (SELECT tst.gl_trans_date from_date
60: FROM opi_dbi_cogs_log l,
61: gl_subr_tst tst
62: WHERE l.extraction_type = 'COGS_SUBLEDGER'
63: AND tst.subledger_id = l.transaction_id
64: UNION
65: SELECT tst.gl_trans_date from_date

Line 263: from gl_subr_tst tst,

259: Decode(lines.source_type_code, 'EXTERNAL', 'OPM_RO_DROP', --drop ship
260: Decode(ou.ship_ou_id, lines.org_id, 'OPM_RO', -- Same OU,
261: Decode(check_ici(ou.ship_ou_id, lines.org_id), 1, 'OPM_RO_ICI',
262: 0, 'OPM_RO_NOICI', 'OPM') ) ) ) SOURCE
263: from gl_subr_tst tst,
264: oe_order_lines_all lines,
265: ic_whse_mst whse,
266: (
267: SELECT hou.organization_id organization_id,

Line 822: from gl_subr_tst tst,

818: Decode( lines.line_category_code, 'RETURN', 'OPM_RMA',
819: Decode(lines.source_type_code, 'EXTERNAL', 'OPM_RO_DROP', --drop ship
820: Decode(ou.ship_ou_id, lines.org_id, 'OPM_RO', -- Same OU,
821: 'OPM_CHECK_ICI' ) ) ) SOURCE
822: from gl_subr_tst tst,
823: oe_order_lines_all lines,
824: ic_whse_mst whse,
825: (
826: SELECT /*+ PARALLEL(HOU) PARALLEL(HOI) PARALLEL(GSOB) */