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 AP_SYSTEM_PARAMETERS_ALL

Line 441: ap_system_parameters_all aps,

437: poh.*,fsp.set_of_books_id, aps.base_currency_code,
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

Line 1134: ap_system_parameters_all aps,

1130: poh.*, fsp.org_id fsp_org_id, fsp.set_of_books_id,
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)

Line 1847: ap_system_parameters_all aps,

1843: poh.*, fsp.org_id fsp_org_id, fsp.set_of_books_id,
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)

Line 2750: ap_system_parameters_all aps,

2746: oi.org_information2 oi_org_information2
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)

Line 3453: ap_system_parameters_all aps,

3449: oi.org_information2 oi_org_information2
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)

Line 4178: ap_system_parameters_all aps,

4174: oi.org_information2 oi_org_information2
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)

Line 5152: ap_system_parameters_all aps,

5148: and other_doc_event_class_code = 'PO_PA'
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

Line 5842: ap_system_parameters_all aps,

5838: and other_doc_event_class_code = 'PO_PA'
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)

Line 6553: ap_system_parameters_all aps,

6549: and other_doc_event_class_code = 'PO_PA'
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)

Line 7448: ap_system_parameters_all aps,

7444: ) zxvalerr,
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)

Line 8148: ap_system_parameters_all aps,

8144: ) zxvalerr,
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)

Line 8868: ap_system_parameters_all aps,

8864: ) zxvalerr,
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)