[Home] [Help]
447: AND oi.organization_id(+) = poh.org_id
448: AND oi.org_information_context(+) = 'Operating Unit Information'
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(+)
1140: AND oi.organization_id(+) = poh.org_id
1141: AND oi.org_information_context(+) = 'Operating Unit Information'
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,
1853: AND oi.organization_id(+) = poh.org_id
1854: AND oi.org_information_context(+) = 'Operating Unit Information'
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,
2757: AND oi.organization_id(+) = poh.org_id
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
3460: AND oi.organization_id(+) = poh.org_id
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,
4185: AND oi.organization_id(+) = poh.org_id
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,
5158: AND oi.organization_id(+) = poh.org_id
5159: AND oi.org_information_context(+) = 'Operating Unit Information'
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(+)
5848: AND oi.organization_id(+) = poh.org_id
5849: AND oi.org_information_context(+) = 'Operating Unit Information'
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,
6559: AND oi.organization_id(+) = poh.org_id
6560: AND oi.org_information_context(+) = 'Operating Unit Information'
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,
7455: AND oi.organization_id(+) = poh.org_id
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
8155: AND oi.organization_id(+) = poh.org_id
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,
8875: AND oi.organization_id(+) = poh.org_id
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,