APPS.ASO_TAX_INT dependencies on OE_TRANSACTION_TYPES

Line 1725: oe_transaction_types_vl oe

1721: select oe.transaction_type_id
1722: into l_om_trx_type_id
1723: --from ra_cust_trx_types_all ra Commented Code Yogeshwar (MOAC)
1724: from ra_cust_trx_types ra, --New Code Yogeshwar (MOAC)
1725: oe_transaction_types_vl oe
1726: where ra.cust_trx_type_id = l_trx_type_id
1727: and ra.cust_trx_type_id = oe.cust_trx_type_id
1728: and oe.transaction_type_id = nvl(l_qte_line_tbl(i).order_line_type_id, l_qte_header_rec.order_type_id)
1729: --Commented code start Yogeshwar(MOAC)

Line 1741: --Need to find org striped synonym for OE_TRANSACTION_TYPES_ALL Yogeshwar

1737:
1738: and (( tax_calculation_flag = 'Y' ) or ( l_hdr_tax_exempt_flag='R' ))
1739: and ra.org_id = l_qte_header_rec.org_id ; --New Code Yogeshwar (MOAC)
1740:
1741: --Need to find org striped synonym for OE_TRANSACTION_TYPES_ALL Yogeshwar
1742:
1743: EXCEPTION
1744:
1745: WHEN NO_DATA_FOUND THEN

Line 1752: l_reason := l_reason || 'ra_cust_trx_types_all and oe_transaction_types_vl';

1748: aso_debug_pub.add('ASO_TAX_LINE: NO_DATA_FOUND when selecting transaction_type_id', 1, 'Y');
1749: END IF;
1750:
1751: l_reason := 'No Data Found Exception when selecting transaction_type_id from ';
1752: l_reason := l_reason || 'ra_cust_trx_types_all and oe_transaction_types_vl';
1753: l_reason := l_reason || fnd_global.newline();
1754: l_reason := l_reason || 'Please check Default order type id profile is ';
1755: l_reason := l_reason || 'correctly set. Also pl verify the';
1756: l_reason := l_reason || fnd_global.newline();

Line 2315: FROM OE_TRANSACTION_TYPES

2311: from ar_system_parameters;
2312:
2313: Cursor c_INVOICE_SOURCE_ID is
2314: select INVOICE_SOURCE_ID
2315: FROM OE_TRANSACTION_TYPES
2316: WHERE TRANSACTION_TYPE_ID=l_qte_header_rec.ORDER_TYPE_ID;
2317:
2318: -- new cursors added by suyog bug 5061912
2319:

Line 3479: FROM OE_TRANSACTION_TYPES_VL

3475: FUNCTION GET_ra_trx_type_ID (p_order_type_id NUMBER,p_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type) RETURN NUMBER
3476: IS
3477: CURSOR C_OE_trns(l_order_type_Id NUMBER) IS
3478: SELECT default_inbound_line_type_id, default_outbound_line_type_id, cust_trx_type_id
3479: FROM OE_TRANSACTION_TYPES_VL
3480: WHERE transaction_type_id=l_order_type_Id;
3481: l_in_line_type NUMBER;
3482: l_out_line_type NUMBER;
3483: l_cust_trx_type_id NUMBER;