APPS.CSTPACIR dependencies on WIP_REQ_OPERATION_COST_DETAILS

Line 46: INSERT INTO WIP_REQ_OPERATION_COST_DETAILS

42: * INSERT is required. *
43: ***********************************************************/
44:
45:
46: INSERT INTO WIP_REQ_OPERATION_COST_DETAILS
47: (WIP_ENTITY_ID,
48: OPERATION_SEQ_NUM,
49: ORGANIZATION_ID,
50: INVENTORY_ITEM_ID,

Line 85: WIP_REQ_OPERATION_COST_DETAILS W2

81: NOT EXISTS
82: (
83: SELECT 'X'
84: FROM
85: WIP_REQ_OPERATION_COST_DETAILS W2
86: WHERE
87: W2.COST_ELEMENT_ID = C.COST_ELEMENT_ID AND
88: W2.WIP_ENTITY_ID = i_wip_entity_id AND
89: W2.ORGANIZATION_ID = i_org_id AND

Line 126: UPDATE WIP_REQ_OPERATION_COST_DETAILS w

122: * update wip_req_op_cost_details,per cost element *
123: * for the item that has been issued/returned. *
124: **************************************************/
125:
126: UPDATE WIP_REQ_OPERATION_COST_DETAILS w
127: SET (LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
128: PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE,
129: applied_matl_value )=
130: (SELECT