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.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on AP_INVOICES_ALL

Line 61: ap_invoices_all ai

57: SELECT xle_etb.establishment_id
58: INTO l_estb_id
59: FROM zx_party_tax_profile ptp,
60: xle_etb_profiles xle_etb,
61: ap_invoices_all ai
62: WHERE ai.invoice_id = p_upg_trx_info_rec.trx_id
63: AND ptp.party_id = xle_etb.party_id
64: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
65: AND xle_etb.legal_entity_id = ai.legal_entity_id

Line 1015: FROM ap_invoices_all inv,

1011: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','PRORATED_TB','STANDARD_TB') TAXABLE_BASIS_FORMULA --Bug 9037817
1012: ,DECODE(lines.discarded_flag, 'Y', 'Y', 'N') CANCEL_FLAG
1013: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
1014: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
1015: FROM ap_invoices_all inv,
1016: fnd_currencies fnd_curr,
1017: fnd_document_sequences fds,
1018: ap_invoice_lines_all lines,
1019: po_line_locations_all poll,

Line 2116: FROM ap_invoices_all inv,

2112: AND record_type_code = 'MIGRATED'
2113: AND tax_class = 'INPUT') RECOVERY_RATE_ID
2114: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
2115: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
2116: FROM ap_invoices_all inv,
2117: fnd_currencies fnd_curr,
2118: -- fnd_document_sequences fds,
2119: ap_invoice_distributions_all ap_dists,
2120: ap_invoice_distributions_all ap_dists1,

Line 3182: ap_invoices_all inv,

3178: ,DECODE(lines.discarded_flag, 'Y', 'Y', 'N') CANCEL_FLAG
3179: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
3180: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
3181: FROM ( select distinct other_doc_application_id,other_doc_trx_id from ZX_VALIDATION_ERRORS_GT ) zxvalerr, --Bug 5187701
3182: ap_invoices_all inv,
3183: fnd_currencies fnd_curr,
3184: fnd_document_sequences fds,
3185: ap_invoice_lines_all lines,
3186: po_line_locations_all poll,

Line 4260: ap_invoices_all inv,

4256: AND tax_class = 'INPUT') RECOVERY_RATE_ID
4257: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
4258: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
4259: FROM ( select distinct other_doc_application_id,other_doc_trx_id from ZX_VALIDATION_ERRORS_GT ) zxvalerr, --Bug 5187701
4260: ap_invoices_all inv,
4261: fnd_currencies fnd_curr,
4262: -- fnd_document_sequences fds,
4263: ap_invoice_distributions_all ap_dists,
4264: ap_invoice_distributions_all ap_dists1,