eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_WICTPG dependencies on WIP_TXN_ALLOCATIONS

Line 873: x_purge_rec.table_name := 'WIP_TXN_ALLOCATIONS';

869:
870: -- verify that no other schedules exists
871: fnd_message.set_name('WIP', 'WIP_TRANSACTIONS_PURGE_ERROR');
872: x_purge_rec.info := fnd_message.get;
873: x_purge_rec.table_name := 'WIP_TXN_ALLOCATIONS';
874:
875: SELECT COUNT(*) into l_num_rows
876: FROM DUAL WHERE EXISTS (
877: SELECT out_wta.transaction_id

Line 878: FROM wip_txn_allocations out_wta

874:
875: SELECT COUNT(*) into l_num_rows
876: FROM DUAL WHERE EXISTS (
877: SELECT out_wta.transaction_id
878: FROM wip_txn_allocations out_wta
879: WHERE out_wta.organization_id = p_purge_request.organization_id
880: AND out_wta.repetitive_schedule_id = p_purge_request.repetitive_schedule_id
881: AND out_wta.transaction_id IN (
882: SELECT transaction_id

Line 884: wip_txn_allocations wta

880: AND out_wta.repetitive_schedule_id = p_purge_request.repetitive_schedule_id
881: AND out_wta.transaction_id IN (
882: SELECT transaction_id
883: FROM wip_repetitive_schedules wrs,
884: wip_txn_allocations wta
885: WHERE wta.transaction_id = out_wta.transaction_id
886: AND wta.repetitive_schedule_id <> out_wta.repetitive_schedule_id
887: AND nvl(wrs.date_closed, p_cutoff_date+1) > p_cutoff_date
888: AND wrs.repetitive_schedule_id = wta.repetitive_schedule_id

Line 915: FROM wip_txn_allocations out_wta

911: savepoint sched_cost01;
912: DELETE FROM WIP_TRANSACTIONS
913: WHERE TRANSACTION_ID IN (
914: SELECT out_wta.transaction_id
915: FROM wip_txn_allocations out_wta
916: WHERE out_wta.organization_id = p_purge_request.organization_id
917: AND out_wta.repetitive_schedule_id = p_purge_request.repetitive_schedule_id
918: AND NOT EXISTS (
919: SELECT transaction_id

Line 921: wip_txn_allocations wta

917: AND out_wta.repetitive_schedule_id = p_purge_request.repetitive_schedule_id
918: AND NOT EXISTS (
919: SELECT transaction_id
920: FROM wip_repetitive_schedules wrs,
921: wip_txn_allocations wta
922: WHERE wta.transaction_id = out_wta.transaction_id
923: AND wta.repetitive_schedule_id <> out_wta.repetitive_schedule_id
924: AND nvl(wrs.date_closed, p_cutoff_date+1) <= p_cutoff_date
925: AND wrs.repetitive_schedule_id = wta.repetitive_schedule_id

Line 945: FROM wip_txn_allocations out_wta

941: savepoint sched_cost02;
942: DELETE FROM WIP_TRANSACTION_ACCOUNTS
943: WHERE TRANSACTION_ID IN (
944: SELECT out_wta.transaction_id
945: FROM wip_txn_allocations out_wta
946: WHERE out_wta.organization_id = p_purge_request.organization_id
947: AND out_wta.repetitive_schedule_id = p_purge_request.repetitive_schedule_id
948: AND NOT EXISTS (
949: SELECT transaction_id

Line 951: wip_txn_allocations wta

947: AND out_wta.repetitive_schedule_id = p_purge_request.repetitive_schedule_id
948: AND NOT EXISTS (
949: SELECT transaction_id
950: FROM wip_repetitive_schedules wrs,
951: wip_txn_allocations wta
952: WHERE wta.transaction_id = out_wta.transaction_id
953: AND wta.repetitive_schedule_id <> out_wta.repetitive_schedule_id
954: AND nvl(wrs.date_closed, p_cutoff_date+1) <= p_cutoff_date
955: AND wrs.repetitive_schedule_id = wta.repetitive_schedule_id

Line 969: x_purge_rec.table_name := 'WIP_TXN_ALLOCATIONS';

965: p_purge_rec => x_purge_rec);
966: l_num_rows := 0;
967:
968:
969: x_purge_rec.table_name := 'WIP_TXN_ALLOCATIONS';
970:
971: savepoint sched_cost03;
972: DELETE FROM WIP_TXN_ALLOCATIONS
973: WHERE TRANSACTION_ID IN (

Line 972: DELETE FROM WIP_TXN_ALLOCATIONS

968:
969: x_purge_rec.table_name := 'WIP_TXN_ALLOCATIONS';
970:
971: savepoint sched_cost03;
972: DELETE FROM WIP_TXN_ALLOCATIONS
973: WHERE TRANSACTION_ID IN (
974: SELECT out_wta.transaction_id
975: FROM wip_txn_allocations out_wta
976: WHERE out_wta.organization_id = p_purge_request.organization_id

Line 975: FROM wip_txn_allocations out_wta

971: savepoint sched_cost03;
972: DELETE FROM WIP_TXN_ALLOCATIONS
973: WHERE TRANSACTION_ID IN (
974: SELECT out_wta.transaction_id
975: FROM wip_txn_allocations out_wta
976: WHERE out_wta.organization_id = p_purge_request.organization_id
977: AND out_wta.repetitive_schedule_id = p_purge_request.repetitive_schedule_id
978: AND NOT EXISTS (
979: SELECT transaction_id

Line 981: wip_txn_allocations wta

977: AND out_wta.repetitive_schedule_id = p_purge_request.repetitive_schedule_id
978: AND NOT EXISTS (
979: SELECT transaction_id
980: FROM wip_repetitive_schedules wrs,
981: wip_txn_allocations wta
982: WHERE wta.transaction_id = out_wta.transaction_id
983: AND wta.repetitive_schedule_id <> out_wta.repetitive_schedule_id
984: AND nvl(wrs.date_closed, p_cutoff_date+1) <= p_cutoff_date
985: AND wrs.repetitive_schedule_id = wta.repetitive_schedule_id