DBA Data[Home] [Help]

APPS.OPI_DBI_INV_VALUE_OPM_INIT_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 341: mtl_system_items_b msi

337: opi_dbi_opm_inception_qty q,
338: opi_pmi_cost_result_gtmp c,
339: ic_item_mst_b iim,
340: ic_whse_mst w,
341: mtl_system_items_b msi
342: WHERE
343: q.type = 1
344: AND c.whse_code = q.whse_code
345: AND c.item_id = q.item_id

Line 497: mtl_system_items_b msi,

493: 2, nvl (sup.quantity,0),
494: 1, nvl (sup.to_org_primary_quantity,0))) qty
495: FROM mtl_supply sup,
496: mtl_parameters mp,
497: mtl_system_items_b msi,
498: ic_whse_mst whse_mst,
499: ic_item_mst_b ic_item,
500: mtl_interorg_parameters mip,
501: sy_orgn_mst o,

Line 609: mtl_system_items_b msi,

605: ) ic_tran,
606: oe_order_lines_all oola,
607: po_requisition_lines_all req,
608: ic_whse_mst whse_mst,
609: mtl_system_items_b msi,
610: ic_item_mst_b ic_item,
611: mtl_interorg_parameters mip,
612: sy_orgn_mst o,
613: opi_dbi_inv_value_log sd

Line 665: mtl_system_items_b msi,

661: ) ic_tran,
662: rcv_transactions rcv,
663: po_requisition_lines_all req,
664: ic_whse_mst whse_mst,
665: mtl_system_items_b msi,
666: ic_item_mst_b ic_item,
667: mtl_interorg_parameters mip,
668: sy_orgn_mst o,
669: opi_dbi_inv_value_log sd

Line 782: mtl_system_items_b msi,

778: ic_whse_mst w,
779: sy_orgn_mst o,
780: sy_orgn_mst c,
781: ic_item_mst_b i,
782: mtl_system_items_b msi,
783: opi_dbi_inv_value_log log
784: WHERE
785: w.whse_code = ib.whse_code
786: AND i.item_id = ib.item_id