[Home] [Help]
436: swap_join_inputs(oi) index(aps AP_SYSTEM_PARAMETERS_U1) */
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)
1129: swap_join_inputs(oi) */
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)
1842: swap_join_inputs(oi) */
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)
2296: pod.attribute13 p_attribute13,
2297: pod.attribute14 p_attribute14,
2298: pod.attribute15 p_attribute15
2299: FROM po_headers_all poh,
2300: financials_system_params_all fsp,
2301: zx_lines zxl,
2302: po_line_locations_all poll,
2303: po_distributions_all pod
2304: WHERE poh.po_header_id = p_upg_trx_info_rec.trx_id
2745: aps.base_currency_code aps_base_currency_code,
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
3448: aps.base_currency_code aps_base_currency_code,
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
4173: aps.base_currency_code aps_base_currency_code,
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
4630: pod.attribute14 p_attribute14,
4631: pod.attribute15 p_attribute15
4632: FROM po_line_locations_all poll,
4633: po_headers_all poh,
4634: financials_system_params_all fsp,
4635: zx_lines zxl,
4636: po_distributions_all pod
4637: WHERE poll.po_release_id = p_upg_trx_info_rec.trx_id
4638: AND poh.po_header_id = poll.po_header_id
5147: and other_doc_entity_code = 'PURCHASE_ORDER'
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)
5837: and other_doc_entity_code = 'PURCHASE_ORDER'
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)
6548: and other_doc_entity_code = 'PURCHASE_ORDER'
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)
6999: and other_doc_entity_code = 'PURCHASE_ORDER'
7000: and other_doc_event_class_code = 'PO_PA'
7001: ) zxvalerr, --Bug 5187701
7002: po_headers_all poh,
7003: financials_system_params_all fsp,
7004: zx_lines zxl,
7005: po_line_locations_all poll,
7006: po_distributions_all pod
7007: WHERE poh.po_header_id = zxvalerr.other_doc_trx_id
7443: and other_doc_event_class_code = 'RELEASE'
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
8143: and other_doc_event_class_code = 'RELEASE'
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
8863: and other_doc_event_class_code = 'RELEASE'
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
9313: and other_doc_event_class_code = 'RELEASE')
9314: zxvalerr,
9315: po_line_locations_all poll,
9316: po_headers_all poh,
9317: financials_system_params_all fsp,
9318: zx_lines zxl,
9319: po_distributions_all pod
9320: WHERE poll.po_release_id = zxvalerr.other_doc_trx_id
9321: AND poh.po_header_id = poll.po_header_id