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 IC_WHSE_MST

Line 176: ic_whse_mst whse,

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,
179: tran.line_id,
180: tran.orgn_code,

Line 281: ic_whse_mst whse,

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
284: rcv.oe_order_line_id oe_order_line_id,
285: tran.line_id,

Line 441: ic_whse_mst whse,

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: (
444: select /*+ full(tran) full(rcv) use_hash(tran) parallel(tran) parallel(rcv) */
445: tran.doc_type,

Line 566: ic_whse_mst whse

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' )
568: and tst.acct_ttl_type = 5200
569: and lines.line_id = tran.oe_order_line_id
570: and lines.sold_to_org_id = cust_acct.cust_account_id(+)