DBA Data[Home] [Help]

APPS.CSTPPWMT dependencies on CST_PAC_ITEM_COST_DETAILS

Line 747: CST_PAC_ITEM_COST_DETAILS cpicd

743: USING (SELECT sum(NVL(cpicd.ITEM_COST,0) * -1 * p_pri_qty) cost,
744: (-1 * p_pri_qty) qty,
745: cpicd.cost_element_id cost_element_id
746: FROM CST_PAC_ITEM_COSTS cpic,
747: CST_PAC_ITEM_COST_DETAILS cpicd
748: WHERE cpic.pac_period_id = p_pac_period_id
749: AND cpic.cost_group_id = p_cost_group_id
750: AND cpic.inventory_item_id = p_item_id
751: AND cpic.cost_layer_id = cpicd.cost_layer_id