[Home] [Help]
2199: AR_VAT_TAX_ALL_B vat,
2200: ZX_RATES_B rates ,
2201: RA_CUSTOMER_TRX_LINES_ALL custtrxll, -- retrieve the trx line for tax lines
2202: AR_MEMO_LINES_ALL_B memoline,
2203: ZX_REGIMES_B regimes,
2204: ZX_TAXES_B taxes,
2205: ZX_STATUS_B status
2206: WHERE custtrx.rowid BETWEEN p_start_rowid AND p_end_rowid
2207: AND custtrx.customer_trx_id = custtrxl.customer_trx_id
3647: use_nl_with_index(ap_dists1 AP_INVOICE_DISTRIBUTIONS_U2)
3648: use_nl_with_index(lines1 AP_INVOICE_LINES_U1)
3649: use_nl_with_index(taxes ZX_TAXES_B_U2)
3650: use_nl_with_index(rates ZX_RATES_B_N2)
3651: use_nl_with_index(regimes ZX_REGIMES_B_U2)
3652: use_nl_with_index(status ZX_STATUS_B_U2)
3653: use_nl_with_index(ptp ZX_PARTY_TAX_PROFILE_U2) */
3654: NVL(lines1.org_id,-99) INTERNAL_ORGANIZATION_ID
3655: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3901: ap_inv_dists_target ap_dists1,
3902: ap_invoice_lines_all lines1,
3903: ap_invoice_lines_all lines,
3904: zx_rates_b rates,
3905: zx_regimes_b regimes,
3906: zx_taxes_b taxes,
3907: zx_status_b status,
3908: zx_party_tax_profile ptp
3909: WHERE inv.rowid BETWEEN p_start_rowid AND p_end_rowid
5090: po_line_locations_all poll,
5091: zx_party_tax_profile ptp,
5092: ap_tax_codes_all atc,
5093: zx_rates_b rates,
5094: zx_regimes_b regimes,
5095: zx_taxes_b taxes,
5096: zx_status_b status
5097: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
5098: AND poh.po_header_id = pol.po_header_id
5799: ap_tax_codes_all atc,
5800: ar_tax_group_codes_all atg,
5801: ap_tax_codes_all atc1,
5802: zx_rates_b rates,
5803: zx_regimes_b regimes,
5804: zx_taxes_b taxes,
5805: zx_status_b status
5806: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
5807: AND poh.po_header_id = pol.po_header_id