DBA Data[Home] [Help]

APPS.INV_UTILITIES dependencies on MRP_PROJECT_PARAMETERS

Line 795: FROM mtl_item_locations mil, mrp_project_parameters mrp, cst_cg_item_costs_view ccicv, mtl_parameters mp

791: AND ccicv.organization_id = mp.organization_id
792: AND ccicv.cost_group_id = DECODE(mp.primary_cost_method, 1, 1, DECODE(l_wms_enabled_flag,'Y',ccicv.cost_group_id, NVL(mp.default_cost_group_id, 1)))
793: UNION ALL
794: SELECT NVL(ccicv.item_cost, 0)
795: FROM mtl_item_locations mil, mrp_project_parameters mrp, cst_cg_item_costs_view ccicv, mtl_parameters mp
796: WHERE v_locator_id IS NOT NULL
797: AND mil.organization_id = v_org_id
798: AND mil.inventory_location_id = v_locator_id
799: AND mil.project_id IS NOT NULL