APPS.WIP_SUB_OP_RESOURCES_PKG dependencies on WIP_COST_TXN_INTERFACE

Line 143: from wip_cost_txn_interface wcti1,

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

Line 144: wip_cost_txn_interface wcti2

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

Line 220: wip_cost_txn_interface wcti

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

Line 232: delete from wip_cost_txn_interface

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

Line 237: update wip_cost_txn_interface

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