DBA Data[Home] [Help]

APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on ZX_TAXES_B

Line 2147: ZX_TAXES_B taxes,

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
2151: AND custtrx.previous_customer_trx_id = custtrx_prev.customer_trx_id(+)

Line 3585: use_nl_with_index(taxes ZX_TAXES_B_U2)

3581: SELECT /*+ ORDERED NO_EXPAND ROWID(inv) swap_join_inputs(upd) use_nl(fnd_curr)
3582: use_nl_with_index(ap_dists AP_INVOICE_DISTRIBUTIONS_N27)
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) */

Line 3820: zx_taxes_b taxes,

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
3824: AND upd.ledger_id = inv.set_of_books_id

Line 5017: zx_taxes_b taxes,

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
5021: AND pol.po_header_id = poll.po_header_id