DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on AP_INVOICE_LINES_ALL

Line 1018: ap_invoice_lines_all lines,

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,
1020: zx_party_tax_profile ptp
1021: WHERE inv.invoice_id = p_upg_trx_info_rec.trx_id
1022: AND fnd_curr.currency_code = inv.invoice_currency_code

Line 2121: ap_invoice_lines_all lines1,

2117: fnd_currencies fnd_curr,
2118: -- fnd_document_sequences fds,
2119: ap_invoice_distributions_all ap_dists,
2120: ap_invoice_distributions_all ap_dists1,
2121: ap_invoice_lines_all lines1,
2122: ap_invoice_lines_all lines,
2123: zx_rates_b rates,
2124: zx_regimes_b regimes,
2125: zx_taxes_b taxes,

Line 2122: ap_invoice_lines_all lines,

2118: -- fnd_document_sequences fds,
2119: ap_invoice_distributions_all ap_dists,
2120: ap_invoice_distributions_all ap_dists1,
2121: ap_invoice_lines_all lines1,
2122: ap_invoice_lines_all lines,
2123: zx_rates_b rates,
2124: zx_regimes_b regimes,
2125: zx_taxes_b taxes,
2126: zx_status_b status,

Line 3185: ap_invoice_lines_all lines,

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,
3187: zx_party_tax_profile ptp
3188: WHERE zxvalerr.other_doc_application_id = 200
3189: AND inv.invoice_id = zxvalerr.other_doc_trx_id

Line 4265: ap_invoice_lines_all lines1,

4261: fnd_currencies fnd_curr,
4262: -- fnd_document_sequences fds,
4263: ap_invoice_distributions_all ap_dists,
4264: ap_invoice_distributions_all ap_dists1,
4265: ap_invoice_lines_all lines1,
4266: ap_invoice_lines_all lines,
4267: zx_rates_b rates,
4268: zx_regimes_b regimes,
4269: zx_taxes_b taxes,

Line 4266: ap_invoice_lines_all lines,

4262: -- fnd_document_sequences fds,
4263: ap_invoice_distributions_all ap_dists,
4264: ap_invoice_distributions_all ap_dists1,
4265: ap_invoice_lines_all lines1,
4266: ap_invoice_lines_all lines,
4267: zx_rates_b rates,
4268: zx_regimes_b regimes,
4269: zx_taxes_b taxes,
4270: zx_status_b status,