DBA Data[Home] [Help]

APPS.MTL_ABC_COMPILE_PKG dependencies on CST_CG_ITEM_COSTS_VIEW

Line 196: FROM CST_CG_ITEM_COSTS_VIEW CCICV,

192: l_item_cost NUMBER := 0.0;
193: BEGIN
194: IF (x_project_id IS NOT NULL) THEN
195: SELECT NVL(CCICV.ITEM_COST,0) into l_item_cost
196: FROM CST_CG_ITEM_COSTS_VIEW CCICV,
197: MRP_PROJECT_PARAMETERS MPP
198: WHERE CCICV.ORGANIZATION_ID = x_organization_id
199: AND CCICV.INVENTORY_ITEM_ID = x_inventory_item_id
200: AND CCICV.COST_GROUP_ID = MPP.COSTING_GROUP_ID

Line 205: FROM CST_CG_ITEM_COSTS_VIEW CCICV

201: AND MPP.PROJECT_ID = x_project_id
202: AND MPP.ORGANIZATION_ID = x_organization_id;
203: ELSIF (x_project_id IS NULL) THEN
204: SELECT NVL(CCICV.ITEM_COST,0) into l_item_cost
205: FROM CST_CG_ITEM_COSTS_VIEW CCICV
206: WHERE CCICV.ORGANIZATION_ID = x_organization_id
207: AND CCICV.INVENTORY_ITEM_ID = x_inventory_item_id
208: AND CCICV.COST_GROUP_ID = x_cost_group_id;
209: END IF;