APPS.WIP_OPERATION_RESOURCES_PKG dependencies on WIP_COST_TXN_INTERFACE

Line 141: from wip_cost_txn_interface wcti1,

137:
138: cursor get_dup_res(c_group_id number) is
139: select wcti1.operation_seq_num,
140: wcti1.resource_seq_num
141: from wip_cost_txn_interface wcti1,
142: wip_cost_txn_interface wcti2
143: where wcti1.source_code = 'NEW_RES'
144: and wcti1.group_id = c_group_id
145: and wcti1.source_code = wcti2.source_code

Line 142: wip_cost_txn_interface wcti2

138: cursor get_dup_res(c_group_id number) is
139: select wcti1.operation_seq_num,
140: wcti1.resource_seq_num
141: from wip_cost_txn_interface wcti1,
142: wip_cost_txn_interface wcti2
143: where wcti1.source_code = 'NEW_RES'
144: and wcti1.group_id = c_group_id
145: and wcti1.source_code = wcti2.source_code
146: and wcti1.group_id = wcti2.group_id

Line 218: wip_cost_txn_interface wcti

214: wcti.created_by,
215: wcti.last_update_login
216: from bom_resources br,
217: wip_operations wo,
218: wip_cost_txn_interface wcti
219: where wcti.source_code = 'NEW_RES'
220: and wcti.group_id = p_group_id
221: and wcti.organization_id = wo.organization_id
222: and wcti.wip_entity_id = wo.wip_entity_id

Line 230: delete from wip_cost_txn_interface

226: = nvl(wo.repetitive_schedule_id, -1);
227:
228: -- delete txn qty = NULL records that are used for adding resources
229: -- changed condition from txn qty = 0 to txn qty is null for bug # 661593
230: delete from wip_cost_txn_interface
231: where group_id = p_group_id
232: and transaction_quantity is NULL;
233:
234: -- clean up interface

Line 235: update wip_cost_txn_interface

231: where group_id = p_group_id
232: and transaction_quantity is NULL;
233:
234: -- clean up interface
235: update wip_cost_txn_interface
236: set source_code = NULL -- clear source code to remove NEW_RES message
237: where group_id = p_group_id;
238: end add_resources;
239: