APPS.ASO_TAX_INT dependencies on OE_ORDER_TYPES_V

Line 3585: FROM oe_order_types_v ot

3581: END IF;
3582:
3583: SELECT NVL(ot.cust_trx_type_id, 0)
3584: INTO l_cust_trx_type_id
3585: FROM oe_order_types_v ot
3586: WHERE ot.order_type_id =l_order_type_id;
3587:
3588: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3589: aso_debug_pub.add(' ASO_TAX_INT l_cust_trx_type_id =0after '||l_cust_trx_type_id , 1, 'N');

Line 3628: FROM oe_order_types_v ot

3624:
3625: IF l_inv_cust_trx_type_id = 0 THEN
3626: SELECT NVL(DECODE(ot.order_category_code, 'RETURN',ot.cust_trx_type_id, 0), 0)
3627: INTO l_inv_cust_trx_type_id
3628: FROM oe_order_types_v ot
3629: WHERE ot.order_type_id = l_order_type_id;
3630: END IF;
3631: IF l_inv_cust_trx_type_id <> 0 THEN
3632: