APPS.CSTPLMWI dependencies on WIP_REQ_OPERATION_COST_DETAILS

Line 562: update wip_req_operation_cost_details

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

Line 572: INSERT INTO WIP_REQ_OPERATION_COST_DETAILS WROCD

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

Line 616: FROM WIP_REQ_OPERATION_COST_DETAILS WROCD2

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

Line 787: UPDATE WIP_REQ_OPERATION_COST_DETAILS

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