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_LINE_LOCATIONS_ALL

Line 452: po_line_locations_all poll,

448: AND oi.org_information_context(+) = 'Operating Unit Information'
449: ) poh,
450: fnd_currencies fc,
451: po_lines_all pol,
452: po_line_locations_all poll,
453: zx_party_tax_profile ptp,
454: hr_locations_all hr
455: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
456: AND pol.po_header_id = poh.po_header_id

Line 1145: po_line_locations_all poll,

1141: AND oi.org_information_context(+) = 'Operating Unit Information'
1142: ) poh,
1143: fnd_currencies fc,
1144: po_lines_all pol,
1145: po_line_locations_all poll,
1146: zx_party_tax_profile ptp,
1147: ap_tax_codes_all atc,
1148: zx_rates_b rates,
1149: zx_regimes_b regimes,

Line 1858: po_line_locations_all poll,

1854: AND oi.org_information_context(+) = 'Operating Unit Information'
1855: ) poh,
1856: fnd_currencies fc,
1857: po_lines_all pol,
1858: po_line_locations_all poll,
1859: zx_party_tax_profile ptp,
1860: ap_tax_codes_all atc,
1861: ar_tax_group_codes_all atg,
1862: ap_tax_codes_all atc1,

Line 2302: po_line_locations_all poll,

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
2305: AND NVL(poh.org_id, -99) = NVL(fsp.org_id, -99)
2306: AND zxl.application_id = 201

Line 2747: FROM po_line_locations_all poll,

2743: poh.segment1 poh_segment1,
2744: fsp.set_of_books_id fsp_set_of_books_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

Line 3450: FROM po_line_locations_all poll,

3446: fsp.set_of_books_id fsp_set_of_books_id,
3447: fsp.org_id fsp_org_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

Line 4175: FROM po_line_locations_all poll,

4171: fsp.set_of_books_id fsp_set_of_books_id,
4172: fsp.org_id fsp_org_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

Line 4632: FROM po_line_locations_all poll,

4628: pod.attribute12 p_attribute12,
4629: pod.attribute13 p_attribute13,
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

Line 5163: po_line_locations_all poll,

5159: AND oi.org_information_context(+) = 'Operating Unit Information'
5160: ) poh,
5161: fnd_currencies fc,
5162: po_lines_all pol,
5163: po_line_locations_all poll,
5164: zx_party_tax_profile ptp,
5165: hr_locations_all hr
5166: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
5167: AND pol.po_header_id = poh.po_header_id

Line 5853: po_line_locations_all poll,

5849: AND oi.org_information_context(+) = 'Operating Unit Information'
5850: ) poh,
5851: fnd_currencies fc,
5852: po_lines_all pol,
5853: po_line_locations_all poll,
5854: zx_party_tax_profile ptp,
5855: ap_tax_codes_all atc,
5856: zx_rates_b rates,
5857: zx_regimes_b regimes,

Line 6564: po_line_locations_all poll,

6560: AND oi.org_information_context(+) = 'Operating Unit Information'
6561: ) poh,
6562: fnd_currencies fc,
6563: po_lines_all pol,
6564: po_line_locations_all poll,
6565: zx_party_tax_profile ptp,
6566: ap_tax_codes_all atc,
6567: ar_tax_group_codes_all atg,
6568: ap_tax_codes_all atc1,

Line 7005: po_line_locations_all poll,

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
7008: AND NVL(poh.org_id, -99) = NVL(fsp.org_id, -99)
7009: AND zxl.application_id = 201

Line 7445: po_line_locations_all poll,

7441: where other_doc_application_id = 201
7442: and other_doc_entity_code = 'RELEASE'
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

Line 8145: po_line_locations_all poll,

8141: where other_doc_application_id = 201
8142: and other_doc_entity_code = 'RELEASE'
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

Line 8865: po_line_locations_all poll,

8861: where other_doc_application_id = 201
8862: and other_doc_entity_code = 'RELEASE'
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

Line 9315: po_line_locations_all poll,

9311: where other_doc_application_id = 201
9312: and other_doc_entity_code = 'RELEASE'
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