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 64: hr_organization_information oi

60: (SELECT oi.org_information2 oi_org_information2,poh.last_update_date
61: FROM po_headers_all poh,
62: financials_system_params_all fsp,
63: ap_system_parameters_all aps,
64: hr_organization_information oi
65: WHERE poh.po_header_id = p_upg_trx_info_rec.trx_id
66: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
67: AND aps.set_of_books_id = fsp.set_of_books_id
68: AND NVL(aps.org_id, -99) = NVL(poh.org_id, -99)

Line 476: hr_organization_information oi

472: oi.org_information2 oi_org_information2
473: FROM po_headers_all poh,
474: financials_system_params_all fsp,
475: ap_system_parameters_all aps,
476: hr_organization_information oi
477: WHERE poh.po_header_id = p_upg_trx_info_rec.trx_id
478: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
479: AND aps.set_of_books_id = fsp.set_of_books_id
480: AND NVL(aps.org_id, -99) = NVL(poh.org_id, -99)

Line 1165: hr_organization_information oi

1161: aps.base_currency_code, oi.org_information2 oi_org_information2
1162: FROM po_headers_all poh,
1163: financials_system_params_all fsp,
1164: ap_system_parameters_all aps,
1165: hr_organization_information oi
1166: WHERE poh.po_header_id = p_upg_trx_info_rec.trx_id
1167: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
1168: AND NVL(aps.org_id, -99) = NVL(poh.org_id,-99)
1169: AND aps.set_of_books_id = fsp.set_of_books_id

Line 1874: hr_organization_information oi

1870: aps.base_currency_code, oi.org_information2 oi_org_information2
1871: FROM po_headers_all poh,
1872: financials_system_params_all fsp,
1873: ap_system_parameters_all aps,
1874: hr_organization_information oi
1875: WHERE poh.po_header_id = p_upg_trx_info_rec.trx_id
1876: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
1877: AND NVL(aps.org_id, -99) = NVL(poh.org_id,-99)
1878: AND aps.set_of_books_id = fsp.set_of_books_id

Line 2812: hr_organization_information oi

2808: FROM po_line_locations_all poll,
2809: po_headers_all poh,
2810: financials_system_params_all fsp,
2811: ap_system_parameters_all aps,
2812: hr_organization_information oi
2813: WHERE poll.po_release_id = p_upg_trx_info_rec.trx_id
2814: AND poh.po_header_id = poll.po_header_id
2815: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
2816: AND aps.set_of_books_id = fsp.set_of_books_id

Line 3512: hr_organization_information oi

3508: FROM po_line_locations_all poll,
3509: po_headers_all poh,
3510: financials_system_params_all fsp,
3511: ap_system_parameters_all aps,
3512: hr_organization_information oi
3513: WHERE poll.po_release_id = p_upg_trx_info_rec.trx_id
3514: AND poh.po_header_id = poll.po_header_id
3515: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
3516: AND aps.set_of_books_id = fsp.set_of_books_id

Line 4234: hr_organization_information oi

4230: FROM po_line_locations_all poll,
4231: po_headers_all poh,
4232: financials_system_params_all fsp,
4233: ap_system_parameters_all aps,
4234: hr_organization_information oi
4235: WHERE poll.po_release_id = p_upg_trx_info_rec.trx_id
4236: AND poh.po_header_id = poll.po_header_id
4237: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
4238: AND aps.set_of_books_id = fsp.set_of_books_id

Line 5242: hr_organization_information oi

5238: ) zxvalerr, --Bug 5187701
5239: po_headers_all poh,
5240: financials_system_params_all fsp,
5241: ap_system_parameters_all aps,
5242: hr_organization_information oi
5243: WHERE poh.po_header_id = zxvalerr.other_doc_trx_id
5244: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
5245: AND aps.set_of_books_id = fsp.set_of_books_id
5246: AND NVL(aps.org_id, -99) = NVL(poh.org_id, -99)

Line 5929: hr_organization_information oi

5925: ) zxvalerr, --Bug 5187701
5926: po_headers_all poh,
5927: financials_system_params_all fsp,
5928: ap_system_parameters_all aps,
5929: hr_organization_information oi
5930: WHERE poh.po_header_id = zxvalerr.other_doc_trx_id
5931: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
5932: AND NVL(aps.org_id, -99) = NVL(poh.org_id,-99)
5933: AND aps.set_of_books_id = fsp.set_of_books_id

Line 6637: hr_organization_information oi

6633: ) zxvalerr, --Bug 5187701
6634: po_headers_all poh,
6635: financials_system_params_all fsp,
6636: ap_system_parameters_all aps,
6637: hr_organization_information oi
6638: WHERE poh.po_header_id = zxvalerr.other_doc_trx_id
6639: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
6640: AND NVL(aps.org_id, -99) = NVL(poh.org_id,-99)
6641: AND aps.set_of_books_id = fsp.set_of_books_id

Line 7564: hr_organization_information oi

7560: po_line_locations_all poll,
7561: po_headers_all poh,
7562: financials_system_params_all fsp,
7563: ap_system_parameters_all aps,
7564: hr_organization_information oi
7565: WHERE poll.po_release_id = zxvalerr.other_doc_trx_id
7566: AND poh.po_header_id = poll.po_header_id
7567: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
7568: AND aps.set_of_books_id = fsp.set_of_books_id

Line 8261: hr_organization_information oi

8257: po_line_locations_all poll,
8258: po_headers_all poh,
8259: financials_system_params_all fsp,
8260: ap_system_parameters_all aps,
8261: hr_organization_information oi
8262: WHERE poll.po_release_id = zxvalerr.other_doc_trx_id
8263: AND poh.po_header_id = poll.po_header_id
8264: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
8265: AND NVL(aps.org_id, -99) = NVL(poh.org_id,-99)

Line 8978: hr_organization_information oi

8974: po_line_locations_all poll,
8975: po_headers_all poh,
8976: financials_system_params_all fsp,
8977: ap_system_parameters_all aps,
8978: hr_organization_information oi
8979: WHERE poll.po_release_id = zxvalerr.other_doc_trx_id
8980: AND poh.po_header_id = poll.po_header_id
8981: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
8982: AND NVL(aps.org_id, -99) = NVL(poh.org_id,-99)