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.AP_WEB_ARCHIVE_PURGE_ER dependencies on AP_EXP_REPORT_HEADERS_GT

Line 19: insert into AP_EXP_REPORT_HEADERS_GT

15: ---------------------------------------------------------------------
16: l_debug_info := 'Insert into the GT table.';
17: ---------------------------------------------------------------------
18: IF (p_org_id IS NULL) THEN
19: insert into AP_EXP_REPORT_HEADERS_GT
20: (report_header_id)
21: (select report_header_id
22: from
23: (

Line 42: insert into AP_EXP_REPORT_HEADERS_GT

38: and b.expense_status_code = 'PAID'
39: and trunc(b.creation_date) < p_source_date
40: ));
41: ELSE
42: insert into AP_EXP_REPORT_HEADERS_GT
43: (report_header_id)
44: (select report_header_id
45: from
46: (

Line 309: from ap_expense_report_headers_all a, AP_EXP_REPORT_HEADERS_GT gt

305: IMAGE_RECEIPTS_STATUS,
306: IMAGE_RECEIPTS_RECEIVED_DATE,
307: MISSING_IMG_JUST,
308: OVERDUE_REQUEST_ID
309: from ap_expense_report_headers_all a, AP_EXP_REPORT_HEADERS_GT gt
310: where gt.report_header_id = a.report_header_id);
311: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' Headers');
312:
313: -- Insert into Lines

Line 648: from ap_expense_report_lines_all a, AP_EXP_REPORT_HEADERS_GT gt

644: UOM_DAYS,
645: IMAGE_RECEIPT_REQUIRED_FLAG,
646: RECEIPTS_ISSUE,
647: ADJUSTMENT_REASON_COPY
648: from ap_expense_report_lines_all a, AP_EXP_REPORT_HEADERS_GT gt
649: where gt.report_header_id = a.report_header_id);
650:
651: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' Lines');
652:

Line 767: from ap_exp_report_dists_all a, AP_EXP_REPORT_HEADERS_GT gt

763: RECEIPT_CURRENCY_CODE,
764: RECEIPT_CONVERSION_RATE,
765: RECEIPT_CURRENCY_AMOUNT,
766: WEB_PARAMETER_ID
767: from ap_exp_report_dists_all a, AP_EXP_REPORT_HEADERS_GT gt
768: where gt.report_header_id = a.report_header_id);
769:
770: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' Dists');
771:

Line 1048: from ap_credit_card_trxns_all a, AP_EXP_REPORT_HEADERS_GT gt

1044: DESCRIPTION,
1045: COMPANY_NUMBER,
1046: MARKET_CODE,
1047: VALIDATE_REQUEST_ID
1048: from ap_credit_card_trxns_all a, AP_EXP_REPORT_HEADERS_GT gt
1049: where gt.report_header_id = a.report_header_id);
1050:
1051: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' CC Transactions');
1052:

Line 1090: from ap_cc_trx_details a, ap_credit_card_trxns_all b, AP_EXP_REPORT_HEADERS_GT gt

1086: A.FOLIO_TYPE,
1087: A.ITEM_SEQ_NUMBER,
1088: A.ITEM_DESCRIPTION,
1089: A.TRANSACTION_DATE
1090: from ap_cc_trx_details a, ap_credit_card_trxns_all b, AP_EXP_REPORT_HEADERS_GT gt
1091: where gt.report_header_id = b.report_header_id
1092: and a.trx_id = b.trx_id);
1093:
1094: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' CC Transaction Details');

Line 1126: from oie_addon_mileage_rates a, AP_EXP_REPORT_HEADERS_GT gt,

1122: A.LAST_UPDATED_BY,
1123: A.LAST_UPDATE_LOGIN,
1124: A.CREATED_BY,
1125: A.CREATION_DATE
1126: from oie_addon_mileage_rates a, AP_EXP_REPORT_HEADERS_GT gt,
1127: ap_expense_report_lines_all b
1128: where gt.report_header_id = b.report_header_id
1129: and a.report_line_id = b.report_line_id);
1130:

Line 1199: from oie_pdm_daily_breakups a, AP_EXP_REPORT_HEADERS_GT gt,

