APPS.OPI_DBI_INV_VALUE_OPM_INIT_PKG dependencies on IC_ITEM_MST_B

Line 339: ic_item_mst_b iim,

335: SUM(DECODE(q.type, 2, q.quantity * c.total_cost, 0)) intransit_value_b
336: FROM
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

Line 499: ic_item_mst_b ic_item,

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,
502: sy_orgn_mst c,
503: opi_dbi_inv_value_log sd

Line 610: ic_item_mst_b ic_item,

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
614: WHERE ic_tran.completed_ind = 1 -- but complete

Line 666: ic_item_mst_b ic_item,

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
670: WHERE ic_tran.completed_ind = 1 -- but complete

Line 781: ic_item_mst_b i,

777: ) ib,
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