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 461: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

457: AND poll.po_header_id = pol.po_header_id
458: AND poll.po_line_id = pol.po_line_id
459: AND hr.location_id(+) = poll.ship_to_location_id
460: AND NOT EXISTS
461: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
462: WHERE lines_gt.application_id = 201
463: AND lines_gt.event_class_code = 'PO_PA'
464: AND lines_gt.entity_code = 'PURCHASE_ORDER'
465: AND lines_gt.trx_id = p_upg_trx_info_rec.trx_id

Line 1160: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

1156: AND nvl(atc.org_id,-99)=nvl(poh.fsp_org_id,-99)
1157: AND poll.tax_code_id = atc.tax_id
1158: AND atc.tax_type NOT IN ('TAX_GROUP','USE')
1159: AND NOT EXISTS
1160: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
1161: WHERE lines_gt.application_id = 201
1162: AND lines_gt.event_class_code = 'PO_PA'
1163: AND lines_gt.entity_code = 'PURCHASE_ORDER'
1164: AND lines_gt.trx_id = p_upg_trx_info_rec.trx_id

Line 1879: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

1875: AND atc1.tax_id = atg.tax_code_id
1876: AND atc1.start_date <= poll.last_update_date
1877: AND(atc1.inactive_date >= poll.last_update_date OR atc1.inactive_date IS NULL)
1878: AND NOT EXISTS
1879: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
1880: WHERE lines_gt.application_id = 201
1881: AND lines_gt.event_class_code = 'PO_PA'
1882: AND lines_gt.entity_code = 'PURCHASE_ORDER'
1883: AND lines_gt.trx_id = p_upg_trx_info_rec.trx_id

Line 2312: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

2308: AND zxl.event_class_code = 'PO_PA'
2309: AND zxl.trx_id = poh.po_header_id
2310: AND poll.line_location_id = zxl.trx_line_id
2311: AND NOT EXISTS
2312: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
2313: WHERE lines_gt.application_id = 201
2314: AND lines_gt.event_class_code = 'PO_PA'
2315: AND lines_gt.entity_code = 'PURCHASE_ORDER'
2316: AND lines_gt.trx_id = p_upg_trx_info_rec.trx_id

Line 2769: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

2765: AND pol.po_header_id = poll.po_header_id
2766: AND pol.po_line_id = poll.po_line_id
2767: AND hr.location_id(+) = poll.ship_to_location_id
2768: AND NOT EXISTS
2769: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
2770: WHERE lines_gt.application_id = 201
2771: AND lines_gt.event_class_code = 'RELEASE'
2772: AND lines_gt.entity_code = 'RELEASE'
2773: AND lines_gt.trx_id = p_upg_trx_info_rec.trx_id

Line 3478: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

3474: AND nvl(atc.org_id,-99)=nvl(poll.fsp_org_id,-99)
3475: AND poll.tax_code_id = atc.tax_id
3476: AND atc.tax_type NOT IN ('TAX_GROUP','USE')
3477: AND NOT EXISTS
3478: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
3479: WHERE lines_gt.application_id = 201
3480: AND lines_gt.event_class_code = 'RELEASE'
3481: AND lines_gt.entity_code = 'RELEASE'
3482: AND lines_gt.trx_id = p_upg_trx_info_rec.trx_id

Line 4209: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

4205: AND atc1.tax_id = atg.tax_code_id
4206: AND atc1.start_date <= poll.last_update_date
4207: AND(atc1.inactive_date >= poll.last_update_date OR atc1.inactive_date IS NULL)
4208: AND NOT EXISTS
4209: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
4210: WHERE lines_gt.application_id = 201
4211: AND lines_gt.event_class_code = 'RELEASE'
4212: AND lines_gt.entity_code = 'RELEASE'
4213: AND lines_gt.trx_id = p_upg_trx_info_rec.trx_id

Line 4646: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

4642: AND zxl.event_class_code = 'RELEASE'
4643: AND zxl.trx_id = p_upg_trx_info_rec.trx_id
4644: AND zxl.trx_line_id = poll.line_location_id
4645: AND NOT EXISTS
4646: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
4647: WHERE lines_gt.application_id = 201
4648: AND lines_gt.event_class_code = 'RELEASE'
4649: AND lines_gt.entity_code = 'RELEASE'
4650: AND lines_gt.trx_id = p_upg_trx_info_rec.trx_id

