DBA Data[Home] [Help]

APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 2194: ZX_PARTY_TAX_PROFILE ptp,

2190: AR_SYSTEM_PARAMETERS_ALL arsysparam,
2191: RA_CUST_TRX_TYPES_ALL types,
2192: FND_CURRENCIES fndcurr,
2193: FND_DOCUMENT_SEQUENCES fds,
2194: ZX_PARTY_TAX_PROFILE ptp,
2195: RA_BATCH_SOURCES_ALL rbs,
2196: RA_CUSTOMER_TRX_ALL custtrx_prev,
2197: RA_CUSTOMER_TRX_LINES_ALL custtrxl_prev,
2198: RA_CUSTOMER_TRX_LINES_ALL custtrxl,

Line 2767: use_nl_with_index(PTP ZX_PARTY_TAX_PROFILE_U2) */

2763: ,1
2764: )
2765: SELECT /*+ ROWID(inv) NO_EXPAND ORDERED swap_join_inputs(upd) use_nl(fnd_curr,fds,poll)
2766: use_nl_with_index(lines AP_INVOICE_LINES_U1)
2767: use_nl_with_index(PTP ZX_PARTY_TAX_PROFILE_U2) */
2768: NVL(lines.org_id,-99) INTERNAL_ORGANIZATION_ID
2769: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2770: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
2771: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937

Line 3010: zx_party_tax_profile ptp

3006: fnd_currencies fnd_curr,
3007: fnd_document_sequences fds,
3008: ap_invoice_lines_all lines,
3009: po_line_locations_all poll,
3010: zx_party_tax_profile ptp
3011: WHERE inv.rowid BETWEEN p_start_rowid AND p_end_rowid
3012: AND upd.ledger_id = inv.set_of_books_id
3013: AND (TRUNC(inv.invoice_date) between upd.start_date and upd.end_date)
3014: AND fnd_curr.currency_code = inv.invoice_currency_code

Line 3653: use_nl_with_index(ptp ZX_PARTY_TAX_PROFILE_U2) */

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,
3656: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
3657: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937

Line 3908: zx_party_tax_profile ptp

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
3911: AND (TRUNC(inv.invoice_date) between upd.start_date and upd.end_date)
3912: AND fnd_curr.currency_code = inv.invoice_currency_code

Line 4404: zx_party_tax_profile ptp,

4400: fnd_currencies fc,
4401: hr_organization_information oi,
4402: po_lines_all pol,
4403: po_line_locations_all poll,
4404: zx_party_tax_profile ptp,
4405: hr_locations_all hr
4406: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
4407: AND oi.organization_id(+) = poh.org_id
4408: AND oi.org_information_context(+) = 'Operating Unit Information'

Line 5091: zx_party_tax_profile ptp,

5087: ) poh,
5088: fnd_currencies fc,
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,

Line 5798: zx_party_tax_profile ptp,

5794: ) poh,
5795: fnd_currencies fc,
5796: po_lines_all pol,
5797: po_line_locations_all poll,
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,