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.OE_CREDIT_PUB dependencies on IBY_TRXN_EXT_AUTHS_V

Line 818: iby_trxn_ext_auths_v ite

814: OR (h.payment_type_code = 'CREDIT_CARD'
815: AND NOT EXISTS
816: (Select 'valid auth code'
817: From oe_payments op,
818: iby_trxn_ext_auths_v ite
819: Where op.header_id = h.header_id
820: And op.trxn_extension_id = ite.trxn_extension_id
821: And authorization_status = 0
822: And effective_auth_amount > 0)

Line 857: iby_trxn_ext_auths_v ite

853: OR (h.payment_type_code = 'CREDIT_CARD'
854: AND NOT EXISTS
855: (Select 'valid auth code'
856: From oe_payments op,
857: iby_trxn_ext_auths_v ite
858: Where op.header_id = h.header_id
859: And op.trxn_extension_id = ite.trxn_extension_id
860: And authorization_status = 0
861: And effective_auth_amount > 0)

Line 892: iby_trxn_ext_auths_v ite

888: OR (h.payment_type_code = 'CREDIT_CARD'
889: AND NOT EXISTS
890: (Select 'valid auth code'
891: From oe_payments op,
892: iby_trxn_ext_auths_v ite
893: Where op.header_id = h.header_id
894: And op.trxn_extension_id = ite.trxn_extension_id
895: And authorization_status = 0
896: And effective_auth_amount > 0)

Line 925: iby_trxn_ext_auths_v ite

921: OR (h.payment_type_code = 'CREDIT_CARD'
922: AND NOT EXISTS
923: (Select 'valid auth code'
924: From oe_payments op,
925: iby_trxn_ext_auths_v ite
926: Where op.header_id = h.header_id
927: And op.trxn_extension_id = ite.trxn_extension_id
928: And authorization_status = 0
929: And effective_auth_amount > 0)

Line 958: iby_trxn_ext_auths_v ite

954: OR (h.payment_type_code = 'CREDIT_CARD'
955: AND NOT EXISTS
956: (Select 'valid auth code'
957: From oe_payments op,
958: iby_trxn_ext_auths_v ite
959: Where op.header_id = h.header_id
960: And op.trxn_extension_id = ite.trxn_extension_id
961: And authorization_status = 0
962: And effective_auth_amount > 0)

Line 1048: iby_trxn_ext_auths_v ite

1044: OR (h.payment_type_code = 'CREDIT_CARD'
1045: AND NOT EXISTS
1046: (Select 'valid auth code'
1047: From oe_payments op,
1048: iby_trxn_ext_auths_v ite
1049: Where op.header_id = h.header_id
1050: And op.trxn_extension_id = ite.trxn_extension_id
1051: And authorization_status = 0
1052: And effective_auth_amount > 0)

Line 1081: iby_trxn_ext_auths_v ite

1077: OR (h.payment_type_code = 'CREDIT_CARD'
1078: AND NOT EXISTS
1079: (Select 'valid auth code'
1080: From oe_payments op,
1081: iby_trxn_ext_auths_v ite
1082: Where op.header_id = h.header_id
1083: And op.trxn_extension_id = ite.trxn_extension_id
1084: And authorization_status = 0
1085: And effective_auth_amount > 0)

Line 1111: iby_trxn_ext_auths_v ite

1107: OR (h.payment_type_code = 'CREDIT_CARD'
1108: AND NOT EXISTS
1109: (Select 'valid auth code'
1110: From oe_payments op,
1111: iby_trxn_ext_auths_v ite
1112: Where op.header_id = h.header_id
1113: And op.trxn_extension_id = ite.trxn_extension_id
1114: And authorization_status = 0
1115: And effective_auth_amount > 0)

Line 1143: iby_trxn_ext_auths_v ite

1139: OR (h.payment_type_code = 'CREDIT_CARD'
1140: AND NOT EXISTS
1141: (Select 'valid auth code'
1142: From oe_payments op,
1143: iby_trxn_ext_auths_v ite
1144: Where op.header_id = h.header_id
1145: And op.trxn_extension_id = ite.trxn_extension_id
1146: And authorization_status = 0
1147: And effective_auth_amount > 0)

Line 1187: iby_trxn_ext_auths_v ite

1183: OR (h.payment_type_code = 'CREDIT_CARD'
1184: AND NOT EXISTS
1185: (Select 'valid auth code'
1186: From oe_payments op,
1187: iby_trxn_ext_auths_v ite
1188: Where op.header_id = h.header_id
1189: And op.trxn_extension_id = ite.trxn_extension_id
1190: And authorization_status = 0
1191: And effective_auth_amount > 0)

Line 2483: iby_trxn_ext_auths_v ite

2479: OR (h.payment_type_code = 'CREDIT_CARD'
2480: AND NOT EXISTS
2481: (Select 'valid auth code'
2482: From oe_payments op,
2483: iby_trxn_ext_auths_v ite
2484: Where op.header_id = h.header_id
2485: And op.trxn_extension_id = ite.trxn_extension_id
2486: And authorization_status = 0
2487: And effective_auth_amount > 0)

Line 2520: iby_trxn_ext_auths_v ite

2516: OR (h.payment_type_code = 'CREDIT_CARD'
2517: AND NOT EXISTS
2518: (Select 'valid auth code'
2519: From oe_payments op,
2520: iby_trxn_ext_auths_v ite
2521: Where op.header_id = h.header_id
2522: And op.trxn_extension_id = ite.trxn_extension_id
2523: And authorization_status = 0
2524: And effective_auth_amount > 0)

Line 2549: iby_trxn_ext_auths_v ite

2545: OR (h.payment_type_code = 'CREDIT_CARD'
2546: AND NOT EXISTS
2547: (Select 'valid auth code'
2548: From oe_payments op,
2549: iby_trxn_ext_auths_v ite
2550: Where op.header_id = h.header_id
2551: And op.trxn_extension_id = ite.trxn_extension_id
2552: And authorization_status = 0
2553: And effective_auth_amount > 0)

Line 2581: iby_trxn_ext_auths_v ite

2577: OR (h.payment_type_code = 'CREDIT_CARD'
2578: AND NOT EXISTS
2579: (Select 'valid auth code'
2580: From oe_payments op,
2581: iby_trxn_ext_auths_v ite
2582: Where op.header_id = h.header_id
2583: And op.trxn_extension_id = ite.trxn_extension_id
2584: And authorization_status = 0
2585: And effective_auth_amount > 0)

Line 2620: iby_trxn_ext_auths_v ite

2616: OR (h.payment_type_code = 'CREDIT_CARD'
2617: AND NOT EXISTS
2618: (Select 'valid auth code'
2619: From oe_payments op,
2620: iby_trxn_ext_auths_v ite
2621: Where op.header_id = h.header_id
2622: And op.trxn_extension_id = ite.trxn_extension_id
2623: And authorization_status = 0
2624: And effective_auth_amount > 0)

Line 2649: iby_trxn_ext_auths_v ite

2645: OR (h.payment_type_code = 'CREDIT_CARD'
2646: AND NOT EXISTS
2647: (Select 'valid auth code'
2648: From oe_payments op,
2649: iby_trxn_ext_auths_v ite
2650: Where op.header_id = h.header_id
2651: And op.trxn_extension_id = ite.trxn_extension_id
2652: And authorization_status = 0
2653: And effective_auth_amount > 0)

Line 2733: iby_trxn_ext_auths_v ite

2729: OR (h.payment_type_code = 'CREDIT_CARD'
2730: AND NOT EXISTS
2731: (Select 'valid auth code'
2732: From oe_payments op,
2733: iby_trxn_ext_auths_v ite
2734: Where op.header_id = h.header_id
2735: And op.trxn_extension_id = ite.trxn_extension_id
2736: And authorization_status = 0
2737: And effective_auth_amount > 0)

Line 2765: iby_trxn_ext_auths_v ite

2761: OR (h.payment_type_code = 'CREDIT_CARD'
2762: AND NOT EXISTS
2763: (Select 'valid auth code'
2764: From oe_payments op,
2765: iby_trxn_ext_auths_v ite
2766: Where op.header_id = h.header_id
2767: And op.trxn_extension_id = ite.trxn_extension_id
2768: And authorization_status = 0
2769: And effective_auth_amount > 0)

Line 2801: iby_trxn_ext_auths_v ite

2797: OR (h.payment_type_code = 'CREDIT_CARD'
2798: AND NOT EXISTS
2799: (Select 'valid auth code'
2800: From oe_payments op,
2801: iby_trxn_ext_auths_v ite
2802: Where op.header_id = h.header_id
2803: And op.trxn_extension_id = ite.trxn_extension_id
2804: And authorization_status = 0
2805: And effective_auth_amount > 0)

Line 2833: iby_trxn_ext_auths_v ite

2829: OR (h.payment_type_code = 'CREDIT_CARD'
2830: AND NOT EXISTS
2831: (Select 'valid auth code'
2832: From oe_payments op,
2833: iby_trxn_ext_auths_v ite
2834: Where op.header_id = h.header_id
2835: And op.trxn_extension_id = ite.trxn_extension_id
2836: And authorization_status = 0
2837: And effective_auth_amount > 0)

Line 2868: iby_trxn_ext_auths_v ite

2864: OR (h.payment_type_code = 'CREDIT_CARD'
2865: AND NOT EXISTS
2866: (Select 'valid auth code'
2867: From oe_payments op,
2868: iby_trxn_ext_auths_v ite
2869: Where op.header_id = h.header_id
2870: And op.trxn_extension_id = ite.trxn_extension_id
2871: And authorization_status = 0
2872: And effective_auth_amount > 0)