[Home] [Help]
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
2208: AND custtrx.previous_customer_trx_id = custtrx_prev.customer_trx_id(+)
3645: SELECT /*+ ORDERED NO_EXPAND ROWID(inv) swap_join_inputs(upd) use_nl(fnd_curr)
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) */
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
3910: AND upd.ledger_id = inv.set_of_books_id
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
5099: AND pol.po_header_id = poll.po_header_id
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
5808: AND pol.po_header_id = poll.po_header_id