DBA Data[Home] [Help]

APPS.INV_CYC_LOVS dependencies on MTL_ITEM_LOCATIONS

Line 5076: FROM mtl_item_locations mil,

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

Line 5100: FROM mtl_item_locations mil,

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