APPS.WIP_WICTPG dependencies on WIP_MOVE_TXN_ALLOCATIONS

Line 622: x_purge_rec.table_name := 'WIP_MOVE_TXN_ALLOCATIONS';

618:
619: -- verify that no other schedules exists
620: fnd_message.set_name('WIP', 'WIP_TRANSACTIONS_PURGE_ERROR');
621: x_purge_rec.info := fnd_message.get;
622: x_purge_rec.table_name := 'WIP_MOVE_TXN_ALLOCATIONS';
623: SELECT COUNT(*) into l_num_rows
624: FROM DUAL WHERE EXISTS (
625: SELECT out_wmta.transaction_id
626: FROM wip_move_txn_allocations out_wmta

Line 626: FROM wip_move_txn_allocations out_wmta

622: x_purge_rec.table_name := 'WIP_MOVE_TXN_ALLOCATIONS';
623: SELECT COUNT(*) into l_num_rows
624: FROM DUAL WHERE EXISTS (
625: SELECT out_wmta.transaction_id
626: FROM wip_move_txn_allocations out_wmta
627: WHERE out_wmta.organization_id = p_purge_request.organization_id
628: AND out_wmta.repetitive_schedule_id = p_purge_request.repetitive_schedule_id
629: AND transaction_id IN (
630: SELECT transaction_id

Line 632: wip_move_txn_allocations wmta

628: AND out_wmta.repetitive_schedule_id = p_purge_request.repetitive_schedule_id
629: AND transaction_id IN (
630: SELECT transaction_id
631: FROM wip_repetitive_schedules wrs,
632: wip_move_txn_allocations wmta
633: WHERE wmta.transaction_id = out_wmta.transaction_id
634: AND wmta.repetitive_schedule_id <> out_wmta.repetitive_schedule_id
635: AND nvl(wrs.date_closed, p_cutoff_date+1) > p_cutoff_date
636: AND wrs.repetitive_schedule_id = wmta.repetitive_schedule_id

Line 662: FROM wip_move_txn_allocations out_wmta

658: savepoint wictpg_sp01;
659: DELETE FROM WIP_MOVE_TRANSACTIONS
660: WHERE TRANSACTION_ID IN (
661: SELECT out_wmta.transaction_id
662: FROM wip_move_txn_allocations out_wmta
663: WHERE out_wmta.organization_id = p_purge_request.organization_id
664: AND out_wmta.repetitive_schedule_id = p_purge_request.repetitive_schedule_id
665: AND out_wmta.transaction_id IN (
666: SELECT transaction_id

Line 668: wip_move_txn_allocations wmta

664: AND out_wmta.repetitive_schedule_id = p_purge_request.repetitive_schedule_id
665: AND out_wmta.transaction_id IN (
666: SELECT transaction_id
667: FROM wip_repetitive_schedules wrs,
668: wip_move_txn_allocations wmta
669: WHERE wmta.transaction_id = out_wmta.transaction_id
670: AND wmta.repetitive_schedule_id <> out_wmta.repetitive_schedule_id
671: AND nvl(wrs.date_closed, p_cutoff_date+1) <= p_cutoff_date
672: AND wrs.repetitive_schedule_id = wmta.repetitive_schedule_id

Line 686: x_purge_rec.table_name := 'WIP_MOVE_TXN_ALLOCATIONS';

682: p_purge_rec => x_purge_rec);
683: l_num_rows := 0;
684:
685:
686: x_purge_rec.table_name := 'WIP_MOVE_TXN_ALLOCATIONS';
687:
688: savepoint wictpg_sp02;
689: DELETE FROM WIP_MOVE_TXN_ALLOCATIONS
690: WHERE TRANSACTION_ID IN (

Line 689: DELETE FROM WIP_MOVE_TXN_ALLOCATIONS

685:
686: x_purge_rec.table_name := 'WIP_MOVE_TXN_ALLOCATIONS';
687:
688: savepoint wictpg_sp02;
689: DELETE FROM WIP_MOVE_TXN_ALLOCATIONS
690: WHERE TRANSACTION_ID IN (
691: SELECT out_wmta.transaction_id
692: FROM wip_move_txn_allocations out_wmta
693: WHERE out_wmta.organization_id = p_purge_request.organization_id

Line 692: FROM wip_move_txn_allocations out_wmta

688: savepoint wictpg_sp02;
689: DELETE FROM WIP_MOVE_TXN_ALLOCATIONS
690: WHERE TRANSACTION_ID IN (
691: SELECT out_wmta.transaction_id
692: FROM wip_move_txn_allocations out_wmta
693: WHERE out_wmta.organization_id = p_purge_request.organization_id
694: AND out_wmta.repetitive_schedule_id = p_purge_request.repetitive_schedule_id
695: AND out_wmta.transaction_id IN (
696: SELECT transaction_id

Line 698: wip_move_txn_allocations wmta

694: AND out_wmta.repetitive_schedule_id = p_purge_request.repetitive_schedule_id
695: AND out_wmta.transaction_id IN (
696: SELECT transaction_id
697: FROM wip_repetitive_schedules wrs,
698: wip_move_txn_allocations wmta
699: WHERE wmta.transaction_id = out_wmta.transaction_id
700: AND wmta.repetitive_schedule_id <> out_wmta.repetitive_schedule_id
701: AND nvl(wrs.date_closed, p_cutoff_date+1) <= p_cutoff_date
702: AND wrs.repetitive_schedule_id = wmta.repetitive_schedule_id