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 486: po_line_locations_all poll,

482: AND oi.org_information_context(+) = 'Operating Unit Information'
483: ) poh,
484: fnd_currencies fc,
485: po_lines_all pol,
486: po_line_locations_all poll,
487: zx_party_tax_profile ptp,
488: hr_locations_all hr
489: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
490: AND pol.po_header_id = poh.po_header_id

Line 1175: po_line_locations_all poll,

1171: AND oi.org_information_context(+) = 'Operating Unit Information'
1172: ) poh,
1173: fnd_currencies fc,
1174: po_lines_all pol,
1175: po_line_locations_all poll,
1176: zx_party_tax_profile ptp,
1177: ap_tax_codes_all atc,
1178: zx_rates_b rates,
1179: zx_regimes_b regimes,

Line 1884: po_line_locations_all poll,

1880: AND oi.org_information_context(+) = 'Operating Unit Information'
1881: ) poh,
1882: fnd_currencies fc,
1883: po_lines_all pol,
1884: po_line_locations_all poll,
1885: zx_party_tax_profile ptp,
1886: ap_tax_codes_all atc,
1887: ar_tax_group_codes_all atg,
1888: ap_tax_codes_all atc1,

Line 2358: po_line_locations_all poll,

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

Line 2808: FROM po_line_locations_all poll,

2804: poh.segment1 poh_segment1,
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

Line 3508: FROM po_line_locations_all poll,

3504: fsp.set_of_books_id fsp_set_of_books_id,
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

Line 4230: FROM po_line_locations_all poll,

4226: fsp.set_of_books_id fsp_set_of_books_id,
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

Line 4716: FROM po_line_locations_all poll,

4712: pod.attribute12 p_attribute12,
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

Line 5252: po_line_locations_all poll,

5248: AND oi.org_information_context(+) = 'Operating Unit Information'
5249: ) poh,
5250: fnd_currencies fc,
5251: po_lines_all pol,
5252: po_line_locations_all poll,
5253: zx_party_tax_profile ptp,
5254: hr_locations_all hr
5255: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
5256: AND pol.po_header_id = poh.po_header_id

Line 5939: po_line_locations_all poll,

5935: AND oi.org_information_context(+) = 'Operating Unit Information'
5936: ) poh,
5937: fnd_currencies fc,
5938: po_lines_all pol,
5939: po_line_locations_all poll,
5940: zx_party_tax_profile ptp,
5941: ap_tax_codes_all atc,
5942: zx_rates_b rates,
5943: zx_regimes_b regimes,

Line 6647: po_line_locations_all poll,

6643: AND oi.org_information_context(+) = 'Operating Unit Information'
6644: ) poh,
6645: fnd_currencies fc,
6646: po_lines_all pol,
6647: po_line_locations_all poll,
6648: zx_party_tax_profile ptp,
6649: ap_tax_codes_all atc,
6650: ar_tax_group_codes_all atg,
6651: ap_tax_codes_all atc1,

Line 7115: po_line_locations_all poll,

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

Line 7560: po_line_locations_all poll,

7556: where other_doc_application_id = 201
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

Line 8257: po_line_locations_all poll,

8253: where other_doc_application_id = 201
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

Line 8974: po_line_locations_all poll,

8970: where other_doc_application_id = 201
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

Line 9451: po_line_locations_all poll,

9447: where other_doc_application_id = 201
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