Line 5172: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

5168: AND poll.po_header_id = pol.po_header_id
5169: AND poll.po_line_id = pol.po_line_id
5170: AND hr.location_id(+) = poll.ship_to_location_id
5171: AND NOT EXISTS
5172: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
5173: WHERE lines_gt.application_id = 201
5174: AND lines_gt.event_class_code = 'PO_PA'
5175: AND lines_gt.entity_code = 'PURCHASE_ORDER'
5176: AND lines_gt.trx_id = poh.po_header_id

Line 5865: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

5861: AND poh.po_header_id = pol.po_header_id
5862: AND pol.po_header_id = poll.po_header_id
5863: AND pol.po_line_id = poll.po_line_id
5864: AND NOT EXISTS
5865: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
5866: WHERE lines_gt.application_id = 201
5867: AND lines_gt.event_class_code = 'PO_PA'
5868: AND lines_gt.entity_code = 'PURCHASE_ORDER'
5869: AND lines_gt.trx_id = poh.po_header_id

Line 6578: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

6574: AND poh.po_header_id = pol.po_header_id
6575: AND pol.po_header_id = poll.po_header_id
6576: AND pol.po_line_id = poll.po_line_id
6577: AND NOT EXISTS
6578: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
6579: WHERE lines_gt.application_id = 201
6580: AND lines_gt.event_class_code = 'PO_PA'
6581: AND lines_gt.entity_code = 'PURCHASE_ORDER'
6582: AND lines_gt.trx_id = poh.po_header_id

Line 7015: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

7011: AND zxl.event_class_code = 'PO_PA'
7012: AND zxl.trx_id = poh.po_header_id
7013: AND poll.line_location_id = zxl.trx_line_id
7014: AND NOT EXISTS
7015: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
7016: WHERE lines_gt.application_id = 201
7017: AND lines_gt.event_class_code = 'PO_PA'
7018: AND lines_gt.entity_code = 'PURCHASE_ORDER'
7019: AND lines_gt.trx_id = poh.po_header_id

Line 7467: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

7463: AND pol.po_header_id = poll.po_header_id
7464: AND pol.po_line_id = poll.po_line_id
7465: AND hr.location_id(+) = poll.ship_to_location_id
7466: AND NOT EXISTS
7467: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
7468: WHERE lines_gt.application_id = 201
7469: AND lines_gt.event_class_code = 'RELEASE'
7470: AND lines_gt.entity_code = 'RELEASE'
7471: AND lines_gt.trx_id = poll.po_release_id

Line 8170: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

8166: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)
8167: AND pol.po_header_id = poll.po_header_id
8168: AND pol.po_line_id = poll.po_line_id
8169: AND NOT EXISTS
8170: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
8171: WHERE lines_gt.application_id = 201
8172: AND lines_gt.event_class_code = 'RELEASE'
8173: AND lines_gt.entity_code = 'RELEASE'
8174: AND lines_gt.trx_id = poll.po_release_id

Line 8892: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

8888: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)
8889: AND pol.po_header_id = poll.po_header_id
8890: AND pol.po_line_id = poll.po_line_id
8891: AND NOT EXISTS
8892: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
8893: WHERE lines_gt.application_id = 201
8894: AND lines_gt.event_class_code = 'RELEASE'
8895: AND lines_gt.entity_code = 'RELEASE'
8896: AND lines_gt.trx_id = poll.po_release_id

Line 9329: (SELECT 1 FROM zx_transaction_lines_gt lines_gt

9325: AND zxl.event_class_code = 'RELEASE'
9326: AND zxl.trx_id = poll.po_release_id
9327: AND zxl.trx_line_id = poll.line_location_id
9328: AND NOT EXISTS
9329: (SELECT 1 FROM zx_transaction_lines_gt lines_gt
9330: WHERE lines_gt.application_id = 201
9331: AND lines_gt.event_class_code = 'RELEASE'
9332: AND lines_gt.entity_code = 'RELEASE'
9333: AND lines_gt.trx_id = poll.po_release_id