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 654: FROM cst_pac_item_costs cpic

650: p_request_id,
651: p_prog_app_id,
652: p_prog_id,
653: SYSDATE
654: FROM cst_pac_item_costs cpic
655: WHERE cpic.pac_period_id = p_pac_period_id
656: AND cpic.cost_group_id = p_cost_group_id
657: AND cpic.inventory_item_id = p_item_id
658: )

Line 666: FROM cst_pac_item_costs cpic2

662: AND NVL(wppb.line_id,-99) = NVL(p_line_id,-99)
663: AND wppb.operation_seq_num = p_op_seq
664: AND EXISTS
665: ( SELECT 'X'
666: FROM cst_pac_item_costs cpic2
667: WHERE cpic2.pac_period_id = p_pac_period_id
668: AND cpic2.cost_group_id = p_cost_group_id
669: AND cpic2.inventory_item_id = p_item_id);
670:

Line 714: FROM cst_pac_item_costs cpic

710: p_request_id,
711: p_prog_app_id,
712: p_prog_id,
713: SYSDATE
714: FROM cst_pac_item_costs cpic
715: WHERE cpic.pac_period_id = p_pac_period_id
716: AND cpic.cost_group_id = p_cost_group_id
717: AND cpic.inventory_item_id = p_item_id
718: )

Line 726: FROM cst_pac_item_costs cpic2

722: AND NVL(wppb.line_id,-99) = NVL(p_line_id,-99)
723: AND wppb.operation_seq_num = p_op_seq
724: AND EXISTS
725: ( SELECT 'X'
726: FROM cst_pac_item_costs cpic2
727: WHERE cpic2.pac_period_id = p_pac_period_id
728: AND cpic2.cost_group_id = p_cost_group_id
729: AND cpic2.inventory_item_id = p_item_id)
730: AND EXISTS

Line 746: FROM CST_PAC_ITEM_COSTS cpic,

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