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 PO_DISTRIBUTIONS_ALL

Line 1124: x_purge_rec.table_name := 'PO_DISTRIBUTIONS_ALL';

1120: append_report(x_purge_rec, p_option);
1121: end if;
1122:
1123:
1124: x_purge_rec.table_name := 'PO_DISTRIBUTIONS_ALL';
1125:
1126:
1127: SELECT COUNT(*)
1128: into x_records_returned

Line 1132: FROM PO_DISTRIBUTIONS_ALL

1128: into x_records_returned
1129: FROM DUAL
1130: WHERE EXISTS
1131: (SELECT 1
1132: FROM PO_DISTRIBUTIONS_ALL
1133: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
1134: /* Fixed bug 3115844 */
1135: AND po_line_id IS NOT NULL
1136: AND line_location_id IS NOT NULL);

Line 2042: x_purge_rec.table_name := 'PO_DISTRIBUTIONS_ALL';

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
2044: FROM DUAL
2045: WHERE EXISTS (SELECT 1
2046: FROM PO_DISTRIBUTIONS_ALL

Line 2046: FROM PO_DISTRIBUTIONS_ALL

2042: x_purge_rec.table_name := 'PO_DISTRIBUTIONS_ALL';
2043: SELECT COUNT(*) into l_num_rows
2044: FROM DUAL
2045: WHERE EXISTS (SELECT 1
2046: FROM PO_DISTRIBUTIONS_ALL
2047: WHERE WIP_REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
2048: AND WIP_ENTITY_ID = x_purge_rec.wip_entity_id
2049: /* Fixed bug 3115844 */
2050: AND po_line_id IS NOT NULL