[Home] [Help]
446: AND NVL(aps.org_id, -99) = NVL(poh.org_id, -99)
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
1139: AND aps.set_of_books_id = fsp.set_of_books_id
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,
1852: AND aps.set_of_books_id = fsp.set_of_books_id
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,
2326: AND recdist.po_line_location_id(+) = pohzd.trx_line_id
2327: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
2328: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
2329: ) pohzd,
2330: fnd_currencies fc,
2331: zx_rates_b rates,
2332: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
2333: WHERE pohzd.trx_currency_code = fc.currency_code(+)
2334: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
2756: AND NVL(aps.org_id, -99) = NVL(poh.org_id, -99)
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(+)
3459: AND NVL(aps.org_id, -99) = NVL(poh.org_id, -99)
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,
4184: AND NVL(aps.org_id, -99) = NVL(poh.org_id, -99)
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,
4660: AND recdist.po_line_location_id(+) = pohzd.trx_line_id
4661: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
4662: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
4663: ) pohzd,
4664: fnd_currencies fc,
4665: zx_rates_b rates,
4666: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
4667: WHERE pohzd.trx_currency_code = fc.currency_code(+)
4668: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
5157: AND NVL(aps.org_id, -99) = NVL(poh.org_id, -99)
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
5847: AND aps.set_of_books_id = fsp.set_of_books_id
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,
6558: AND aps.set_of_books_id = fsp.set_of_books_id
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,
7029: AND recdist.po_line_location_id(+) = pohzd.trx_line_id
7030: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
7031: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
7032: ) pohzd,
7033: fnd_currencies fc,
7034: zx_rates_b rates,
7035: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
7036: WHERE pohzd.trx_currency_code = fc.currency_code(+)
7037: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
7454: AND NVL(aps.org_id, -99) = NVL(poh.org_id, -99)
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(+)
8154: AND aps.set_of_books_id = fsp.set_of_books_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,
8874: AND aps.set_of_books_id = fsp.set_of_books_id
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,
9343: AND recdist.po_line_location_id(+) = pohzd.trx_line_id
9344: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
9345: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
9346: ) pohzd,
9347: fnd_currencies fc,
9348: zx_rates_b rates,
9349: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
9350: WHERE pohzd.trx_currency_code = fc.currency_code(+)
9351: AND rates.tax_regime_code(+) = pohzd.tax_regime_code