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

Line 131: FROM OE_ORDER_LINES

127: SELECT SUM(decode(l_include_tax_flag , 'Y', NVL(tax_value,0),0)
128: + (NVL(unit_selling_price,0)
129: * (NVL(ordered_quantity,0) )))
130: INTO l_order_value
131: FROM OE_ORDER_LINES
132: WHERE HEADER_ID = p_header_rec.header_id;
133:
134: -- Get Total Commitments applied to the current order if Commitment Sequencing is "On"
135: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN

Line 631: FROM OE_ORDER_LINES L, OE_RA_TERMS_V T

627: BEGIN
628:
629: SELECT COUNT(*)
630: INTO l_credit_check_term
631: FROM OE_ORDER_LINES L, OE_RA_TERMS_V T
632: WHERE L.HEADER_ID = p_header_rec.header_id
633: AND T.TERM_ID = L.PAYMENT_TERM_ID
634: AND NVL(T.CREDIT_CHECK_FLAG, 'Y') = 'Y';
635:

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

836:
837: Cursor orders_on_hold(p_include_tax VARCHAR2) IS
838: SELECT /* MOAC_SQL_CHANGE */ SUM((NVL(ordered_quantity,0)
839: *NVL(unit_selling_price,0)) + decode(p_include_tax, 'Y',NVL(tax_value,0),0))
840: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
841: WHERE H.SOLD_TO_ORG_ID = l_invoice_to_cust_id
842: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
843: AND H.OPEN_FLAG = 'Y'
844: AND H.HEADER_ID = L.HEADER_ID

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

1023:
1024: Cursor site_uninvoiced_orders(p_include_tax VARCHAR2) IS
1025: SELECT /* MOAC_SQL_CHANGE */ SUM(((NVL(ordered_quantity,0) )
1026: *NVL(unit_selling_price,0)) + decode(p_include_tax, 'Y', nvl(tax_value,0), 0))
1027: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
1028: WHERE H.INVOICE_TO_ORG_ID = p_header_rec.invoice_to_org_id
1029: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
1030: AND H.OPEN_FLAG = 'Y'
1031: AND H.HEADER_ID = L.HEADER_ID

Line 1060: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H

1056: Cursor site_orders_on_hold(p_include_tax VARCHAR2) IS
1057:
1058: SELECT /* MOAC_SQL_CHANGE */ SUM(((NVL(ordered_quantity,0))
1059: *NVL(unit_selling_price,0)) + decode(p_include_tax, 'Y', NVL(tax_value,0),0))
1060: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
1061: WHERE H.INVOICE_TO_ORG_ID = p_header_rec.invoice_to_org_id
1062: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
1063: AND H.OPEN_FLAG = 'Y'
1064: AND H.HEADER_ID = L.HEADER_ID

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

1166: -- shipping horizon for credit checking.
1167: Cursor current_order(p_include_tax VARCHAR2) IS
1168: SELECT /* MOAC_SQL_CHANGE */ SUM((NVL(ordered_quantity,0)
1169: *NVL(unit_selling_price,0)) + decode(p_include_tax,'Y', NVL(tax_value,0), 0))
1170: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
1171: WHERE H.HEADER_ID = p_header_rec.header_id
1172: AND H.HEADER_ID = L.HEADER_ID
1173: -- AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,H.REQUEST_DATE))
1174: -- <= to_date(l_shipping_horizon, 'DD-MON-YY')

Line 1759: FROM OE_ORDER_LINES

1755: SELECT SUM(decode(l_include_tax_flag , 'Y', NVL(tax_value,0),0)
1756: + (NVL(unit_selling_price,0)
1757: * (NVL(ordered_quantity,0) )))
1758: INTO l_order_value
1759: FROM OE_ORDER_LINES
1760: WHERE HEADER_ID = p_header_rec.header_id
1761: AND invoice_to_org_id = p_invoice_to_org_id;
1762: /*
1763: ELSE

Line 1768: FROM OE_ORDER_LINES

1764: SELECT SUM(decode(l_include_tax_flag , 'Y', NVL(tax_value,0),0)
1765: + (NVL(unit_selling_price,0)
1766: * (NVL(ordered_quantity,0) )))
1767: INTO l_order_value
1768: FROM OE_ORDER_LINES
1769: WHERE HEADER_ID = p_header_rec.header_id
1770: AND sold_to_org_id = (select organization_id
1771: from oe_sold_to_orgs_v
1772: where customer_id = p_customer_id);

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 2293: FROM OE_ORDER_LINES L, OE_RA_TERMS_V T

2289: BEGIN
2290:
2291: SELECT COUNT(*)
2292: INTO l_credit_check_term
2293: FROM OE_ORDER_LINES L, OE_RA_TERMS_V T
2294: WHERE L.header_id = p_header_rec.header_id
2295: AND L.invoice_to_org_id = p_invoice_to_org_id
2296: AND L.PAYMENT_TERM_ID = T.TERM_ID
2297: AND NVL(T.CREDIT_CHECK_FLAG, 'Y') = 'Y';

Line 2463: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H

2459:
2460: Cursor uninvoiced_orders(p_include_tax VARCHAR2) IS
2461: SELECT /* MOAC_SQL_CHANGE */ SUM((NVL(ordered_quantity,0)
2462: *NVL(unit_selling_price,0)) + decode(p_include_tax,'Y',NVL(tax_value,0), 0))
2463: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
2464: WHERE H.SOLD_TO_ORG_ID = p_customer_id
2465: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
2466: AND H.HEADER_ID = L.HEADER_ID
2467: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,H.REQUEST_DATE))

Line 2500: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H

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

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

2627:
2628: Cursor current_order(p_include_tax VARCHAR2) IS
2629: SELECT /* MOAC_SQL_CHANGE */ SUM((NVL(ordered_quantity,0)
2630: *NVL(unit_selling_price,0)) + decode(p_include_tax,'Y', NVL(tax_value,0), 0))
2631: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
2632: WHERE H.HEADER_ID = p_header_rec.header_id
2633: AND H.HEADER_ID = L.HEADER_ID
2634: AND L.INVOICE_TO_ORG_ID = p_invoice_to_org_id
2635: -- AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,H.REQUEST_DATE))

Line 2713: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H

2709:
2710: Cursor site_uninvoiced_orders(p_include_tax VARCHAR2) IS
2711: SELECT /* MOAC_SQL_CHANGE */ SUM(((NVL(ordered_quantity,0) )
2712: *NVL(unit_selling_price,0)) + decode(p_include_tax, 'Y', nvl(tax_value,0), 0))
2713: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
2714: WHERE L.INVOICE_TO_ORG_ID = p_invoice_to_org_id
2715: AND H.TRANSACTIONAL_CURR_CODE = p_header_rec.transactional_curr_code
2716: AND H.HEADER_ID = L.HEADER_ID
2717: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,H.REQUEST_DATE))

Line 2745: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H

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

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

2846:
2847: Cursor site_current_order(p_include_tax VARCHAR2) IS
2848: SELECT /* MOAC_SQL_CHANGE */ SUM((NVL(ordered_quantity,0)
2849: *NVL(unit_selling_price,0)) + decode(p_include_tax,'Y', NVL(tax_value,0), 0))
2850: FROM OE_ORDER_LINES_ALL L, OE_ORDER_HEADERS H
2851: WHERE H.HEADER_ID = p_header_rec.header_id
2852: AND H.HEADER_ID = L.HEADER_ID
2853: AND L.invoice_to_org_id = p_invoice_to_org_id
2854: -- AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,H.REQUEST_DATE))