DBA Data[Home] [Help]

APPS.CSTPPWMT dependencies on CST_PAC_ITEM_COST_DETAILS

Line 755: CST_PAC_ITEM_COST_DETAILS cpicd

751: USING (SELECT sum(NVL(cpicd.ITEM_COST,0) * -1 * p_pri_qty) cost,
752: (-1 * p_pri_qty) qty,
753: cpicd.cost_element_id cost_element_id
754: FROM CST_PAC_ITEM_COSTS cpic,
755: CST_PAC_ITEM_COST_DETAILS cpicd
756: WHERE cpic.pac_period_id = p_pac_period_id
757: AND cpic.cost_group_id = p_cost_group_id
758: AND cpic.inventory_item_id = p_item_id
759: AND cpic.cost_layer_id = cpicd.cost_layer_id