[Home] [Help]
480: AND NVL(aps.org_id, -99) = NVL(poh.org_id, -99)
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
1169: AND aps.set_of_books_id = fsp.set_of_books_id
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,
1878: AND aps.set_of_books_id = fsp.set_of_books_id
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,
2382: AND recdist.po_line_location_id(+) = pohzd.trx_line_id
2383: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
2384: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
2385: ) pohzd,
2386: fnd_currencies fc,
2387: zx_rates_b rates,
2388: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
2389: WHERE pohzd.trx_currency_code = fc.currency_code(+)
2390: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
2817: AND NVL(aps.org_id, -99) = NVL(poh.org_id, -99)
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(+)
3517: AND NVL(aps.org_id, -99) = NVL(poh.org_id, -99)
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,
4239: AND NVL(aps.org_id, -99) = NVL(poh.org_id, -99)
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,
4744: AND recdist.po_line_location_id(+) = pohzd.trx_line_id
4745: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
4746: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
4747: ) pohzd,
4748: fnd_currencies fc,
4749: zx_rates_b rates,
4750: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
4751: WHERE pohzd.trx_currency_code = fc.currency_code(+)
4752: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
5246: AND NVL(aps.org_id, -99) = NVL(poh.org_id, -99)
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
5933: AND aps.set_of_books_id = fsp.set_of_books_id
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,
6641: AND aps.set_of_books_id = fsp.set_of_books_id
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,
7139: AND recdist.po_line_location_id(+) = pohzd.trx_line_id
7140: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
7141: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
7142: ) pohzd,
7143: fnd_currencies fc,
7144: zx_rates_b rates,
7145: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
7146: WHERE pohzd.trx_currency_code = fc.currency_code(+)
7147: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
7569: AND NVL(aps.org_id, -99) = NVL(poh.org_id, -99)
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(+)
8266: AND aps.set_of_books_id = fsp.set_of_books_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,
8983: AND aps.set_of_books_id = fsp.set_of_books_id
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,
9479: AND recdist.po_line_location_id(+) = pohzd.trx_line_id
9480: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
9481: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
9482: ) pohzd,
9483: fnd_currencies fc,
9484: zx_rates_b rates,
9485: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
9486: WHERE pohzd.trx_currency_code = fc.currency_code(+)
9487: AND rates.tax_regime_code(+) = pohzd.tax_regime_code