DBA Data[Home] [Help]

APPS.INV_CYC_LOVS dependencies on CST_CG_ITEM_COSTS_VIEW

Line 4984: FROM cst_cg_item_costs_view ccicv,

4980: -- also be considered as an average costed org
4981: BEGIN
4982: SELECT NVL ( ccicv.item_cost, 0 )
4983: INTO l_item_cost
4984: FROM cst_cg_item_costs_view ccicv,
4985: mtl_parameters mp
4986: WHERE l_locator_id IS NULL
4987: AND ccicv.organization_id = in_org_id
4988: AND ccicv.inventory_item_id = in_item_id

Line 5005: cst_cg_item_costs_view ccicv,

5001: )
5002: UNION ALL
5003: SELECT NVL ( ccicv.item_cost, 0 )
5004: FROM mtl_item_locations mil,
5005: cst_cg_item_costs_view ccicv,
5006: mtl_parameters mp
5007: WHERE l_locator_id IS NOT NULL
5008: AND mil.organization_id = in_org_id
5009: AND mil.inventory_location_id = l_locator_id

Line 5030: cst_cg_item_costs_view ccicv,

5026: UNION ALL
5027: SELECT NVL ( ccicv.item_cost, 0 )
5028: FROM mtl_item_locations mil,
5029: mrp_project_parameters mrp,
5030: cst_cg_item_costs_view ccicv,
5031: mtl_parameters mp
5032: WHERE l_locator_id IS NOT NULL
5033: AND mil.organization_id = in_org_id
5034: AND mil.inventory_location_id = l_locator_id