[Home] [Help]
481: AND oi.organization_id(+) = poh.org_id
482: AND oi.org_information_context(+) = 'Operating Unit Information'
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(+)
1170: AND oi.organization_id(+) = poh.org_id
1171: AND oi.org_information_context(+) = 'Operating Unit Information'
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,
1879: AND oi.organization_id(+) = poh.org_id
1880: AND oi.org_information_context(+) = 'Operating Unit Information'
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,
2818: AND oi.organization_id(+) = poh.org_id
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
3518: AND oi.organization_id(+) = poh.org_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,
4240: AND oi.organization_id(+) = poh.org_id
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,
5247: AND oi.organization_id(+) = poh.org_id
5248: AND oi.org_information_context(+) = 'Operating Unit Information'
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(+)
5934: AND oi.organization_id(+) = poh.org_id
5935: AND oi.org_information_context(+) = 'Operating Unit Information'
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,
6642: AND oi.organization_id(+) = poh.org_id
6643: AND oi.org_information_context(+) = 'Operating Unit Information'
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,
7570: AND oi.organization_id(+) = poh.org_id
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
8267: AND oi.organization_id(+) = poh.org_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,
8984: AND oi.organization_id(+) = poh.org_id
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,