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 PO_HEADERS_ALL

Line 61: FROM po_headers_all poh,

57: INTO l_estb_id
58: FROM zx_party_tax_profile ptp,
59: xle_etb_profiles xle_etb,
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

Line 473: FROM po_headers_all poh,

469: 1,'ADVANCE', 2, 3) LINE_TRX_USER_KEY3
470: FROM (SELECT /*+ NO_MERGE NO_EXPAND swap_join_inputs(fsp) swap_join_inputs(aps) swap_join_inputs(oi) index(aps AP_SYSTEM_PARAMETERS_U1) */
471: poh.*,fsp.set_of_books_id, aps.base_currency_code,
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

Line 1162: FROM po_headers_all poh,

1158: ,'N' MULTIPLE_JURISDICTIONS_FLAG
1159: FROM (SELECT /*+ NO_MERGE NO_EXPAND use_hash(fsp) use_hash(aps) use_hash(oi) swap_join_inputs(fsp) swap_join_inputs(aps) swap_join_inputs(oi) */
1160: poh.*, fsp.org_id fsp_org_id, fsp.set_of_books_id,
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

Line 1871: FROM po_headers_all poh,

1867: ,'N' MULTIPLE_JURISDICTIONS_FLAG
1868: FROM (SELECT /*+ NO_MERGE NO_EXPAND use_hash(fsp) use_hash(aps) use_hash(oi) swap_join_inputs(fsp) swap_join_inputs(aps) swap_join_inputs(oi) */
1869: poh.*, fsp.org_id fsp_org_id, fsp.set_of_books_id,
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

Line 2355: FROM po_headers_all poh,

2351: pod.attribute12 p_attribute12,
2352: pod.attribute13 p_attribute13,
2353: pod.attribute14 p_attribute14,
2354: pod.attribute15 p_attribute15
2355: FROM po_headers_all poh,
2356: financials_system_params_all fsp,
2357: zx_lines zxl,
2358: po_line_locations_all poll,
2359: po_distributions_all pod

Line 2809: po_headers_all poh,

2805: fsp.set_of_books_id fsp_set_of_books_id,
2806: aps.base_currency_code aps_base_currency_code,
2807: oi.org_information2 oi_org_information2
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

Line 3509: po_headers_all poh,

3505: fsp.org_id fsp_org_id,
3506: aps.base_currency_code aps_base_currency_code,
3507: oi.org_information2 oi_org_information2
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

Line 4231: po_headers_all poh,

4227: fsp.org_id fsp_org_id,
4228: aps.base_currency_code aps_base_currency_code,
4229: oi.org_information2 oi_org_information2
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

Line 4717: po_headers_all poh,

4713: pod.attribute13 p_attribute13,
4714: pod.attribute14 p_attribute14,
4715: pod.attribute15 p_attribute15
4716: FROM po_line_locations_all poll,
4717: po_headers_all poh,
4718: financials_system_params_all fsp,
4719: zx_lines zxl,
4720: po_distributions_all pod
4721: WHERE poll.po_release_id = p_upg_trx_info_rec.trx_id

Line 5239: po_headers_all poh,

5235: where other_doc_application_id = 201
5236: and other_doc_entity_code = 'PURCHASE_ORDER'
5237: and other_doc_event_class_code = 'PO_PA'
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

Line 5926: po_headers_all poh,

5922: where other_doc_application_id = 201
5923: and other_doc_entity_code = 'PURCHASE_ORDER'
5924: and other_doc_event_class_code = 'PO_PA'
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

Line 6634: po_headers_all poh,

6630: where other_doc_application_id = 201
6631: and other_doc_entity_code = 'PURCHASE_ORDER'
6632: and other_doc_event_class_code = 'PO_PA'
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

Line 7112: po_headers_all poh,

7108: where other_doc_application_id = 201
7109: and other_doc_entity_code = 'PURCHASE_ORDER'
7110: and other_doc_event_class_code = 'PO_PA'
7111: ) zxvalerr, --Bug 5187701
7112: po_headers_all poh,
7113: financials_system_params_all fsp,
7114: zx_lines zxl,
7115: po_line_locations_all poll,
7116: po_distributions_all pod

Line 7561: po_headers_all poh,

7557: and other_doc_entity_code = 'RELEASE'
7558: and other_doc_event_class_code = 'RELEASE'
7559: ) zxvalerr,
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

Line 8258: po_headers_all poh,

8254: and other_doc_entity_code = 'RELEASE'
8255: and other_doc_event_class_code = 'RELEASE'
8256: ) zxvalerr,
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

Line 8975: po_headers_all poh,

8971: and other_doc_entity_code = 'RELEASE'
8972: and other_doc_event_class_code = 'RELEASE'
8973: ) zxvalerr,
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

Line 9452: po_headers_all poh,

9448: and other_doc_entity_code = 'RELEASE'
9449: and other_doc_event_class_code = 'RELEASE')
9450: zxvalerr,
9451: po_line_locations_all poll,
9452: po_headers_all poh,
9453: financials_system_params_all fsp,
9454: zx_lines zxl,
9455: po_distributions_all pod
9456: WHERE poll.po_release_id = zxvalerr.other_doc_trx_id