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 ZX_TRANSACTION_LINES_GT

Line 495: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

491: AND poll.po_header_id = pol.po_header_id
492: AND poll.po_line_id = pol.po_line_id
493: AND hr.location_id(+) = poll.ship_to_location_id
494: AND NOT EXISTS
495: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
496: WHERE lines_gt.application_id = 201
497: AND lines_gt.event_class_code = 'PO_PA'
498: AND lines_gt.entity_code = 'PURCHASE_ORDER'
499: AND lines_gt.trx_id = p_upg_trx_info_rec.trx_id

Line 1190: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

1186: AND nvl(atc.org_id,-99)=nvl(poh.fsp_org_id,-99)
1187: AND poll.tax_code_id = atc.tax_id
1188: AND atc.tax_type NOT IN ('TAX_GROUP','USE')
1189: AND NOT EXISTS
1190: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
1191: WHERE lines_gt.application_id = 201
1192: AND lines_gt.event_class_code = 'PO_PA'
1193: AND lines_gt.entity_code = 'PURCHASE_ORDER'
1194: AND lines_gt.trx_id = p_upg_trx_info_rec.trx_id

Line 1909: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

1905: AND atc1.tax_id = atg.tax_code_id
1906: AND atc1.start_date <= poll.last_update_date
1907: AND(atc1.inactive_date >= poll.last_update_date OR atc1.inactive_date IS NULL)
1908: AND NOT EXISTS
1909: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
1910: WHERE lines_gt.application_id = 201
1911: AND lines_gt.event_class_code = 'PO_PA'
1912: AND lines_gt.entity_code = 'PURCHASE_ORDER'
1913: AND lines_gt.trx_id = p_upg_trx_info_rec.trx_id

Line 2368: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

2364: AND zxl.event_class_code = 'PO_PA'
2365: AND zxl.trx_id = poh.po_header_id
2366: AND poll.line_location_id = zxl.trx_line_id
2367: AND NOT EXISTS
2368: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
2369: WHERE lines_gt.application_id = 201
2370: AND lines_gt.event_class_code = 'PO_PA'
2371: AND lines_gt.entity_code = 'PURCHASE_ORDER'
2372: AND lines_gt.trx_id = p_upg_trx_info_rec.trx_id

Line 2830: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

2826: AND pol.po_header_id = poll.po_header_id
2827: AND pol.po_line_id = poll.po_line_id
2828: AND hr.location_id(+) = poll.ship_to_location_id
2829: AND NOT EXISTS
2830: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
2831: WHERE lines_gt.application_id = 201
2832: AND lines_gt.event_class_code = 'RELEASE'
2833: AND lines_gt.entity_code = 'RELEASE'
2834: AND lines_gt.trx_id = p_upg_trx_info_rec.trx_id

Line 3536: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

3532: AND nvl(atc.org_id,-99)=nvl(poll.fsp_org_id,-99)
3533: AND poll.tax_code_id = atc.tax_id
3534: AND atc.tax_type NOT IN ('TAX_GROUP','USE')
3535: AND NOT EXISTS
3536: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
3537: WHERE lines_gt.application_id = 201
3538: AND lines_gt.event_class_code = 'RELEASE'
3539: AND lines_gt.entity_code = 'RELEASE'
3540: AND lines_gt.trx_id = p_upg_trx_info_rec.trx_id

Line 4267: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

4263: AND atc1.tax_id = atg.tax_code_id
4264: AND atc1.start_date <= poll.last_update_date
4265: AND(atc1.inactive_date >= poll.last_update_date OR atc1.inactive_date IS NULL)
4266: AND NOT EXISTS
4267: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
4268: WHERE lines_gt.application_id = 201
4269: AND lines_gt.event_class_code = 'RELEASE'
4270: AND lines_gt.entity_code = 'RELEASE'
4271: AND lines_gt.trx_id = p_upg_trx_info_rec.trx_id

Line 4730: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

