APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 273: Removed the sub-query and added oe_transaction_types_tl

269: FROM JAI_OM_OE_BOND_REG_DTLS
270: WHERE order_type_id = p_batch_source_id AND order_flag = 'N');
271:
272: /* Bug 4938350. Added by Lakshmi Gopalsami
273: Removed the sub-query and added oe_transaction_types_tl
274: Removed parameter p_order_number
275: */
276: CURSOR register_code_cur1(p_organization_id NUMBER,
277: p_location_id NUMBER,

Line 282: oe_transaction_types_tl ott

278: p_order_type varchar2) IS
279: SELECT A.register_code
280: FROM JAI_OM_OE_BOND_REG_HDRS A,
281: JAI_OM_OE_BOND_REG_DTLS b,
282: oe_transaction_types_tl ott
283: WHERE A.organization_id = p_organization_id
284: AND A.location_id = p_location_id
285: AND A.register_id = b.register_id
286: AND b.order_flag = 'Y'

Line 349: OE_TRANSACTION_TYPES_TL ot,

345: IS
346: SELECT count(1)
347: FROM OE_ORDER_HEADERS_ALL oh,
348: OE_ORDER_LINES_ALL ol,
349: OE_TRANSACTION_TYPES_TL ot,
350: oe_workflow_assignments owf
351: WHERE oh.header_id = ol.header_id
352: AND oh.order_type_id = ot.transaction_type_id
353: AND oh.order_type_id = owf.order_type_id

Line 456: Also , a join between oe_order_headers_all and oe_transaction_types_tl has been added.

452:
453: If the flag value of ORDER_PRICE_EXCISE_INCLUSIVE becomes 'Y' then the excise tax will go as zero
454: else , the normal excise value will go to the base apps.
455:
456: Also , a join between oe_order_headers_all and oe_transaction_types_tl has been added.
457: Without this join, if the same sales order number is associated to multiple order types,
458: there is scope for the wrong order number to be chosen and comparison done on that basis.
459:
460: With this join condition, the value in the ra_customer_trx_all.interface_header_attribute2 is

Line 461: compared to the 'Name' field in the oe_transaction_types_tl.

457: Without this join, if the same sales order number is associated to multiple order types,
458: there is scope for the wrong order number to be chosen and comparison done on that basis.
459:
460: With this join condition, the value in the ra_customer_trx_all.interface_header_attribute2 is
461: compared to the 'Name' field in the oe_transaction_types_tl.
462:
463: 11. 2005/27/01 aiyer - Bug # 4089440 File Version 115.1
464: Issue:-
465: In case of service invoices having service/service_education type of taxes the code combination id should be picked