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_ORDER_LINES_ALL

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 858: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H

854:
855: Cursor orders_on_hold(p_include_tax VARCHAR2) IS
856: SELECT /* MOAC_SQL_CHANGE */ SUM((NVL(ordered_quantity,0)
857: *NVL(unit_selling_price,0)) + decode(p_include_tax, 'Y',NVL(tax_value,0),0))
858: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
859: WHERE H.SOLD_TO_ORG_ID = l_invoice_to_cust_id
860: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
861: AND H.OPEN_FLAG = 'Y'
862: AND H.HEADER_ID = L.HEADER_ID

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 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 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 1045: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H

1041:
1042: Cursor site_uninvoiced_orders(p_include_tax VARCHAR2) IS
1043: SELECT /* MOAC_SQL_CHANGE */ SUM(((NVL(ordered_quantity,0) )
1044: *NVL(unit_selling_price,0)) + decode(p_include_tax, 'Y', nvl(tax_value,0), 0))
1045: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
1046: WHERE H.INVOICE_TO_ORG_ID = p_header_rec.invoice_to_org_id
1047: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
1048: AND H.OPEN_FLAG = 'Y'
1049: AND H.HEADER_ID = L.HEADER_ID

Line 1078: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H

1074: Cursor site_orders_on_hold(p_include_tax VARCHAR2) IS
1075:
1076: SELECT /* MOAC_SQL_CHANGE */ SUM(((NVL(ordered_quantity,0))
1077: *NVL(unit_selling_price,0)) + decode(p_include_tax, 'Y', NVL(tax_value,0),0))
1078: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
1079: WHERE H.INVOICE_TO_ORG_ID = p_header_rec.invoice_to_org_id
1080: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
1081: AND H.OPEN_FLAG = 'Y'
1082: AND H.HEADER_ID = L.HEADER_ID

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 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 1188: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H

1184: -- shipping horizon for credit checking.
1185: Cursor current_order(p_include_tax VARCHAR2) IS
1186: SELECT /* MOAC_SQL_CHANGE */ SUM((NVL(ordered_quantity,0)
1187: *NVL(unit_selling_price,0)) + decode(p_include_tax,'Y', NVL(tax_value,0), 0))
1188: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
1189: WHERE H.HEADER_ID = p_header_rec.header_id
1190: AND H.HEADER_ID = L.HEADER_ID
1191: -- AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,H.REQUEST_DATE))
1192: -- <= to_date(l_shipping_horizon, 'DD-MON-YY')

Line 2499: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H

2495:
2496: Cursor uninvoiced_orders(p_include_tax VARCHAR2) IS
2497: SELECT /* MOAC_SQL_CHANGE */ SUM((NVL(ordered_quantity,0)
2498: *NVL(unit_selling_price,0)) + decode(p_include_tax,'Y',NVL(tax_value,0), 0))
2499: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
2500: WHERE H.SOLD_TO_ORG_ID = p_customer_id
2501: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
2502: AND H.HEADER_ID = L.HEADER_ID
2503: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,H.REQUEST_DATE))

Line 2536: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H

2532:
2533: Cursor /* MOAC_SQL_CHANGE */ orders_on_hold(p_include_tax VARCHAR2) IS
2534: SELECT SUM((NVL(ordered_quantity,0)
2535: *NVL(unit_selling_price,0)) + decode(p_include_tax, 'Y',NVL(tax_value,0),0))
2536: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
2537: WHERE H.SOLD_TO_ORG_ID = p_customer_id
2538: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
2539: AND H.HEADER_ID = L.HEADER_ID
2540: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,H.REQUEST_DATE))

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 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 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 2667: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H

2663:
2664: Cursor current_order(p_include_tax VARCHAR2) IS
2665: SELECT /* MOAC_SQL_CHANGE */ SUM((NVL(ordered_quantity,0)
2666: *NVL(unit_selling_price,0)) + decode(p_include_tax,'Y', NVL(tax_value,0), 0))
2667: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
2668: WHERE H.HEADER_ID = p_header_rec.header_id
2669: AND H.HEADER_ID = L.HEADER_ID
2670: AND L.INVOICE_TO_ORG_ID = p_invoice_to_org_id
2671: -- AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,H.REQUEST_DATE))

Line 2749: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H

2745:
2746: Cursor site_uninvoiced_orders(p_include_tax VARCHAR2) IS
2747: SELECT /* MOAC_SQL_CHANGE */ SUM(((NVL(ordered_quantity,0) )
2748: *NVL(unit_selling_price,0)) + decode(p_include_tax, 'Y', nvl(tax_value,0), 0))
2749: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
2750: WHERE L.INVOICE_TO_ORG_ID = p_invoice_to_org_id
2751: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
2752: AND H.HEADER_ID = L.HEADER_ID
2753: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,H.REQUEST_DATE))

Line 2781: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H

2777: Cursor site_orders_on_hold(p_include_tax VARCHAR2) IS
2778:
2779: SELECT /* MOAC_SQL_CHANGE */ SUM(((NVL(ordered_quantity,0))
2780: *NVL(unit_selling_price,0)) + decode(p_include_tax, 'Y', NVL(tax_value,0),0))
2781: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
2782: WHERE L.INVOICE_TO_ORG_ID = p_invoice_to_org_id
2783: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
2784: AND H.HEADER_ID = L.HEADER_ID
2785: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,H.REQUEST_DATE))

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 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 2886: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H

2882:
2883: Cursor site_current_order(p_include_tax VARCHAR2) IS
2884: SELECT /* MOAC_SQL_CHANGE */ SUM((NVL(ordered_quantity,0)
2885: *NVL(unit_selling_price,0)) + decode(p_include_tax,'Y', NVL(tax_value,0), 0))
2886: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
2887: WHERE H.HEADER_ID = p_header_rec.header_id
2888: AND H.HEADER_ID = L.HEADER_ID
2889: AND L.invoice_to_org_id = p_invoice_to_org_id
2890: -- AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,H.REQUEST_DATE))