APPS.OPI_DBI_COGS_OPM_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 177: mtl_system_items_b msi,

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,
181: tran.whse_code,

Line 282: mtl_system_items_b msi,

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,
286: tran.orgn_code,

Line 442: mtl_system_items_b msi,

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,
446: rcv.oe_order_line_id oe_order_line_id,

Line 565: mtl_system_items_b msi,

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' )
568: and tst.acct_ttl_type = 5200
569: and lines.line_id = tran.oe_order_line_id