APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on ZX_VALIDATION_ERRORS_GT

Line 3181: FROM ( select distinct other_doc_application_id,other_doc_trx_id from ZX_VALIDATION_ERRORS_GT ) zxvalerr, --Bug 5187701

3177: -- ,NULL SOURCE_TAX_LINE_ID
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,

Line 4259: FROM ( select distinct other_doc_application_id,other_doc_trx_id from ZX_VALIDATION_ERRORS_GT ) zxvalerr, --Bug 5187701

4255: AND record_type_code = 'MIGRATED'
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,