4726: AND zxl.event_class_code = 'RELEASE'
4727: AND zxl.trx_id = p_upg_trx_info_rec.trx_id
4728: AND zxl.trx_line_id = poll.line_location_id
4729: AND NOT EXISTS
4730: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
4731: WHERE lines_gt.application_id = 201
4732: AND lines_gt.event_class_code = 'RELEASE'
4733: AND lines_gt.entity_code = 'RELEASE'
4734: AND lines_gt.trx_id = p_upg_trx_info_rec.trx_id

Line 5261: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

5257: AND poll.po_header_id = pol.po_header_id
5258: AND poll.po_line_id = pol.po_line_id
5259: AND hr.location_id(+) = poll.ship_to_location_id
5260: AND NOT EXISTS
5261: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
5262: WHERE lines_gt.application_id = 201
5263: AND lines_gt.event_class_code = 'PO_PA'
5264: AND lines_gt.entity_code = 'PURCHASE_ORDER'
5265: AND lines_gt.trx_id = poh.po_header_id

Line 5951: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

5947: AND poh.po_header_id = pol.po_header_id
5948: AND pol.po_header_id = poll.po_header_id
5949: AND pol.po_line_id = poll.po_line_id
5950: AND NOT EXISTS
5951: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
5952: WHERE lines_gt.application_id = 201
5953: AND lines_gt.event_class_code = 'PO_PA'
5954: AND lines_gt.entity_code = 'PURCHASE_ORDER'
5955: AND lines_gt.trx_id = poh.po_header_id

Line 6661: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

6657: AND poh.po_header_id = pol.po_header_id
6658: AND pol.po_header_id = poll.po_header_id
6659: AND pol.po_line_id = poll.po_line_id
6660: AND NOT EXISTS
6661: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
6662: WHERE lines_gt.application_id = 201
6663: AND lines_gt.event_class_code = 'PO_PA'
6664: AND lines_gt.entity_code = 'PURCHASE_ORDER'
6665: AND lines_gt.trx_id = poh.po_header_id

Line 7125: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

7121: AND zxl.event_class_code = 'PO_PA'
7122: AND zxl.trx_id = poh.po_header_id
7123: AND poll.line_location_id = zxl.trx_line_id
7124: AND NOT EXISTS
7125: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
7126: WHERE lines_gt.application_id = 201
7127: AND lines_gt.event_class_code = 'PO_PA'
7128: AND lines_gt.entity_code = 'PURCHASE_ORDER'
7129: AND lines_gt.trx_id = poh.po_header_id

Line 7582: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

7578: AND pol.po_header_id = poll.po_header_id
7579: AND pol.po_line_id = poll.po_line_id
7580: AND hr.location_id(+) = poll.ship_to_location_id
7581: AND NOT EXISTS
7582: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
7583: WHERE lines_gt.application_id = 201
7584: AND lines_gt.event_class_code = 'RELEASE'
7585: AND lines_gt.entity_code = 'RELEASE'
7586: AND lines_gt.trx_id = poll.po_release_id

Line 8282: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

8278: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)
8279: AND pol.po_header_id = poll.po_header_id
8280: AND pol.po_line_id = poll.po_line_id
8281: AND NOT EXISTS
8282: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
8283: WHERE lines_gt.application_id = 201
8284: AND lines_gt.event_class_code = 'RELEASE'
8285: AND lines_gt.entity_code = 'RELEASE'
8286: AND lines_gt.trx_id = poll.po_release_id

Line 9001: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

8997: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)
8998: AND pol.po_header_id = poll.po_header_id
8999: AND pol.po_line_id = poll.po_line_id
9000: AND NOT EXISTS
9001: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
9002: WHERE lines_gt.application_id = 201
9003: AND lines_gt.event_class_code = 'RELEASE'
9004: AND lines_gt.entity_code = 'RELEASE'
9005: AND lines_gt.trx_id = poll.po_release_id

Line 9465: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

9461: AND zxl.event_class_code = 'RELEASE'
9462: AND zxl.trx_id = poll.po_release_id
9463: AND zxl.trx_line_id = poll.line_location_id
9464: AND NOT EXISTS
9465: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
9466: WHERE lines_gt.application_id = 201
9467: AND lines_gt.event_class_code = 'RELEASE'
9468: AND lines_gt.entity_code = 'RELEASE'
9469: AND lines_gt.trx_id = poll.po_release_id