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.OZF_RESALE_PVT dependencies on OZF_RESALE_LINES_INT_ALL

Line 1343: DELETE FROM ozf_resale_lines_int_all a

1339: -- Purge the records that have been successfully processed
1340: IF p_data_source_code IS NULL OR
1341: p_data_source_code = 'ALL' THEN
1342: BEGIN
1343: DELETE FROM ozf_resale_lines_int_all a
1344: WHERE a.resale_batch_id IN (
1345: SELECT b.resale_batch_id
1346: FROM ozf_resale_batches b
1347: WHERE b.purge_flag IS NULL

Line 1361: DELETE FROM ozf_resale_lines_int_all a

1357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1358: END;
1359: ELSE
1360: BEGIN
1361: DELETE FROM ozf_resale_lines_int_all a
1362: WHERE a.data_source_code = p_data_source_code
1363: AND a.resale_batch_id IN (
1364: SELECT b.resale_batch_id
1365: FROM ozf_resale_batches b

Line 1386: DELETE FROM ozf_resale_lines_int_all a

1382: -- Purge the records that have been successfully processed
1383: IF p_data_source_code IS NULL OR
1384: p_data_source_code = 'ALL' THEN
1385: BEGIN
1386: DELETE FROM ozf_resale_lines_int_all a
1387: WHERE a.resale_batch_id IN (
1388: SELECT b.resale_batch_id
1389: FROM ozf_resale_batches b
1390: WHERE b.purge_flag IS NULL

Line 1404: DELETE FROM ozf_resale_lines_int_all a

1400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1401: END;
1402: ELSE
1403: BEGIN
1404: DELETE FROM ozf_resale_lines_int_all a
1405: WHERE a.data_source_code = p_data_source_code
1406: AND a.resale_batch_id IN (
1407: SELECT b.resale_batch_id
1408: FROM ozf_resale_batches b