[Home] [Help]
54: -- Populating the Establishment ID
55: BEGIN
56: SELECT xle_etb.establishment_id
57: INTO l_estb_id
58: FROM zx_party_tax_profile ptp,
59: xle_etb_profiles xle_etb,
60: (SELECT oi.org_information2 oi_org_information2,poh.last_update_date
61: FROM po_headers_all poh,
62: financials_system_params_all fsp,
483: ) poh,
484: fnd_currencies fc,
485: po_lines_all pol,
486: po_line_locations_all poll,
487: zx_party_tax_profile ptp,
488: hr_locations_all hr
489: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
490: AND pol.po_header_id = poh.po_header_id
491: AND poll.po_header_id = pol.po_header_id
1172: ) poh,
1173: fnd_currencies fc,
1174: po_lines_all pol,
1175: po_line_locations_all poll,
1176: zx_party_tax_profile ptp,
1177: ap_tax_codes_all atc,
1178: zx_rates_b rates,
1179: zx_regimes_b regimes,
1180: zx_taxes_b taxes,
1881: ) poh,
1882: fnd_currencies fc,
1883: po_lines_all pol,
1884: po_line_locations_all poll,
1885: zx_party_tax_profile ptp,
1886: ap_tax_codes_all atc,
1887: ar_tax_group_codes_all atg,
1888: ap_tax_codes_all atc1,
1889: zx_rates_b rates,
2819: AND oi.org_information_context(+) = 'Operating Unit Information'
2820: ) poll,
2821: fnd_currencies fc,
2822: po_lines_all pol,
2823: zx_party_tax_profile ptp,
2824: hr_locations_all hr
2825: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)
2826: AND pol.po_header_id = poll.po_header_id
2827: AND pol.po_line_id = poll.po_line_id
3519: AND oi.org_information_context(+) = 'Operating Unit Information'
3520: ) poll,
3521: fnd_currencies fc,
3522: po_lines_all pol,
3523: zx_party_tax_profile ptp,
3524: ap_tax_codes_all atc,
3525: zx_rates_b rates,
3526: zx_regimes_b regimes,
3527: zx_taxes_b taxes,
4241: AND oi.org_information_context(+) = 'Operating Unit Information'
4242: ) poll,
4243: fnd_currencies fc,
4244: po_lines_all pol,
4245: zx_party_tax_profile ptp,
4246: ap_tax_codes_all atc,
4247: ar_tax_group_codes_all atg,
4248: ap_tax_codes_all atc1,
4249: zx_rates_b rates,
5249: ) poh,
5250: fnd_currencies fc,
5251: po_lines_all pol,
5252: po_line_locations_all poll,
5253: zx_party_tax_profile ptp,
5254: hr_locations_all hr
5255: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
5256: AND pol.po_header_id = poh.po_header_id
5257: AND poll.po_header_id = pol.po_header_id
5936: ) poh,
5937: fnd_currencies fc,
5938: po_lines_all pol,
5939: po_line_locations_all poll,
5940: zx_party_tax_profile ptp,
5941: ap_tax_codes_all atc,
5942: zx_rates_b rates,
5943: zx_regimes_b regimes,
5944: zx_taxes_b taxes,
6644: ) poh,
6645: fnd_currencies fc,
6646: po_lines_all pol,
6647: po_line_locations_all poll,
6648: zx_party_tax_profile ptp,
6649: ap_tax_codes_all atc,
6650: ar_tax_group_codes_all atg,
6651: ap_tax_codes_all atc1,
6652: zx_rates_b rates,
7571: AND oi.org_information_context(+) = 'Operating Unit Information'
7572: ) poll,
7573: fnd_currencies fc,
7574: po_lines_all pol,
7575: zx_party_tax_profile ptp,
7576: hr_locations_all hr
7577: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)
7578: AND pol.po_header_id = poll.po_header_id
7579: AND pol.po_line_id = poll.po_line_id
8268: AND oi.org_information_context(+) = 'Operating Unit Information'
8269: ) poll,
8270: fnd_currencies fc,
8271: po_lines_all pol,
8272: zx_party_tax_profile ptp,
8273: ap_tax_codes_all atc,
8274: zx_rates_b rates,
8275: zx_regimes_b regimes,
8276: zx_taxes_b taxes,
8985: AND oi.org_information_context(+) = 'Operating Unit Information'
8986: ) poll,
8987: fnd_currencies fc,
8988: po_lines_all pol,
8989: zx_party_tax_profile ptp,
8990: ap_tax_codes_all atc,
8991: ar_tax_group_codes_all atg,
8992: ap_tax_codes_all atc1,
8993: zx_rates_b rates,