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 985: WIP_REQ_OPERATION_COST_DETAILS wrocd

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

Line 1553: update wip_req_operation_cost_details WROCD

1549:
1550:
1551: -- update WROCD
1552: l_stmt_num := 110;
1553: update wip_req_operation_cost_details WROCD
1554: set
1555: (
1556: WROCD.relieved_matl_completion_value,
1557: WROCD.temp_relieved_value

Line 1636: INSERT INTO WIP_REQ_OPERATION_COST_DETAILS

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

Line 1680: FROM WIP_REQ_OPERATION_COST_DETAILS WROCD2

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

Line 1909: WIP_REQ_OPERATION_COST_DETAILS wrocd

1905: i_prog_appl_id,
1906: i_prog_id,
1907: SYSDATE
1908: FROM
1909: WIP_REQ_OPERATION_COST_DETAILS wrocd
1910: where
1911: WIP_ENTITY_ID = i_wip_entity_id AND
1912: ORGANIZATION_ID = i_org_id
1913: GROUP BY