DBA Data[Home] [Help]

APPS.INV_CYC_LOVS dependencies on CST_CG_ITEM_COSTS_VIEW

Line 5056: FROM cst_cg_item_costs_view ccicv,

5052: -- End Bug 9650524
5053: BEGIN
5054: SELECT NVL ( ccicv.item_cost, 0 )
5055: INTO l_item_cost
5056: FROM cst_cg_item_costs_view ccicv,
5057: mtl_parameters mp
5058: WHERE l_locator_id IS NULL
5059: AND ccicv.organization_id = in_org_id
5060: AND ccicv.inventory_item_id = in_item_id

Line 5077: cst_cg_item_costs_view ccicv,

5073: )
5074: UNION ALL
5075: SELECT NVL ( ccicv.item_cost, 0 )
5076: FROM mtl_item_locations mil,
5077: cst_cg_item_costs_view ccicv,
5078: mtl_parameters mp
5079: WHERE l_locator_id IS NOT NULL
5080: AND mil.organization_id = in_org_id
5081: AND mil.inventory_location_id = l_locator_id

Line 5102: cst_cg_item_costs_view ccicv,

5098: UNION ALL
5099: SELECT NVL ( ccicv.item_cost, 0 )
5100: FROM mtl_item_locations mil,
5101: mrp_project_parameters mrp,
5102: cst_cg_item_costs_view ccicv,
5103: mtl_parameters mp
5104: WHERE l_locator_id IS NOT NULL
5105: AND mil.organization_id = in_org_id
5106: AND mil.inventory_location_id = l_locator_id