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 OE_PAYMENTS

Line 139: FROM OE_PAYMENTS

135: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN
136:
137: SELECT NVL(SUM(commitment_applied_amount), 0)
138: INTO l_order_commitment
139: FROM OE_PAYMENTS
140: WHERE HEADER_ID = p_header_rec.header_id;
141:
142: oe_debug_pub.ADD('OEXPCRCB.pls: order commitment total:' || l_order_commitment);
143:

Line 801: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H --ksurendr SQL# 16485169 Removed OE_PAYMENTS

797:
798: Cursor uninvoiced_orders(p_include_tax VARCHAR2) IS
799: SELECT /* MOAC_SQL_CHANGE */ SUM((NVL(ordered_quantity,0)
800: *NVL(unit_selling_price,0)) + decode(p_include_tax,'Y',NVL(tax_value,0), 0))
801: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H --ksurendr SQL# 16485169 Removed OE_PAYMENTS
802: WHERE H.SOLD_TO_ORG_ID = l_invoice_to_cust_id --table from outer query as it is not used.
803: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
804: AND H.OPEN_FLAG = 'Y'
805: AND H.HEADER_ID = L.HEADER_ID

Line 817: From oe_payments op,

813: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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

Line 856: From oe_payments op,

852: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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

Line 876: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L

872: );
873:
874: Cursor commitment_total IS
875: SELECT /* MOAC_SQL_CHANGE */ NVL(SUM(P.commitment_applied_amount), 0)
876: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L
877: WHERE H.SOLD_TO_ORG_ID = l_invoice_to_cust_id
878: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
879: AND H.OPEN_FLAG = 'Y'
880: AND H.BOOKED_FLAG = 'Y'

Line 891: From oe_payments op,

887: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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

Line 909: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L

905: <= l_shipping_horizon;
906:
907: Cursor on_hold_commitment_total IS
908: SELECT /* MOAC_SQL_CHANGE */ NVL(SUM(P.commitment_applied_amount), 0)
909: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L
910: WHERE H.SOLD_TO_ORG_ID = l_invoice_to_cust_id
911: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
912: AND H.OPEN_FLAG = 'Y'
913: AND H.BOOKED_FLAG = 'Y'

Line 924: From oe_payments op,

920: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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

Line 946: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L

942: AND OH.HOLD_RELEASE_ID IS NULL );
943:
944: Cursor current_commitment_total IS
945: SELECT /* MOAC_SQL_CHANGE */ NVL(SUM(P.commitment_applied_amount), 0)
946: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L
947: WHERE H.HEADER_ID = p_header_rec.header_id
948: AND H.HEADER_ID = P.HEADER_ID
949: /*
950: AND decode(H.CREDIT_CARD_APPROVAL_CODE, NULL, (sysdate -1),

Line 957: From oe_payments op,

953: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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

Line 1047: From oe_payments op,

1043: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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

Line 1080: From oe_payments op,

1076: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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

Line 1096: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L

1092: );
1093:
1094: Cursor site_commitment_total IS
1095: SELECT /* MOAC_SQL_CHANGE */ NVL(SUM(P.commitment_applied_amount), 0)
1096: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L
1097: WHERE H.INVOICE_TO_ORG_ID = p_header_rec.invoice_to_org_id
1098: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
1099: AND H.OPEN_FLAG = 'Y'
1100: AND H.BOOKED_FLAG = 'Y'

Line 1110: From oe_payments op,

1106: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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

Line 1128: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L

1124: <= l_shipping_horizon;
1125:
1126: Cursor site_on_hold_commitment_total IS
1127: SELECT /* MOAC_SQL_CHANGE */ NVL(SUM(P.commitment_applied_amount), 0)
1128: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L
1129: WHERE H.INVOICE_TO_ORG_ID = p_header_rec.invoice_to_org_id
1130: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
1131: AND H.OPEN_FLAG = 'Y'
1132: AND H.BOOKED_FLAG = 'Y'

