[Home] [Help]
772: FROM MTL_PARAMETERS mp
773: WHERE mp.organization_id=v_org_id ;
774: SELECT NVL(ccicv.item_cost, 0)
775: INTO v_item_cost
776: FROM cst_cg_item_costs_view ccicv, mtl_parameters mp
777: WHERE v_locator_id IS NULL
778: AND ccicv.organization_id = v_org_id
779: AND ccicv.inventory_item_id = v_item_id
780: AND ccicv.organization_id = mp.organization_id
780: AND ccicv.organization_id = mp.organization_id
781: AND ccicv.cost_group_id = DECODE(mp.primary_cost_method, 1, 1, NVL(mp.default_cost_group_id, 1))
782: UNION ALL
783: SELECT NVL(ccicv.item_cost, 0)
784: FROM mtl_item_locations mil, cst_cg_item_costs_view ccicv, mtl_parameters mp
785: WHERE v_locator_id IS NOT NULL
786: AND mil.organization_id = v_org_id
787: AND mil.inventory_location_id = v_locator_id
788: AND mil.project_id IS NULL
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
807: WHEN NO_DATA_FOUND THEN
808: v_item_cost := -999;
809: WHEN TOO_MANY_ROWS THEN --Bug --Forward port 7037252/6349028/6343400
810: IF (l_wms_enabled_flag = 'Y' ) THEN
811: --For WMS org with average costing, there may be more than one rows in cst_cg_item_costs_view.
812: --In this case, the correct cost will be stamped from INV_COST_GROUP_PVT after obtaining exact cost group.
813: v_item_cost := 1; --This is hard-coded so that we can retrieve the percent value in INV_COST_GROUP_PVT.
814: ELSE
815: v_item_cost := -999; --This should result in error for non-wms orgs.