DBA Data[Home] [Help]

APPS.INV_CYC_LOVS dependencies on MTL_ITEM_LOCATIONS

Line 5004: FROM mtl_item_locations mil,

5000: NVL ( l_cost_group_id, mp.default_cost_group_id)
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

Line 5028: FROM mtl_item_locations mil,

5024: NVL ( l_cost_group_id, mp.default_cost_group_id)
5025: )
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