eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 2490: Removed the reference to so_headers_all and added oe_transaction_types_tl

2486: WHERE order_type_id = p_batch_source_id AND order_flag = 'N');
2487:
2488: /* Bug5207772. Added by Lakshmi Gopalsami
2489: Fixed performance issue - SQL id - 17698796
2490: Removed the reference to so_headers_all and added oe_transaction_types_tl
2491: Changed the parameter to p_order_type instead of p_order_number
2492: */
2493: CURSOR register_code_cur1(p_organization_id NUMBER,
2494: p_location_id NUMBER,

Line 2499: oe_transaction_types_tl ott

2495: p_order_type VARCHAR2) IS
2496: SELECT A.register_code
2497: FROM JAI_OM_OE_BOND_REG_HDRS A,
2498: JAI_OM_OE_BOND_REG_DTLS b,
2499: oe_transaction_types_tl ott
2500: WHERE A.organization_id = p_organization_id
2501: AND A.location_id = p_location_id
2502: AND A.register_id = b.register_id
2503: AND b.order_flag = 'Y'