APPS.CSTPACIR dependencies on WIP_REQ_OPERATION_COST_DETAILS

Line 50: INSERT INTO WIP_REQ_OPERATION_COST_DETAILS

46: * INSERT is required. *
47: ***********************************************************/
48:
49:
50: INSERT INTO WIP_REQ_OPERATION_COST_DETAILS
51: (WIP_ENTITY_ID,
52: OPERATION_SEQ_NUM,
53: ORGANIZATION_ID,
54: INVENTORY_ITEM_ID,

Line 89: WIP_REQ_OPERATION_COST_DETAILS W2

85: NOT EXISTS
86: (
87: SELECT 'X'
88: FROM
89: WIP_REQ_OPERATION_COST_DETAILS W2
90: WHERE
91: W2.COST_ELEMENT_ID = C.COST_ELEMENT_ID AND
92: W2.WIP_ENTITY_ID = i_wip_entity_id AND
93: W2.ORGANIZATION_ID = i_org_id AND

Line 116: from WIP_REQ_OPERATION_COST_DETAILS W2

112: and rownum = 1;
113:
114: select count(*)
115: into l_wrocd_count
116: from WIP_REQ_OPERATION_COST_DETAILS W2
117: WHERE
118: W2.WIP_ENTITY_ID = i_wip_entity_id AND
119: W2.ORGANIZATION_ID = i_org_id AND
120: W2.INVENTORY_ITEM_ID = i_inv_item_id AND

Line 125: INSERT INTO WIP_REQ_OPERATION_COST_DETAILS

121: W2.OPERATION_SEQ_NUM = i_op_seq_num AND
122: rownum = 1;
123:
124: if(l_clcd_count = 0 and l_wrocd_count = 0) then
125: INSERT INTO WIP_REQ_OPERATION_COST_DETAILS
126: (WIP_ENTITY_ID,
127: OPERATION_SEQ_NUM,
128: ORGANIZATION_ID,
129: INVENTORY_ITEM_ID,

Line 190: UPDATE WIP_REQ_OPERATION_COST_DETAILS w

186: * update wip_req_op_cost_details,per cost element *
187: * for the item that has been issued/returned. *
188: **************************************************/
189:
190: UPDATE WIP_REQ_OPERATION_COST_DETAILS w
191: SET (LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
192: PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE,
193: applied_matl_value )=
194: (SELECT