DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_PO_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 453: zx_party_tax_profile ptp,

449: ) poh,
450: fnd_currencies fc,
451: po_lines_all pol,
452: po_line_locations_all poll,
453: zx_party_tax_profile ptp,
454: hr_locations_all hr
455: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
456: AND pol.po_header_id = poh.po_header_id
457: AND poll.po_header_id = pol.po_header_id

Line 1146: zx_party_tax_profile ptp,

1142: ) poh,
1143: fnd_currencies fc,
1144: po_lines_all pol,
1145: po_line_locations_all poll,
1146: zx_party_tax_profile ptp,
1147: ap_tax_codes_all atc,
1148: zx_rates_b rates,
1149: zx_regimes_b regimes,
1150: zx_taxes_b taxes,

Line 1859: zx_party_tax_profile ptp,

1855: ) poh,
1856: fnd_currencies fc,
1857: po_lines_all pol,
1858: po_line_locations_all poll,
1859: zx_party_tax_profile ptp,
1860: ap_tax_codes_all atc,
1861: ar_tax_group_codes_all atg,
1862: ap_tax_codes_all atc1,
1863: zx_rates_b rates,

Line 2762: zx_party_tax_profile ptp,

2758: AND oi.org_information_context(+) = 'Operating Unit Information'
2759: ) poll,
2760: fnd_currencies fc,
2761: po_lines_all pol,
2762: zx_party_tax_profile ptp,
2763: hr_locations_all hr
2764: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)
2765: AND pol.po_header_id = poll.po_header_id
2766: AND pol.po_line_id = poll.po_line_id

Line 3465: zx_party_tax_profile ptp,

3461: AND oi.org_information_context(+) = 'Operating Unit Information'
3462: ) poll,
3463: fnd_currencies fc,
3464: po_lines_all pol,
3465: zx_party_tax_profile ptp,
3466: ap_tax_codes_all atc,
3467: zx_rates_b rates,
3468: zx_regimes_b regimes,
3469: zx_taxes_b taxes,

Line 4190: zx_party_tax_profile ptp,

4186: AND oi.org_information_context(+) = 'Operating Unit Information'
4187: ) poll,
4188: fnd_currencies fc,
4189: po_lines_all pol,
4190: zx_party_tax_profile ptp,
4191: ap_tax_codes_all atc,
4192: ar_tax_group_codes_all atg,
4193: ap_tax_codes_all atc1,
4194: zx_rates_b rates,

Line 5164: zx_party_tax_profile ptp,

5160: ) poh,
5161: fnd_currencies fc,
5162: po_lines_all pol,
5163: po_line_locations_all poll,
5164: zx_party_tax_profile ptp,
5165: hr_locations_all hr
5166: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
5167: AND pol.po_header_id = poh.po_header_id
5168: AND poll.po_header_id = pol.po_header_id

Line 5854: zx_party_tax_profile ptp,

5850: ) poh,
5851: fnd_currencies fc,
5852: po_lines_all pol,
5853: po_line_locations_all poll,
5854: zx_party_tax_profile ptp,
5855: ap_tax_codes_all atc,
5856: zx_rates_b rates,
5857: zx_regimes_b regimes,
5858: zx_taxes_b taxes,

Line 6565: zx_party_tax_profile ptp,

6561: ) poh,
6562: fnd_currencies fc,
6563: po_lines_all pol,
6564: po_line_locations_all poll,
6565: zx_party_tax_profile ptp,
6566: ap_tax_codes_all atc,
6567: ar_tax_group_codes_all atg,
6568: ap_tax_codes_all atc1,
6569: zx_rates_b rates,

Line 7460: zx_party_tax_profile ptp,

7456: AND oi.org_information_context(+) = 'Operating Unit Information'
7457: ) poll,
7458: fnd_currencies fc,
7459: po_lines_all pol,
7460: zx_party_tax_profile ptp,
7461: hr_locations_all hr
7462: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)
7463: AND pol.po_header_id = poll.po_header_id
7464: AND pol.po_line_id = poll.po_line_id

Line 8160: zx_party_tax_profile ptp,

8156: AND oi.org_information_context(+) = 'Operating Unit Information'
8157: ) poll,
8158: fnd_currencies fc,
8159: po_lines_all pol,
8160: zx_party_tax_profile ptp,
8161: ap_tax_codes_all atc,
8162: zx_rates_b rates,
8163: zx_regimes_b regimes,
8164: zx_taxes_b taxes,

Line 8880: zx_party_tax_profile ptp,

8876: AND oi.org_information_context(+) = 'Operating Unit Information'
8877: ) poll,
8878: fnd_currencies fc,
8879: po_lines_all pol,
8880: zx_party_tax_profile ptp,
8881: ap_tax_codes_all atc,
8882: ar_tax_group_codes_all atg,
8883: ap_tax_codes_all atc1,
8884: zx_rates_b rates,