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_TYPES_V

Line 441: FROM OE_ORDER_TYPES_V

437: oe_debug_pub.ADD('Selecting the order entry cchk rule');
438: /*7194250
439: SELECT NVL(ENTRY_CREDIT_CHECK_RULE_ID, -1)
440: INTO l_credit_check_rule_id
441: FROM OE_ORDER_TYPES_V
442: WHERE ORDER_TYPE_ID = p_header_rec.order_type_id;
443: 7194250*/
444: --7194250
445: SELECT NVL(ENTRY_CREDIT_CHECK_RULE_ID, -1)

Line 447: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

443: 7194250*/
444: --7194250
445: SELECT NVL(ENTRY_CREDIT_CHECK_RULE_ID, -1)
446: INTO l_credit_check_rule_id
447: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
448: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
449: AND ENTRY_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
450: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
451: --7194250

Line 462: FROM OE_ORDER_TYPES_V

458: oe_debug_pub.ADD('Selecting the shipping cchk rule');
459: /*7194250
460: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)
461: INTO l_credit_check_rule_id
462: FROM OE_ORDER_TYPES_V
463: WHERE ORDER_TYPE_ID = p_header_rec.order_type_id;
464: 7194250*/
465: --7194250
466: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)

Line 468: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

464: 7194250*/
465: --7194250
466: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)
467: INTO l_credit_check_rule_id
468: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
469: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
470: AND SHIPPING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
471: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
472: --7194250

Line 2115: FROM OE_ORDER_TYPES_V

2111: oe_debug_pub.ADD('Line Level: Selecting the order entry cchk rule');
2112: /*7194250
2113: SELECT NVL(ENTRY_CREDIT_CHECK_RULE_ID, -1)
2114: INTO l_credit_check_rule_id
2115: FROM OE_ORDER_TYPES_V
2116: WHERE ORDER_TYPE_ID = p_header_rec.order_type_id;
2117: 7194250*/
2118: --7194250
2119: SELECT NVL(ENTRY_CREDIT_CHECK_RULE_ID, -1)

Line 2121: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

2117: 7194250*/
2118: --7194250
2119: SELECT NVL(ENTRY_CREDIT_CHECK_RULE_ID, -1)
2120: INTO l_credit_check_rule_id
2121: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
2122: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
2123: AND ENTRY_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
2124: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
2125: --7194250

Line 2133: FROM OE_ORDER_TYPES_V

2129: oe_debug_pub.ADD('Line Level: Selecting the shipping cchk rule');
2130: /*7194250
2131: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)
2132: INTO l_credit_check_rule_id
2133: FROM OE_ORDER_TYPES_V
2134: WHERE ORDER_TYPE_ID = p_header_rec.order_type_id;
2135: 7194250*/
2136: --7194250
2137: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)

Line 2139: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

2135: 7194250*/
2136: --7194250
2137: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)
2138: INTO l_credit_check_rule_id
2139: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
2140: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
2141: AND SHIPPING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
2142: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
2143: --7194250