APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_ORDER_TYPES_V

Line 3875: FROM OE_ORDER_TYPES_V

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

Line 3881: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

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

Line 3899: FROM OE_ORDER_TYPES_V

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

Line 3905: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

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

Line 3924: FROM OE_ORDER_TYPES_V

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

Line 3930: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

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

Line 3948: FROM OE_ORDER_TYPES_V

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

Line 3954: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

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