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_REPETITIVE_SCHEDULES

Line 451: AND ENTITY_NAME = 'WIP_REPETITIVE_SCHEDULES'

447: from FND_ATTACHED_DOCUMENTS
448: WHERE PK1_VALUE = to_char(x_purge_rec.wip_entity_id)
449: AND PK3_VALUE = to_char(x_purge_rec.org_id)
450: AND ( ( PK2_VALUE = to_char(x_purge_rec.schedule_id)
451: AND ENTITY_NAME = 'WIP_REPETITIVE_SCHEDULES'
452: )
453: OR ( PK4_VALUE = to_char(x_purge_rec.schedule_id)
454: AND ENTITY_NAME = 'WIP_REPETITIVE_OPERATIONS'
455: )

Line 479: X_entity_name => 'WIP_REPETITIVE_SCHEDULES',

475: X_pk4_value => to_char(x_purge_rec.schedule_id),
476: X_delete_document_flag => 'Y' );
477:
478: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(
479: X_entity_name => 'WIP_REPETITIVE_SCHEDULES',
480: X_pk1_value => to_char(x_purge_rec.wip_entity_id),
481: X_pk2_value => to_char(x_purge_rec.schedule_id),
482: X_pk3_value => to_char(x_purge_rec.org_id),
483: X_delete_document_flag => 'Y' );

Line 631: FROM wip_repetitive_schedules wrs,

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
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

Line 667: FROM wip_repetitive_schedules wrs,

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
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

Line 697: FROM wip_repetitive_schedules wrs,

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
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

Line 883: FROM wip_repetitive_schedules wrs,

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
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

Line 920: FROM wip_repetitive_schedules wrs,

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
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 /*Fixed for bug 7375928 (FP of 7120544)*/

Line 950: FROM wip_repetitive_schedules wrs,

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
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 /*Fixed for bug 7375928 (FP of 7120544)*/

Line 980: FROM wip_repetitive_schedules wrs,

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
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 /*Fixed for bug 7375928 (FP of 7120544)*/

Line 2039: fnd_message.set_token('TABLE', 'WIP_REPETITIVE_SCHEDULES', TRUE);

2035: l_num_rows := 0;
2036:
2037: -- reset message; check for foreign key references
2038: fnd_message.set_name('WIP', 'WIP_PURGE_FOREIGN_KEY');
2039: fnd_message.set_token('TABLE', 'WIP_REPETITIVE_SCHEDULES', TRUE);
2040: x_purge_rec.info := fnd_message.get;
2041:
2042: x_purge_rec.table_name := 'PO_DISTRIBUTIONS_ALL';
2043: SELECT COUNT(*) into l_num_rows

Line 2247: x_purge_rec.table_name := 'WIP_REPETITIVE_SCHEDULES';

2243: p_purge_rec => x_purge_rec,
2244: num_rows => x_num_rows);
2245: end if;
2246:
2247: x_purge_rec.table_name := 'WIP_REPETITIVE_SCHEDULES';
2248: if (p_option = REPORT_ONLY) then
2249: SELECT COUNT(*) INTO x_num_rows
2250: FROM WIP_REPETITIVE_SCHEDULES
2251: WHERE REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id;

Line 2250: FROM WIP_REPETITIVE_SCHEDULES

2246:
2247: x_purge_rec.table_name := 'WIP_REPETITIVE_SCHEDULES';
2248: if (p_option = REPORT_ONLY) then
2249: SELECT COUNT(*) INTO x_num_rows
2250: FROM WIP_REPETITIVE_SCHEDULES
2251: WHERE REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id;
2252: else
2253: DELETE FROM WIP_REPETITIVE_SCHEDULES
2254: WHERE REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id;

Line 2253: DELETE FROM WIP_REPETITIVE_SCHEDULES

2249: SELECT COUNT(*) INTO x_num_rows
2250: FROM WIP_REPETITIVE_SCHEDULES
2251: WHERE REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id;
2252: else
2253: DELETE FROM WIP_REPETITIVE_SCHEDULES
2254: WHERE REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id;
2255: x_num_rows := SQL%ROWCOUNT ;
2256: end if ;
2257:

Line 2454: ' from wip_repetitive_schedules wrs , ' ||

2450: ' wrs.last_unit_completion_date, ' ||
2451: ' wrs.date_closed, ' ||
2452: ' wrs.status_type, ' ||
2453: ' wrs.organization_id ' ||
2454: ' from wip_repetitive_schedules wrs , ' ||
2455: ' wip_repetitive_items wri ' ||
2456: /* Fix for bug#4902938 - Convert Literal to Bind variable*/
2457: ' where wri.organization_id = :l_organization_id' ||
2458: ' and wrs.organization_id = wri.organization_id ' ||