[Home] [Help]
134: FROM JAI_OM_OE_BOND_REG_DTLS
135: WHERE order_type_id = p_batch_source_id AND order_flag = 'N');
136:
137: /* Bug 4938350. Added by Lakshmi Gopalsami
138: Removed the sub-query and added oe_transaction_types_tl
139: Removed parameter p_order_number
140: */
141: CURSOR register_code_cur1(p_organization_id NUMBER,
142: p_location_id NUMBER,
143: p_order_type varchar2) IS
144: SELECT A.register_code
145: FROM JAI_OM_OE_BOND_REG_HDRS A,
146: JAI_OM_OE_BOND_REG_DTLS b,
147: oe_transaction_types_tl ott
148: WHERE A.organization_id = p_organization_id
149: AND A.location_id = p_location_id
150: AND A.register_id = b.register_id
151: AND b.order_flag = 'Y'
255:
256: If the flag value of ORDER_PRICE_EXCISE_INCLUSIVE becomes 'Y' then the excise tax will go as zero
257: else , the normal excise value will go to the base apps.
258:
259: Also , a join between oe_order_headers_all and oe_transaction_types_tl has been added.
260: Without this join, if the same sales order number is associated to multiple order types,
261: there is scope for the wrong order number to be chosen and comparison done on that basis.
262:
263: With this join condition, the value in the ra_customer_trx_all.interface_header_attribute2 is
260: Without this join, if the same sales order number is associated to multiple order types,
261: there is scope for the wrong order number to be chosen and comparison done on that basis.
262:
263: With this join condition, the value in the ra_customer_trx_all.interface_header_attribute2 is
264: compared to the 'Name' field in the oe_transaction_types_tl.
265:
266: 11. 2005/27/01 aiyer - Bug # 4089440 File Version 115.1
267: Issue:-
268: In case of service invoices having service/service_education type of taxes the code combination id should be picked