[Home] [Help]
2196: RA_CUSTOMER_TRX_ALL custtrx_prev,
2197: RA_CUSTOMER_TRX_LINES_ALL custtrxl_prev,
2198: RA_CUSTOMER_TRX_LINES_ALL custtrxl,
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,
3646: use_nl_with_index(ap_dists AP_INVOICE_DISTRIBUTIONS_N27)
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
3883: rates.offset_tax_rate_code, NULL) OFFSET_TAX_RATE_CODE
3884: ,NVL(rates.def_rec_settlement_option_code,
3885: taxes.def_rec_settlement_option_code) DEF_REC_SETTLEMENT_OPTION_CODE
3886: ,rates.tax_rate_id ACCOUNT_SOURCE_TAX_RATE_ID
3887: ,(SELECT tax_rate_id FROM zx_rates_b
3888: WHERE tax_rate_code = 'AD_HOC_RECOVERY'
3889: AND rate_type_code = 'RECOVERY'
3890: AND tax_regime_code = rates.tax_regime_code
3891: AND tax = rates.tax
3900: ap_inv_dists_target ap_dists,
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
5089: po_lines_all pol,
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(+)
5798: zx_party_tax_profile ptp,
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(+)
6124: ) RECOVERY_RATE_CODE,
6125: DECODE(tmp.rec_flag,'N', NULL,
6126: NVL(rates.tax_rate_id,
6127: (SELECT tax_rate_id
6128: FROM zx_rates_b zrb
6129: WHERE zrb.tax_rate_code = 'AD_HOC_RECOVERY'
6130: AND zrb.tax_regime_code = pohzd.tax_regime_code
6131: AND zrb.tax = pohzd.tax
6132: AND zrb.content_owner_id = pohzd.content_owner_id
6298: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
6299: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
6300: ) pohzd,
6301: fnd_currencies fc,
6302: zx_rates_b rates,
6303: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
6304: WHERE pohzd.trx_currency_code = fc.currency_code(+)
6305: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
6306: AND rates.tax(+) = pohzd.tax