DBA Data[Home] [Help]

APPS.OPI_DBI_OPM_COGS_PKG dependencies on IC_WHSE_MST

Line 265: ic_whse_mst whse,

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,
268: gsob.currency_code currency_code,
269: to_number(HOI.org_information3) ship_ou_id

Line 403: ic_whse_mst whse,

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,
406: gsob.currency_code currency_code,
407: to_number(HOI.org_information3) ship_ou_id

Line 824: ic_whse_mst whse,

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) */
827: hou.organization_id organization_id,
828: gsob.currency_code currency_code,

Line 999: ic_whse_mst whse,

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) */
1002: hou.organization_id organization_id,
1003: gsob.currency_code currency_code,