eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_DBI_OPM_COGS_PKG dependencies on OE_ORDER_LINES_ALL

Line 264: oe_order_lines_all lines,

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,
268: gsob.currency_code currency_code,

Line 402: oe_order_lines_all lines,

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,
406: gsob.currency_code currency_code,

Line 670: oe_order_lines_all l,

666: SUM( Nvl(aid.base_amount, aid.amount) ) cogs_val_b
667: FROM ap_invoice_distributions_all aid,
668: ap_invoices_all ai,
669: ra_customer_trx_lines_all rcl,
670: oe_order_lines_all l,
671: oe_order_lines_all pl,
672: hr_organization_information hoi,
673: gl_sets_of_books gsob,
674: hr_organization_information hoi2

Line 671: oe_order_lines_all pl,

667: FROM ap_invoice_distributions_all aid,
668: ap_invoices_all ai,
669: ra_customer_trx_lines_all rcl,
670: oe_order_lines_all l,
671: oe_order_lines_all pl,
672: hr_organization_information hoi,
673: gl_sets_of_books gsob,
674: hr_organization_information hoi2
675: WHERE aid.invoice_distribution_id >= p_last_dist_id

Line 823: oe_order_lines_all lines,

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

Line 998: oe_order_lines_all lines,

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