APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 2920: Removed the reference to so_headers_all and added oe_transaction_types_tl

2916: WHERE order_type_id = p_batch_source_id AND order_flag = 'N');
2917:
2918: /* Bug5207772. Added by Lakshmi Gopalsami
2919: Fixed performance issue - SQL id - 17698796
2920: Removed the reference to so_headers_all and added oe_transaction_types_tl
2921: Changed the parameter to p_order_type instead of p_order_number
2922: */
2923: CURSOR register_code_cur1(p_organization_id NUMBER,
2924: p_location_id NUMBER,

Line 2929: oe_transaction_types_tl ott

2925: p_order_type VARCHAR2) IS
2926: SELECT A.register_code
2927: FROM JAI_OM_OE_BOND_REG_HDRS A,
2928: JAI_OM_OE_BOND_REG_DTLS b,
2929: oe_transaction_types_tl ott
2930: WHERE A.organization_id = p_organization_id
2931: AND A.location_id = p_location_id
2932: AND A.register_id = b.register_id
2933: AND b.order_flag = 'Y'

Line 4016: OE_TRANSACTION_TYPES_TL ot,

4012: IS
4013: SELECT count(1)
4014: FROM OE_ORDER_HEADERS_ALL oh,
4015: OE_ORDER_LINES_ALL ol,
4016: OE_TRANSACTION_TYPES_TL ot,
4017: oe_workflow_assignments owf
4018: WHERE oh.header_id = ol.header_id
4019: AND oh.order_type_id = ot.transaction_type_id
4020: AND oh.order_type_id = owf.order_type_id

Line 4136: oe_transaction_types_tl ot,

4132: CURSOR get_copy_vat_invoice_cur
4133: IS
4134: SELECT jwl.vat_invoice_no
4135: FROM OE_ORDER_HEADERS_ALL ohc,
4136: oe_transaction_types_tl ot,
4137: JAI_OM_WSH_LINES_ALL jwl
4138: WHERE ohc.order_type_id = ot.transaction_type_id
4139: AND ot.LANGUAGE = userenv('LANG')
4140: AND ohc.source_document_id = jwl.ORDER_HEADER_ID