Line 1142: From oe_payments op,

1138: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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

Line 1186: From oe_payments op,

1182: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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

Line 1783: FROM OE_PAYMENTS P, OE_ORDER_LINES L

1779: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN
1780:
1781: SELECT NVL(SUM(P.commitment_applied_amount), 0)
1782: INTO l_order_commitment
1783: FROM OE_PAYMENTS P, OE_ORDER_LINES L
1784: WHERE P.HEADER_ID = p_header_rec.header_id
1785: AND L.LINE_ID = P.LINE_ID
1786: AND L.INVOICE_TO_ORG_ID = p_invoice_to_org_id;
1787:

Line 2482: From oe_payments op,

2478: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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

Line 2519: From oe_payments op,

2515: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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

Line 2534: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L

2530: AND OH.HOLD_RELEASE_ID IS NULL
2531: );
2532: Cursor commitment_total IS
2533: SELECT /* MOAC_SQL_CHANGE */ NVL(SUM(P.commitment_applied_amount), 0)
2534: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L
2535: WHERE H.SOLD_TO_ORG_ID = p_customer_id
2536: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
2537: AND H.BOOKED_FLAG = 'Y'
2538: AND H.HEADER_ID = P.HEADER_ID

Line 2548: From oe_payments op,

2544: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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

Line 2566: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L

2562: <= l_shipping_horizon;
2563:
2564: Cursor on_hold_commitment_total IS
2565: SELECT /* MOAC_SQL_CHANGE */ NVL(SUM(P.commitment_applied_amount), 0)
2566: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L
2567: WHERE H.SOLD_TO_ORG_ID = p_customer_id
2568: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
2569: AND H.BOOKED_FLAG = 'Y'
2570: AND H.HEADER_ID = P.HEADER_ID

Line 2580: From oe_payments op,

2576: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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

Line 2602: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L

2598: AND OH.HOLD_RELEASE_ID IS NULL);
2599:
2600: Cursor current_commitment_total IS
2601: SELECT /* MOAC_SQL_CHANGE */ NVL(SUM(P.commitment_applied_amount), 0)
2602: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L
2603: WHERE H.HEADER_ID = p_header_rec.header_id
2604: AND H.HEADER_ID = P.HEADER_ID
2605: AND L.HEADER_ID = H.HEADER_ID
2606: AND L.INVOICE_TO_ORG_ID = p_invoice_to_org_id

Line 2619: From oe_payments op,

2615: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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

Line 2648: From oe_payments op,

2644: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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

Line 2732: From oe_payments op,

2728: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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

Line 2764: From oe_payments op,

2760: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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

Line 2780: FROM OE_PAYMENTS P, OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H

2776: );
2777:
2778: Cursor site_commitment_total IS
2779: SELECT /* MOAC_SQL_CHANGE */ NVL(SUM(P.commitment_applied_amount), 0)
2780: FROM OE_PAYMENTS P, OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
2781: WHERE L.INVOICE_TO_ORG_ID = p_invoice_to_org_id
2782: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
2783: AND H.HEADER_ID = P.HEADER_ID
2784: AND L.HEADER_ID = H.HEADER_ID

Line 2800: From oe_payments op,

2796: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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

Line 2811: FROM OE_PAYMENTS P, OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H

2807: );
2808:
2809: Cursor site_on_hold_commitment_total IS
2810: SELECT /* MOAC_SQL_CHANGE */ NVL(SUM(P.commitment_applied_amount), 0)
2811: FROM OE_PAYMENTS P, OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
2812: WHERE L.INVOICE_TO_ORG_ID = p_invoice_to_org_id
2813: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
2814: AND H.HEADER_ID = P.HEADER_ID
2815: AND L.HEADER_ID = H.HEADER_ID

Line 2832: From oe_payments op,

2828: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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

Line 2867: From oe_payments op,

2863: AND (nvl(h.payment_type_code, 'NULL') <> 'CREDIT_CARD'
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