APPS.OE_CREDIT_ENGINE_GRP dependencies on OE_ORDER_TYPES_V

Line 129: FROM OE_ORDER_TYPES_V

125:
126: /*7194250
127: SELECT ENTRY_CREDIT_CHECK_RULE_ID
128: INTO x_credit_rule_id
129: FROM OE_ORDER_TYPES_V
130: WHERE ORDER_TYPE_ID = p_order_type_id;
131: 7194250*/
132: --7194250
133: SELECT ENTRY_CREDIT_CHECK_RULE_ID

Line 135: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

131: 7194250*/
132: --7194250
133: SELECT ENTRY_CREDIT_CHECK_RULE_ID
134: INTO x_credit_rule_id
135: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
136: WHERE ORDER_TYPE_ID = p_order_type_id
137: AND ENTRY_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
138: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
139: --7194250

Line 148: FROM OE_ORDER_TYPES_V

144: THEN
145: /*7194250
146: SELECT SHIPPING_CREDIT_CHECK_RULE_ID
147: INTO x_credit_rule_id
148: FROM OE_ORDER_TYPES_V
149: WHERE ORDER_TYPE_ID = p_order_type_id;
150: 7194250*/
151: --7194250
152: SELECT SHIPPING_CREDIT_CHECK_RULE_ID

Line 154: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

150: 7194250*/
151: --7194250
152: SELECT SHIPPING_CREDIT_CHECK_RULE_ID
153: INTO x_credit_rule_id
154: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
155: WHERE ORDER_TYPE_ID = p_order_type_id
156: AND SHIPPING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
157: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
158: --7194250

Line 167: FROM OE_ORDER_TYPES_V

163: THEN
164: /*7194250
165: SELECT PACKING_CREDIT_CHECK_RULE_ID
166: INTO x_credit_rule_id
167: FROM OE_ORDER_TYPES_V
168: WHERE ORDER_TYPE_ID = p_order_type_id;
169: 7194250*/
170: --7194250
171: SELECT PACKING_CREDIT_CHECK_RULE_ID

Line 173: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

169: 7194250*/
170: --7194250
171: SELECT PACKING_CREDIT_CHECK_RULE_ID
172: INTO x_credit_rule_id
173: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
174: WHERE ORDER_TYPE_ID = p_order_type_id
175: AND PACKING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
176: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
177: --7194250

Line 186: FROM OE_ORDER_TYPES_V

182: THEN
183: /*7194250
184: SELECT PICKING_CREDIT_CHECK_RULE_ID
185: INTO x_credit_rule_id
186: FROM OE_ORDER_TYPES_V
187: WHERE ORDER_TYPE_ID = p_order_type_id;
188: 7194250*/
189: --7194250
190: SELECT PICKING_CREDIT_CHECK_RULE_ID

Line 192: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

188: 7194250*/
189: --7194250
190: SELECT PICKING_CREDIT_CHECK_RULE_ID
191: INTO x_credit_rule_id
192: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
193: WHERE ORDER_TYPE_ID = p_order_type_id
194: AND PICKING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
195: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
196: --7194250