[Home] [Help]
2142: AR_VAT_TAX_ALL_B vat,
2143: ZX_RATES_B rates ,
2144: RA_CUSTOMER_TRX_LINES_ALL custtrxll, -- retrieve the trx line for tax lines
2145: AR_MEMO_LINES_ALL_B memoline,
2146: ZX_REGIMES_B regimes,
2147: ZX_TAXES_B taxes,
2148: ZX_STATUS_B status
2149: WHERE custtrx.rowid BETWEEN p_start_rowid AND p_end_rowid
2150: AND custtrx.customer_trx_id = custtrxl.customer_trx_id
3583: use_nl_with_index(ap_dists1 AP_INVOICE_DISTRIBUTIONS_U2)
3584: use_nl_with_index(lines AP_INVOICE_LINES_U1)
3585: use_nl_with_index(taxes ZX_TAXES_B_U2)
3586: use_nl_with_index(rates ZX_RATES_B_N2)
3587: use_nl_with_index(regimes ZX_REGIMES_B_U2)
3588: use_nl_with_index(status ZX_STATUS_B_U2)
3589: use_nl_with_index(ptp ZX_PARTY_TAX_PROFILE_U2) */
3590: NVL(lines1.org_id,-99) INTERNAL_ORGANIZATION_ID
3591: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3815: ap_inv_dists_target ap_dists1,
3816: ap_invoice_lines_all lines1,
3817: ap_invoice_lines_all lines,
3818: zx_rates_b rates,
3819: zx_regimes_b regimes,
3820: zx_taxes_b taxes,
3821: zx_status_b status,
3822: zx_party_tax_profile ptp
3823: WHERE inv.rowid BETWEEN p_start_rowid AND p_end_rowid
5012: zx_party_tax_profile ptp,
5013: ap_tax_codes_all atc,
5014: ar_tax_group_codes_all atg,
5015: zx_rates_b rates,
5016: zx_regimes_b regimes,
5017: zx_taxes_b taxes,
5018: zx_status_b status
5019: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
5020: AND poh.po_header_id = pol.po_header_id