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 836: iby_trxn_ext_auths_v ite

832: OR (h.payment_type_code = 'CREDIT_CARD'
833: AND NOT EXISTS
834: (Select 'valid auth code'
835: From oe_payments op,
836: iby_trxn_ext_auths_v ite
837: Where op.header_id = h.header_id
838: And op.trxn_extension_id = ite.trxn_extension_id
839: And authorization_status = 0
840: And effective_auth_amount > 0)

Line 875: iby_trxn_ext_auths_v ite

871: OR (h.payment_type_code = 'CREDIT_CARD'
872: AND NOT EXISTS
873: (Select 'valid auth code'
874: From oe_payments op,
875: iby_trxn_ext_auths_v ite
876: Where op.header_id = h.header_id
877: And op.trxn_extension_id = ite.trxn_extension_id
878: And authorization_status = 0
879: And effective_auth_amount > 0)

Line 910: iby_trxn_ext_auths_v ite

906: OR (h.payment_type_code = 'CREDIT_CARD'
907: AND NOT EXISTS
908: (Select 'valid auth code'
909: From oe_payments op,
910: iby_trxn_ext_auths_v ite
911: Where op.header_id = h.header_id
912: And op.trxn_extension_id = ite.trxn_extension_id
913: And authorization_status = 0
914: And effective_auth_amount > 0)

Line 943: iby_trxn_ext_auths_v ite

939: OR (h.payment_type_code = 'CREDIT_CARD'
940: AND NOT EXISTS
941: (Select 'valid auth code'
942: From oe_payments op,
943: iby_trxn_ext_auths_v ite
944: Where op.header_id = h.header_id
945: And op.trxn_extension_id = ite.trxn_extension_id
946: And authorization_status = 0
947: And effective_auth_amount > 0)

Line 976: iby_trxn_ext_auths_v ite

972: OR (h.payment_type_code = 'CREDIT_CARD'
973: AND NOT EXISTS
974: (Select 'valid auth code'
975: From oe_payments op,
976: iby_trxn_ext_auths_v ite
977: Where op.header_id = h.header_id
978: And op.trxn_extension_id = ite.trxn_extension_id
979: And authorization_status = 0
980: And effective_auth_amount > 0)

Line 1066: iby_trxn_ext_auths_v ite

1062: OR (h.payment_type_code = 'CREDIT_CARD'
1063: AND NOT EXISTS
1064: (Select 'valid auth code'
1065: From oe_payments op,
1066: iby_trxn_ext_auths_v ite
1067: Where op.header_id = h.header_id
1068: And op.trxn_extension_id = ite.trxn_extension_id
1069: And authorization_status = 0
1070: And effective_auth_amount > 0)

Line 1099: iby_trxn_ext_auths_v ite

1095: OR (h.payment_type_code = 'CREDIT_CARD'
1096: AND NOT EXISTS
1097: (Select 'valid auth code'
1098: From oe_payments op,
1099: iby_trxn_ext_auths_v ite
1100: Where op.header_id = h.header_id
1101: And op.trxn_extension_id = ite.trxn_extension_id
1102: And authorization_status = 0
1103: And effective_auth_amount > 0)

Line 1129: iby_trxn_ext_auths_v ite

1125: OR (h.payment_type_code = 'CREDIT_CARD'
1126: AND NOT EXISTS
1127: (Select 'valid auth code'
1128: From oe_payments op,
1129: iby_trxn_ext_auths_v ite
1130: Where op.header_id = h.header_id
1131: And op.trxn_extension_id = ite.trxn_extension_id
1132: And authorization_status = 0
1133: And effective_auth_amount > 0)

Line 1161: iby_trxn_ext_auths_v ite

1157: OR (h.payment_type_code = 'CREDIT_CARD'
1158: AND NOT EXISTS
1159: (Select 'valid auth code'
1160: From oe_payments op,
1161: iby_trxn_ext_auths_v ite
1162: Where op.header_id = h.header_id
1163: And op.trxn_extension_id = ite.trxn_extension_id
1164: And authorization_status = 0
1165: And effective_auth_amount > 0)

Line 1205: iby_trxn_ext_auths_v ite

1201: OR (h.payment_type_code = 'CREDIT_CARD'
1202: AND NOT EXISTS
1203: (Select 'valid auth code'
1204: From oe_payments op,
1205: iby_trxn_ext_auths_v ite
1206: Where op.header_id = h.header_id
1207: And op.trxn_extension_id = ite.trxn_extension_id
1208: And authorization_status = 0
1209: And effective_auth_amount > 0)

Line 2519: iby_trxn_ext_auths_v ite

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

Line 2556: iby_trxn_ext_auths_v ite

2552: OR (h.payment_type_code = 'CREDIT_CARD'
2553: AND NOT EXISTS
2554: (Select 'valid auth code'
2555: From oe_payments op,
2556: iby_trxn_ext_auths_v ite
2557: Where op.header_id = h.header_id
2558: And op.trxn_extension_id = ite.trxn_extension_id
2559: And authorization_status = 0
2560: And effective_auth_amount > 0)

Line 2585: iby_trxn_ext_auths_v ite

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

Line 2617: iby_trxn_ext_auths_v ite

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

Line 2656: iby_trxn_ext_auths_v ite

2652: OR (h.payment_type_code = 'CREDIT_CARD'
2653: AND NOT EXISTS
2654: (Select 'valid auth code'
2655: From oe_payments op,
2656: iby_trxn_ext_auths_v ite
2657: Where op.header_id = h.header_id
2658: And op.trxn_extension_id = ite.trxn_extension_id
2659: And authorization_status = 0
2660: And effective_auth_amount > 0)

Line 2685: iby_trxn_ext_auths_v ite

2681: OR (h.payment_type_code = 'CREDIT_CARD'
2682: AND NOT EXISTS
2683: (Select 'valid auth code'
2684: From oe_payments op,
2685: iby_trxn_ext_auths_v ite
2686: Where op.header_id = h.header_id
2687: And op.trxn_extension_id = ite.trxn_extension_id
2688: And authorization_status = 0
2689: And effective_auth_amount > 0)

Line 2769: iby_trxn_ext_auths_v ite

2765: OR (h.payment_type_code = 'CREDIT_CARD'
2766: AND NOT EXISTS
2767: (Select 'valid auth code'
2768: From oe_payments op,
2769: iby_trxn_ext_auths_v ite
2770: Where op.header_id = h.header_id
2771: And op.trxn_extension_id = ite.trxn_extension_id
2772: And authorization_status = 0
2773: 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 2837: iby_trxn_ext_auths_v ite

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

Line 2869: iby_trxn_ext_auths_v ite

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

Line 2904: iby_trxn_ext_auths_v ite

2900: OR (h.payment_type_code = 'CREDIT_CARD'
2901: AND NOT EXISTS
2902: (Select 'valid auth code'
2903: From oe_payments op,
2904: iby_trxn_ext_auths_v ite
2905: Where op.header_id = h.header_id
2906: And op.trxn_extension_id = ite.trxn_extension_id
2907: And authorization_status = 0
2908: And effective_auth_amount > 0)