APPS.CSTPPWMT dependencies on CST_PAC_ITEM_COSTS

Line 342: cst_pac_item_costs cpic

338: SELECT DECODE(l_zero_cost_flag,
339: 0, nvl(cpic.item_cost,0), 0) * (-1 * l_pri_qty )
340: INTO l_applied_value
341: FROM wip_discrete_jobs wdj,
342: cst_pac_item_costs cpic
343: WHERE cpic.pac_period_id = p_pac_period_id
344: AND cpic.cost_group_id = p_cost_group_id
345: AND cpic.inventory_item_id = l_item_id
346: AND wdj.wip_entity_id = l_entity_id;

Line 662: FROM cst_pac_item_costs cpic

658: p_request_id,
659: p_prog_app_id,
660: p_prog_id,
661: SYSDATE
662: FROM cst_pac_item_costs cpic
663: WHERE cpic.pac_period_id = p_pac_period_id
664: AND cpic.cost_group_id = p_cost_group_id
665: AND cpic.inventory_item_id = p_item_id
666: )

Line 674: FROM cst_pac_item_costs cpic2

670: AND NVL(wppb.line_id,-99) = NVL(p_line_id,-99)
671: AND wppb.operation_seq_num = p_op_seq
672: AND EXISTS
673: ( SELECT 'X'
674: FROM cst_pac_item_costs cpic2
675: WHERE cpic2.pac_period_id = p_pac_period_id
676: AND cpic2.cost_group_id = p_cost_group_id
677: AND cpic2.inventory_item_id = p_item_id);
678:

Line 722: FROM cst_pac_item_costs cpic

718: p_request_id,
719: p_prog_app_id,
720: p_prog_id,
721: SYSDATE
722: FROM cst_pac_item_costs cpic
723: WHERE cpic.pac_period_id = p_pac_period_id
724: AND cpic.cost_group_id = p_cost_group_id
725: AND cpic.inventory_item_id = p_item_id
726: )

Line 734: FROM cst_pac_item_costs cpic2

730: AND NVL(wppb.line_id,-99) = NVL(p_line_id,-99)
731: AND wppb.operation_seq_num = p_op_seq
732: AND EXISTS
733: ( SELECT 'X'
734: FROM cst_pac_item_costs cpic2
735: WHERE cpic2.pac_period_id = p_pac_period_id
736: AND cpic2.cost_group_id = p_cost_group_id
737: AND cpic2.inventory_item_id = p_item_id)
738: AND EXISTS

Line 754: FROM CST_PAC_ITEM_COSTS cpic,

750: MERGE INTO CST_PAC_REQ_OPER_COST_DETAILS cprocd
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