APPS.CSTPLCAC dependencies on WIP_REQ_OPERATION_COST_DETAILS

Line 556: update wip_req_operation_cost_details WROCD

552:
553: -- update WROCD
554:
555: l_stmt_num := 180;
556: update wip_req_operation_cost_details WROCD
557: set
558: (
559: WROCD.relieved_matl_completion_value,
560: WROCD.temp_relieved_value

Line 639: INSERT INTO WIP_REQ_OPERATION_COST_DETAILS

635: -- If Item is an Expense Item
636: -- Just Insert into WROCD if not already there and
637: -- update relieved_matl_completion_qty
638:
639: INSERT INTO WIP_REQ_OPERATION_COST_DETAILS
640: (
641: WIP_ENTITY_ID,
642: OPERATION_SEQ_NUM,
643: ORGANIZATION_ID,

Line 683: FROM WIP_REQ_OPERATION_COST_DETAILS WROCD2

679: where
680: NOT EXISTS
681: (
682: SELECT 'X'
683: FROM WIP_REQ_OPERATION_COST_DETAILS WROCD2
684: WHERE
685: WROCD2.WIP_ENTITY_ID = i_wip_entity_id AND
686: WROCD2.OPERATION_SEQ_NUM = wro_rec.operation_seq_num AND
687: WROCD2.INVENTORY_ITEM_ID = wro_rec.inventory_item_id AND

Line 987: WIP_REQ_OPERATION_COST_DETAILS wrocd

983: i_prog_appl_id,
984: i_prog_id,
985: SYSDATE
986: FROM
987: WIP_REQ_OPERATION_COST_DETAILS wrocd
988: where
989: WIP_ENTITY_ID = i_wip_entity_id AND
990: ORGANIZATION_ID = i_org_id
991: GROUP BY

Line 1556: update wip_req_operation_cost_details WROCD

1552:
1553:
1554: -- update WROCD
1555: l_stmt_num := 110;
1556: update wip_req_operation_cost_details WROCD
1557: set
1558: (
1559: WROCD.relieved_matl_completion_value,
1560: WROCD.temp_relieved_value

Line 1639: INSERT INTO WIP_REQ_OPERATION_COST_DETAILS

1635: -- If Item is an Expense Item
1636: -- Just Insert into WROCD if not already there and
1637: -- update relieved_matl_completion_qty
1638:
1639: INSERT INTO WIP_REQ_OPERATION_COST_DETAILS
1640: (
1641: WIP_ENTITY_ID,
1642: OPERATION_SEQ_NUM,
1643: ORGANIZATION_ID,

Line 1683: FROM WIP_REQ_OPERATION_COST_DETAILS WROCD2

1679: where
1680: NOT EXISTS
1681: (
1682: SELECT 'X'
1683: FROM WIP_REQ_OPERATION_COST_DETAILS WROCD2
1684: WHERE
1685: WROCD2.WIP_ENTITY_ID = i_wip_entity_id AND
1686: WROCD2.OPERATION_SEQ_NUM = wro_rec.operation_seq_num AND
1687: WROCD2.INVENTORY_ITEM_ID = wro_rec.inventory_item_id AND

Line 1914: WIP_REQ_OPERATION_COST_DETAILS wrocd

1910: i_prog_appl_id,
1911: i_prog_id,
1912: SYSDATE
1913: FROM
1914: WIP_REQ_OPERATION_COST_DETAILS wrocd
1915: where
1916: WIP_ENTITY_ID = i_wip_entity_id AND
1917: ORGANIZATION_ID = i_org_id
1918: GROUP BY