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 819: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H --ksurendr SQL# 16485169 Removed OE_PAYMENTS

815:
816: Cursor uninvoiced_orders(p_include_tax VARCHAR2) IS
817: SELECT /* MOAC_SQL_CHANGE */ SUM((NVL(ordered_quantity,0)
818: *NVL(unit_selling_price,0)) + decode(p_include_tax,'Y',NVL(tax_value,0), 0))
819: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H --ksurendr SQL# 16485169 Removed OE_PAYMENTS
820: WHERE H.SOLD_TO_ORG_ID = l_invoice_to_cust_id --table from outer query as it is not used.
821: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
822: AND H.OPEN_FLAG = 'Y'
823: AND H.HEADER_ID = L.HEADER_ID

Line 835: From oe_payments op,

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

Line 874: From oe_payments op,

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

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

890: );
891:
892: Cursor commitment_total IS
893: SELECT /* MOAC_SQL_CHANGE */ NVL(SUM(P.commitment_applied_amount), 0)
894: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L
895: WHERE H.SOLD_TO_ORG_ID = l_invoice_to_cust_id
896: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
897: AND H.OPEN_FLAG = 'Y'
898: AND H.BOOKED_FLAG = 'Y'

Line 909: From oe_payments op,

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

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

923: <= l_shipping_horizon;
924:
925: Cursor on_hold_commitment_total IS
926: SELECT /* MOAC_SQL_CHANGE */ NVL(SUM(P.commitment_applied_amount), 0)
927: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L
928: WHERE H.SOLD_TO_ORG_ID = l_invoice_to_cust_id
929: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
930: AND H.OPEN_FLAG = 'Y'
931: AND H.BOOKED_FLAG = 'Y'

Line 942: From oe_payments op,

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

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

960: AND OH.HOLD_RELEASE_ID IS NULL );
961:
962: Cursor current_commitment_total IS
963: SELECT /* MOAC_SQL_CHANGE */ NVL(SUM(P.commitment_applied_amount), 0)
964: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L
965: WHERE H.HEADER_ID = p_header_rec.header_id
966: AND H.HEADER_ID = P.HEADER_ID
967: /*
968: AND decode(H.CREDIT_CARD_APPROVAL_CODE, NULL, (sysdate -1),

Line 975: From oe_payments op,

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

Line 1065: From oe_payments op,

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

Line 1098: From oe_payments op,

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

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

1110: );
1111:
1112: Cursor site_commitment_total IS
1113: SELECT /* MOAC_SQL_CHANGE */ NVL(SUM(P.commitment_applied_amount), 0)
1114: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L
1115: WHERE H.INVOICE_TO_ORG_ID = p_header_rec.invoice_to_org_id
1116: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
1117: AND H.OPEN_FLAG = 'Y'
1118: AND H.BOOKED_FLAG = 'Y'

Line 1128: From oe_payments op,

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

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

1142: <= l_shipping_horizon;
1143:
1144: Cursor site_on_hold_commitment_total IS
1145: SELECT /* MOAC_SQL_CHANGE */ NVL(SUM(P.commitment_applied_amount), 0)
1146: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L
1147: WHERE H.INVOICE_TO_ORG_ID = p_header_rec.invoice_to_org_id
1148: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
1149: AND H.OPEN_FLAG = 'Y'
1150: AND H.BOOKED_FLAG = 'Y'

Line 1160: From oe_payments op,

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

Line 1204: From oe_payments op,

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

Line 1801: FROM OE_PAYMENTS P, OE_ORDER_LINES L

1797: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN
1798:
1799: SELECT NVL(SUM(P.commitment_applied_amount), 0)
1800: INTO l_order_commitment
1801: FROM OE_PAYMENTS P, OE_ORDER_LINES L
1802: WHERE P.HEADER_ID = p_header_rec.header_id
1803: AND L.LINE_ID = P.LINE_ID
1804: AND L.INVOICE_TO_ORG_ID = p_invoice_to_org_id;
1805:

Line 2518: From oe_payments op,

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

Line 2555: From oe_payments op,

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

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

2566: AND OH.HOLD_RELEASE_ID IS NULL
2567: );
2568: Cursor commitment_total IS
2569: SELECT /* MOAC_SQL_CHANGE */ NVL(SUM(P.commitment_applied_amount), 0)
2570: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L
2571: WHERE H.SOLD_TO_ORG_ID = p_customer_id
2572: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
2573: AND H.BOOKED_FLAG = 'Y'
2574: AND H.HEADER_ID = P.HEADER_ID

Line 2584: From oe_payments op,

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

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

2598: <= l_shipping_horizon;
2599:
2600: Cursor on_hold_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.SOLD_TO_ORG_ID = p_customer_id
2604: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
2605: AND H.BOOKED_FLAG = 'Y'
2606: AND H.HEADER_ID = P.HEADER_ID

Line 2616: From oe_payments op,

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

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

2634: AND OH.HOLD_RELEASE_ID IS NULL);
2635:
2636: Cursor current_commitment_total IS
2637: SELECT /* MOAC_SQL_CHANGE */ NVL(SUM(P.commitment_applied_amount), 0)
2638: FROM OE_PAYMENTS P, OE_ORDER_HEADERS H, OE_ORDER_LINES_ALL L
2639: WHERE H.HEADER_ID = p_header_rec.header_id
2640: AND H.HEADER_ID = P.HEADER_ID
2641: AND L.HEADER_ID = H.HEADER_ID
2642: AND L.INVOICE_TO_ORG_ID = p_invoice_to_org_id

Line 2655: From oe_payments op,

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

Line 2684: From oe_payments op,

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

Line 2768: From oe_payments op,

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

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 2816: FROM OE_PAYMENTS P, OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H

2812: );
2813:
2814: Cursor site_commitment_total IS
2815: SELECT /* MOAC_SQL_CHANGE */ NVL(SUM(P.commitment_applied_amount), 0)
2816: FROM OE_PAYMENTS P, OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
2817: WHERE L.INVOICE_TO_ORG_ID = p_invoice_to_org_id
2818: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
2819: AND H.HEADER_ID = P.HEADER_ID
2820: AND L.HEADER_ID = H.HEADER_ID

Line 2836: From oe_payments op,

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

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

2843: );
2844:
2845: Cursor site_on_hold_commitment_total IS
2846: SELECT /* MOAC_SQL_CHANGE */ NVL(SUM(P.commitment_applied_amount), 0)
2847: FROM OE_PAYMENTS P, OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
2848: WHERE L.INVOICE_TO_ORG_ID = p_invoice_to_org_id
2849: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
2850: AND H.HEADER_ID = P.HEADER_ID
2851: AND L.HEADER_ID = H.HEADER_ID

Line 2868: From oe_payments op,

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

Line 2903: From oe_payments op,

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