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: BEGIN --7695423

Line 448: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

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

Line 470: FROM OE_ORDER_TYPES_V

466: oe_debug_pub.ADD('Selecting the shipping cchk rule');
467: /*7194250
468: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)
469: INTO l_credit_check_rule_id
470: FROM OE_ORDER_TYPES_V
471: WHERE ORDER_TYPE_ID = p_header_rec.order_type_id;
472: 7194250*/
473: --7194250
474: BEGIN --7695423

Line 477: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

473: --7194250
474: BEGIN --7695423
475: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)
476: INTO l_credit_check_rule_id
477: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
478: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
479: AND SHIPPING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
480: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
481: --7695423 start

Line 2133: FROM OE_ORDER_TYPES_V

2129: oe_debug_pub.ADD('Line Level: Selecting the order entry cchk rule');
2130: /*7194250
2131: SELECT NVL(ENTRY_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: BEGIN --7695423

Line 2140: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

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

Line 2159: FROM OE_ORDER_TYPES_V

2155: oe_debug_pub.ADD('Line Level: Selecting the shipping cchk rule');
2156: /*7194250
2157: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)
2158: INTO l_credit_check_rule_id
2159: FROM OE_ORDER_TYPES_V
2160: WHERE ORDER_TYPE_ID = p_header_rec.order_type_id;
2161: 7194250*/
2162: --7194250
2163: BEGIN --7695423

Line 2166: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

2162: --7194250
2163: BEGIN --7695423
2164: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)
2165: INTO l_credit_check_rule_id
2166: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
2167: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
2168: AND SHIPPING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
2169: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
2170: --7695423 start