APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_ORDER_TYPES_V

Line 3876: FROM OE_ORDER_TYPES_V

3872: END IF;
3873: /*7194250
3874: SELECT ENTRY_CREDIT_CHECK_RULE_ID
3875: INTO x_credit_rule_id
3876: FROM OE_ORDER_TYPES_V
3877: WHERE ORDER_TYPE_ID = p_order_type_id;
3878: 7194250*/
3879: --7194250
3880: SELECT NVL(ENTRY_CREDIT_CHECK_RULE_ID, -1)

Line 3882: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

3878: 7194250*/
3879: --7194250
3880: SELECT NVL(ENTRY_CREDIT_CHECK_RULE_ID, -1)
3881: INTO x_credit_rule_id
3882: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
3883: WHERE OT.ORDER_TYPE_ID = p_order_type_id
3884: AND ENTRY_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
3885: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
3886: --7194250

Line 3900: FROM OE_ORDER_TYPES_V

3896:
3897: /*7194250
3898: SELECT SHIPPING_CREDIT_CHECK_RULE_ID
3899: INTO x_credit_rule_id
3900: FROM OE_ORDER_TYPES_V
3901: WHERE ORDER_TYPE_ID = p_order_type_id;
3902: 7194250*/
3903: --7194250
3904: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)

Line 3906: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

3902: 7194250*/
3903: --7194250
3904: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)
3905: INTO x_credit_rule_id
3906: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
3907: WHERE OT.ORDER_TYPE_ID = p_order_type_id
3908: AND SHIPPING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
3909: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
3910: --7194250

Line 3925: FROM OE_ORDER_TYPES_V

3921:
3922: /*7194250
3923: SELECT PICKING_CREDIT_CHECK_RULE_ID
3924: INTO x_credit_rule_id
3925: FROM OE_ORDER_TYPES_V
3926: WHERE ORDER_TYPE_ID = p_order_type_id;
3927: 7194250*/
3928: --7194250
3929: SELECT NVL(PICKING_CREDIT_CHECK_RULE_ID, -1)

Line 3931: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

3927: 7194250*/
3928: --7194250
3929: SELECT NVL(PICKING_CREDIT_CHECK_RULE_ID, -1)
3930: INTO x_credit_rule_id
3931: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
3932: WHERE OT.ORDER_TYPE_ID = p_order_type_id
3933: AND PICKING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
3934: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
3935: --7194250

Line 3949: FROM OE_ORDER_TYPES_V

3945:
3946: /*7194250
3947: SELECT PACKING_CREDIT_CHECK_RULE_ID
3948: INTO x_credit_rule_id
3949: FROM OE_ORDER_TYPES_V
3950: WHERE ORDER_TYPE_ID = p_order_type_id;
3951: 7194250*/
3952: --7194250
3953: SELECT NVL(PACKING_CREDIT_CHECK_RULE_ID, -1)

Line 3955: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

3951: 7194250*/
3952: --7194250
3953: SELECT NVL(PACKING_CREDIT_CHECK_RULE_ID, -1)
3954: INTO x_credit_rule_id
3955: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
3956: WHERE OT.ORDER_TYPE_ID = p_order_type_id
3957: AND PACKING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
3958: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
3959: --7194250