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_COGS_OPM_PKG dependencies on OE_ORDER_LINES_ALL

Line 174: from oe_order_lines_all lines,

170: trunc(tran.gl_trans_date) COGS_DATE,
171: nvl(cust_acct.party_id, -1) SOLD_TO_ORG_ID,
172: Decode(lines.source_type_code, 'EXTERNAL', DO_NOT_INCLUDE_FOR_TURNS,INCLUDE_FOR_TURNS) TURNS_COGS_FLAG,
173: OPM_SOURCE SOURCE
174: from oe_order_lines_all lines,
175: hz_cust_accounts cust_acct,
176: ic_whse_mst whse,
177: mtl_system_items_b msi,
178: (select /*+ leading(tst) index(tran,IC_TRAN_PNDI2) use_nl(tran) */ rcv.oe_order_line_id oe_order_line_id,

Line 279: from oe_order_lines_all lines,

275: trunc(tran.gl_trans_date) COGS_DATE,
276: nvl(cust_acct.party_id, -1) SOLD_TO_ORG_ID,
277: Decode(lines.source_type_code, 'EXTERNAL', DO_NOT_INCLUDE_FOR_TURNS,INCLUDE_FOR_TURNS) TURNS_COGS_FLAG,
278: OPM_SOURCE SOURCE
279: from oe_order_lines_all lines,
280: hz_cust_accounts cust_acct,
281: ic_whse_mst whse,
282: mtl_system_items_b msi,
283: (select

Line 439: oe_order_lines_all lines,

435: nvl(cust_acct.party_id, -1) SOLD_TO_ORG_ID ,
436: Decode(lines.source_type_code, 'EXTERNAL', DO_NOT_INCLUDE_FOR_TURNS,INCLUDE_FOR_TURNS ) TURNS_COGS_FLAG ,
437: OPM_SOURCE SOURCE
438: from gl_subr_tst tst,
439: oe_order_lines_all lines,
440: hz_cust_accounts cust_acct,
441: ic_whse_mst whse,
442: mtl_system_items_b msi,
443: (

Line 563: oe_order_lines_all lines,

559: where doc_type = 'OMSO'
560: and completed_ind = 1
561: and gl_posted_ind = 1
562: group by doc_type, line_id, line_id, orgn_code, whse_code) tran,
563: oe_order_lines_all lines,
564: hz_cust_accounts cust_acct,
565: mtl_system_items_b msi,
566: ic_whse_mst whse
567: where tst.doc_type in ( 'OMSO', 'PORC' )