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 FINANCIALS_SYSTEM_PARAMS_ALL

Line 62: financials_system_params_all fsp,

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
66: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)

Line 474: financials_system_params_all fsp,

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
478: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)

Line 1163: financials_system_params_all fsp,

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
1167: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)

Line 1872: financials_system_params_all fsp,

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
1876: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)

Line 2356: financials_system_params_all fsp,

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
2360: WHERE poh.po_header_id = p_upg_trx_info_rec.trx_id

Line 2810: financials_system_params_all fsp,

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
2814: AND poh.po_header_id = poll.po_header_id

Line 3510: financials_system_params_all fsp,

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
3514: AND poh.po_header_id = poll.po_header_id

Line 4232: financials_system_params_all fsp,

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
4236: AND poh.po_header_id = poll.po_header_id

Line 4718: financials_system_params_all fsp,

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
4722: AND poh.po_header_id = poll.po_header_id

Line 5240: financials_system_params_all fsp,

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
5244: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)

Line 5927: financials_system_params_all fsp,

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
5931: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)

Line 6635: financials_system_params_all fsp,

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
6639: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)

Line 7113: financials_system_params_all fsp,

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
7117: WHERE poh.po_header_id = zxvalerr.other_doc_trx_id

Line 7562: financials_system_params_all fsp,

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
7566: AND poh.po_header_id = poll.po_header_id

Line 8259: financials_system_params_all fsp,

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
8263: AND poh.po_header_id = poll.po_header_id

Line 8976: financials_system_params_all fsp,

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
8980: AND poh.po_header_id = poll.po_header_id

Line 9453: financials_system_params_all fsp,

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
9457: AND poh.po_header_id = poll.po_header_id