APPS.CSTPLMWI dependencies on WIP_REQ_OPERATION_COST_DETAILS

Line 561: update wip_req_operation_cost_details

557: and organization_id = l_org_id;
558:
559: -- clear the temp_relieved_value column
560: l_stmt_num := 10;
561: update wip_req_operation_cost_details
562: set temp_relieved_value = 0
563: where wip_entity_id = i_wip_entity_id and
564: operation_seq_num = i_op_seq_num and
565: inventory_item_id = i_inv_item_id;

Line 571: INSERT INTO WIP_REQ_OPERATION_COST_DETAILS WROCD

567: if l_exp_item_flag <> 1 then
568: -- don't insert into WROCD for expense item
569: -- insert into WROCD if not already there
570: l_stmt_num := 20;
571: INSERT INTO WIP_REQ_OPERATION_COST_DETAILS WROCD
572: (
573: WIP_ENTITY_ID,
574: OPERATION_SEQ_NUM,
575: ORGANIZATION_ID,

Line 615: FROM WIP_REQ_OPERATION_COST_DETAILS WROCD2

611: where
612: NOT EXISTS
613: (
614: SELECT 'X'
615: FROM WIP_REQ_OPERATION_COST_DETAILS WROCD2
616: WHERE
617: WROCD2.WIP_ENTITY_ID = i_wip_entity_id AND
618: WROCD2.OPERATION_SEQ_NUM = i_op_seq_num AND
619: WROCD2.INVENTORY_ITEM_ID = i_inv_item_id AND

Line 786: UPDATE WIP_REQ_OPERATION_COST_DETAILS

782: BEGIN
783:
784: l_stmt_num := 10;
785:
786: UPDATE WIP_REQ_OPERATION_COST_DETAILS
787: SET temp_relieved_value = 0
788: where WIP_ENTITY_ID = i_wip_entity_id;
789:
790: l_stmt_num := 20;