1195: A.CUST_MEALS_AMOUNT,
1196: A.CUST_ACCOMMODATION_AMOUNT,
1197: A.CUST_NIGHT_RATE_AMOUNT,
1198: A.CUST_PDM_RATE
1199: from oie_pdm_daily_breakups a, AP_EXP_REPORT_HEADERS_GT gt,
1200: ap_expense_report_lines_all b
1201: where gt.report_header_id = b.report_header_id
1202: and a.report_line_id = b.report_line_id);
1203:

Line 1236: from oie_pdm_destinations a, AP_EXP_REPORT_HEADERS_GT gt,

1232: A.LAST_UPDATED_BY,
1233: A.LAST_UPDATE_LOGIN,
1234: A.CREATED_BY,
1235: A.CREATION_DATE
1236: from oie_pdm_destinations a, AP_EXP_REPORT_HEADERS_GT gt,
1237: ap_expense_report_lines_all b
1238: where gt.report_header_id = b.report_header_id
1239: and a.report_line_id = b.report_line_id);
1240:

Line 1285: from oie_attendees_all a, AP_EXP_REPORT_HEADERS_GT gt,

1281: A.LAST_UPDATED_BY,
1282: A.CREATION_DATE,
1283: A.CREATED_BY,
1284: A.LAST_UPDATE_LOGIN
1285: from oie_attendees_all a, AP_EXP_REPORT_HEADERS_GT gt,
1286: ap_expense_report_lines_all b
1287: where gt.report_header_id = b.report_header_id
1288: and a.report_line_id = b.report_line_id);
1289:

Line 1318: from ap_aud_audit_reasons a, AP_EXP_REPORT_HEADERS_GT gt

1314: A.CREATED_BY,
1315: A.LAST_UPDATE_LOGIN,
1316: A.LAST_UPDATE_DATE,
1317: A.LAST_UPDATED_BY
1318: from ap_aud_audit_reasons a, AP_EXP_REPORT_HEADERS_GT gt
1319: where gt.report_header_id = a.report_header_id);
1320:
1321: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' Audit Reasons');
1322:

Line 1367: from ap_pol_violations_all a, AP_EXP_REPORT_HEADERS_GT gt

1363: A.VIOLATION_DATE,
1364: A.DUP_REPORT_HEADER_ID,
1365: A.DUP_REPORT_LINE_ID,
1366: A.DUP_DIST_LINE_NUMBER
1367: from ap_pol_violations_all a, AP_EXP_REPORT_HEADERS_GT gt
1368: where gt.report_header_id = a.report_header_id);
1369:
1370: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' Policy Violations');
1371:

Line 1408: from ap_notes a, AP_EXP_REPORT_HEADERS_GT gt

1404: A.CREATED_BY,
1405: A.LAST_UPDATE_DATE,
1406: A.LAST_UPDATED_BY,
1407: A.LAST_UPDATE_LOGIN
1408: from ap_notes a, AP_EXP_REPORT_HEADERS_GT gt
1409: where gt.report_header_id = a.source_object_id);
1410:
1411: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' Notes');
1412:

Line 1795: select count(*) into l_count from AP_EXP_REPORT_HEADERS_GT;

1791: fnd_file.put_line(fnd_file.log, ' ');
1792: fnd_file.put_line(fnd_file.log, ' ');
1793: fnd_file.put_line(fnd_file.log, ' ');
1794:
1795: select count(*) into l_count from AP_EXP_REPORT_HEADERS_GT;
1796:
1797: fnd_file.put_line(fnd_file.log, '=================================================================');
1798: fnd_file.put_line(fnd_file.log, 'Total Expenses processed: ' || l_count);
1799: fnd_file.put_line(fnd_file.log, '=================================================================');

Line 1801: delete from AP_EXP_REPORT_HEADERS_GT;

1797: fnd_file.put_line(fnd_file.log, '=================================================================');
1798: fnd_file.put_line(fnd_file.log, 'Total Expenses processed: ' || l_count);
1799: fnd_file.put_line(fnd_file.log, '=================================================================');
1800:
1801: delete from AP_EXP_REPORT_HEADERS_GT;
1802:
1803: fnd_file.put_line(fnd_file.log, '=================================================================');
1804: fnd_file.put_line(fnd_file.log, 'Cleared Temp Contents');
1805: fnd_file.put_line(fnd_file.log, '=================================================================');