DBA Data[Home] [Help]

APPS.OPI_DBI_INV_VALUE_OPM_INIT_PKG dependencies on IC_WHSE_MST

Line 283: ic_whse_mst w,

279: DISTINCT q.whse_code, w.orgn_code, q.item_id, id.transaction_date
280: FROM
281: opi_dbi_opm_inception_qty q,
282: opi_dbi_inv_value_log id,
283: ic_whse_mst w,
284: sy_orgn_mst o,
285: sy_orgn_mst c
286: WHERE
287: w.whse_code = q.whse_code

Line 340: ic_whse_mst w,

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
344: AND c.whse_code = q.whse_code

Line 498: ic_whse_mst whse_mst,

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

Line 608: ic_whse_mst whse_mst,

604: trans_um, gl_posted_ind, trans_date, 1
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,

Line 664: ic_whse_mst whse_mst,

660: trans_um, gl_posted_ind, trans_date, 1
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,

Line 753: ic_whse_mst w,

749: -1 * sum(amount_base * debit_credit_sign) amount_base
750: from
751: gl_subr_led l,
752: gme_batch_header h,
753: ic_whse_mst w,
754: sy_orgn_mst o,
755: opi_dbi_inv_value_log log
756: where
757: l.doc_type = 'PROD'

Line 778: ic_whse_mst w,

774: gmd.item_id
775: HAVING
776: nvl(sum(led.amount_base * gmd.cost_alloc),0) <> 0
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,