DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on AP_INVOICES_ALL

Line 989: FROM ap_invoices_all inv,

985: -- ,NULL SOURCE_TAX_LINE_ID
986: ,DECODE(lines.discarded_flag, 'Y', 'Y', 'N') CANCEL_FLAG
987: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
988: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
989: FROM ap_invoices_all inv,
990: fnd_currencies fnd_curr,
991: fnd_document_sequences fds,
992: ap_invoice_lines_all lines,
993: po_line_locations_all poll,

Line 2067: FROM ap_invoices_all inv,

2063: AND record_type_code = 'MIGRATED'
2064: AND tax_class = 'INPUT') RECOVERY_RATE_ID
2065: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
2066: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
2067: FROM ap_invoices_all inv,
2068: fnd_currencies fnd_curr,
2069: -- fnd_document_sequences fds,
2070: ap_invoice_distributions_all ap_dists,
2071: ap_invoice_distributions_all ap_dists1,

Line 3131: ap_invoices_all inv,

3127: ,DECODE(lines.discarded_flag, 'Y', 'Y', 'N') CANCEL_FLAG
3128: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
3129: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
3130: FROM ( select distinct other_doc_application_id,other_doc_trx_id from ZX_VALIDATION_ERRORS_GT ) zxvalerr, --Bug 5187701
3131: ap_invoices_all inv,
3132: fnd_currencies fnd_curr,
3133: fnd_document_sequences fds,
3134: ap_invoice_lines_all lines,
3135: po_line_locations_all poll,

Line 4193: ap_invoices_all inv,

4189: AND tax_class = 'INPUT') RECOVERY_RATE_ID
4190: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
4191: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
4192: FROM ( select distinct other_doc_application_id,other_doc_trx_id from ZX_VALIDATION_ERRORS_GT ) zxvalerr, --Bug 5187701
4193: ap_invoices_all inv,
4194: fnd_currencies fnd_curr,
4195: -- fnd_document_sequences fds,
4196: ap_invoice_distributions_all ap_dists,
4197: ap_invoice_distributions_all ap_dists1,