APPS.ASO_TAX_INT dependencies on OE_ORDER_TYPES_V

Line 3487: FROM oe_order_types_v ot

3483: END IF;
3484:
3485: SELECT NVL(ot.cust_trx_type_id, 0)
3486: INTO l_cust_trx_type_id
3487: FROM oe_order_types_v ot
3488: WHERE ot.order_type_id =l_order_type_id;
3489:
3490: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3491: aso_debug_pub.add(' ASO_TAX_INT l_cust_trx_type_id =0after '||l_cust_trx_type_id , 1, 'N');

Line 3525: FROM oe_order_types_v ot

3521:
3522: IF l_inv_cust_trx_type_id = 0 THEN
3523: SELECT NVL(DECODE(ot.order_category_code, 'RETURN',ot.cust_trx_type_id, 0), 0)
3524: INTO l_inv_cust_trx_type_id
3525: FROM oe_order_types_v ot
3526: WHERE ot.order_type_id = l_order_type_id;
3527: END IF;
3528: IF l_inv_cust_trx_type_id <> 0 THEN
3529: