eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_ON_FLY_TRX_UPGRADE_PO_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 442: hr_organization_information oi

438: oi.org_information2 oi_org_information2
439: FROM po_headers_all poh,
440: financials_system_params_all fsp,
441: ap_system_parameters_all aps,
442: hr_organization_information oi
443: WHERE poh.po_header_id = p_upg_trx_info_rec.trx_id
444: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
445: AND aps.set_of_books_id = fsp.set_of_books_id
446: AND NVL(aps.org_id, -99) = NVL(poh.org_id, -99)

Line 1135: hr_organization_information oi

1131: aps.base_currency_code, oi.org_information2 oi_org_information2
1132: FROM po_headers_all poh,
1133: financials_system_params_all fsp,
1134: ap_system_parameters_all aps,
1135: hr_organization_information oi
1136: WHERE poh.po_header_id = p_upg_trx_info_rec.trx_id
1137: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
1138: AND NVL(aps.org_id, -99) = NVL(poh.org_id,-99)
1139: AND aps.set_of_books_id = fsp.set_of_books_id

Line 1848: hr_organization_information oi

1844: aps.base_currency_code, oi.org_information2 oi_org_information2
1845: FROM po_headers_all poh,
1846: financials_system_params_all fsp,
1847: ap_system_parameters_all aps,
1848: hr_organization_information oi
1849: WHERE poh.po_header_id = p_upg_trx_info_rec.trx_id
1850: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
1851: AND NVL(aps.org_id, -99) = NVL(poh.org_id,-99)
1852: AND aps.set_of_books_id = fsp.set_of_books_id

Line 2751: hr_organization_information oi

2747: FROM po_line_locations_all poll,
2748: po_headers_all poh,
2749: financials_system_params_all fsp,
2750: ap_system_parameters_all aps,
2751: hr_organization_information oi
2752: WHERE poll.po_release_id = p_upg_trx_info_rec.trx_id
2753: AND poh.po_header_id = poll.po_header_id
2754: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
2755: AND aps.set_of_books_id = fsp.set_of_books_id

Line 3454: hr_organization_information oi

3450: FROM po_line_locations_all poll,
3451: po_headers_all poh,
3452: financials_system_params_all fsp,
3453: ap_system_parameters_all aps,
3454: hr_organization_information oi
3455: WHERE poll.po_release_id = p_upg_trx_info_rec.trx_id
3456: AND poh.po_header_id = poll.po_header_id
3457: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
3458: AND aps.set_of_books_id = fsp.set_of_books_id

Line 4179: hr_organization_information oi

4175: FROM po_line_locations_all poll,
4176: po_headers_all poh,
4177: financials_system_params_all fsp,
4178: ap_system_parameters_all aps,
4179: hr_organization_information oi
4180: WHERE poll.po_release_id = p_upg_trx_info_rec.trx_id
4181: AND poh.po_header_id = poll.po_header_id
4182: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
4183: AND aps.set_of_books_id = fsp.set_of_books_id

Line 5153: hr_organization_information oi

5149: ) zxvalerr, --Bug 5187701
5150: po_headers_all poh,
5151: financials_system_params_all fsp,
5152: ap_system_parameters_all aps,
5153: hr_organization_information oi
5154: WHERE poh.po_header_id = zxvalerr.other_doc_trx_id
5155: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
5156: AND aps.set_of_books_id = fsp.set_of_books_id
5157: AND NVL(aps.org_id, -99) = NVL(poh.org_id, -99)

Line 5843: hr_organization_information oi

5839: ) zxvalerr, --Bug 5187701
5840: po_headers_all poh,
5841: financials_system_params_all fsp,
5842: ap_system_parameters_all aps,
5843: hr_organization_information oi
5844: WHERE poh.po_header_id = zxvalerr.other_doc_trx_id
5845: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
5846: AND NVL(aps.org_id, -99) = NVL(poh.org_id,-99)
5847: AND aps.set_of_books_id = fsp.set_of_books_id

Line 6554: hr_organization_information oi

6550: ) zxvalerr, --Bug 5187701
6551: po_headers_all poh,
6552: financials_system_params_all fsp,
6553: ap_system_parameters_all aps,
6554: hr_organization_information oi
6555: WHERE poh.po_header_id = zxvalerr.other_doc_trx_id
6556: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
6557: AND NVL(aps.org_id, -99) = NVL(poh.org_id,-99)
6558: AND aps.set_of_books_id = fsp.set_of_books_id

Line 7449: hr_organization_information oi

7445: po_line_locations_all poll,
7446: po_headers_all poh,
7447: financials_system_params_all fsp,
7448: ap_system_parameters_all aps,
7449: hr_organization_information oi
7450: WHERE poll.po_release_id = zxvalerr.other_doc_trx_id
7451: AND poh.po_header_id = poll.po_header_id
7452: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
7453: AND aps.set_of_books_id = fsp.set_of_books_id

Line 8149: hr_organization_information oi

8145: po_line_locations_all poll,
8146: po_headers_all poh,
8147: financials_system_params_all fsp,
8148: ap_system_parameters_all aps,
8149: hr_organization_information oi
8150: WHERE poll.po_release_id = zxvalerr.other_doc_trx_id
8151: AND poh.po_header_id = poll.po_header_id
8152: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
8153: AND NVL(aps.org_id, -99) = NVL(poh.org_id,-99)

Line 8869: hr_organization_information oi

8865: po_line_locations_all poll,
8866: po_headers_all poh,
8867: financials_system_params_all fsp,
8868: ap_system_parameters_all aps,
8869: hr_organization_information oi
8870: WHERE poll.po_release_id = zxvalerr.other_doc_trx_id
8871: AND poh.po_header_id = poll.po_header_id
8872: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
8873: AND NVL(aps.org_id, -99) = NVL(poh.org_id,-99)