DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on AP_INVOICE_LINES_ALL

Line 992: ap_invoice_lines_all lines,

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,
994: zx_party_tax_profile ptp
995: WHERE inv.invoice_id = p_upg_trx_info_rec.trx_id
996: AND fnd_curr.currency_code = inv.invoice_currency_code

Line 2072: ap_invoice_lines_all lines1,

2068: fnd_currencies fnd_curr,
2069: -- fnd_document_sequences fds,
2070: ap_invoice_distributions_all ap_dists,
2071: ap_invoice_distributions_all ap_dists1,
2072: ap_invoice_lines_all lines1,
2073: ap_invoice_lines_all lines,
2074: zx_rates_b rates,
2075: zx_regimes_b regimes,
2076: zx_taxes_b taxes,

Line 2073: ap_invoice_lines_all lines,

2069: -- fnd_document_sequences fds,
2070: ap_invoice_distributions_all ap_dists,
2071: ap_invoice_distributions_all ap_dists1,
2072: ap_invoice_lines_all lines1,
2073: ap_invoice_lines_all lines,
2074: zx_rates_b rates,
2075: zx_regimes_b regimes,
2076: zx_taxes_b taxes,
2077: zx_status_b status,

Line 3134: ap_invoice_lines_all lines,

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,
3136: zx_party_tax_profile ptp
3137: WHERE zxvalerr.other_doc_application_id = 200
3138: AND inv.invoice_id = zxvalerr.other_doc_trx_id

Line 4198: ap_invoice_lines_all lines1,

4194: fnd_currencies fnd_curr,
4195: -- fnd_document_sequences fds,
4196: ap_invoice_distributions_all ap_dists,
4197: ap_invoice_distributions_all ap_dists1,
4198: ap_invoice_lines_all lines1,
4199: ap_invoice_lines_all lines,
4200: zx_rates_b rates,
4201: zx_regimes_b regimes,
4202: zx_taxes_b taxes,

Line 4199: ap_invoice_lines_all lines,

4195: -- fnd_document_sequences fds,
4196: ap_invoice_distributions_all ap_dists,
4197: ap_invoice_distributions_all ap_dists1,
4198: ap_invoice_lines_all lines1,
4199: ap_invoice_lines_all lines,
4200: zx_rates_b rates,
4201: zx_regimes_b regimes,
4202: zx_taxes_b taxes,
4203: zx_status_b status,