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_GENERAL_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS

Line 380: SELECT register_id FROM JAI_CMN_RG_23AC_I_TRXS

376: ) RETURN NUMBER IS
377:
378: -- RG23 Part I
379: CURSOR c_rg23_part1(cp_register_type IN VARCHAR2, cp_fin_year IN NUMBER) IS
380: SELECT register_id FROM JAI_CMN_RG_23AC_I_TRXS
381: WHERE organization_id = p_organization_id
382: AND location_id = p_location_id
383: AND register_type = cp_register_type
384: AND inventory_item_id = p_inventory_item_id

Line 386: AND slno = (select max(slno) from JAI_CMN_RG_23AC_I_TRXS

382: AND location_id = p_location_id
383: AND register_type = cp_register_type
384: AND inventory_item_id = p_inventory_item_id
385: AND fin_year = cp_fin_year
386: AND slno = (select max(slno) from JAI_CMN_RG_23AC_I_TRXS
387: WHERE organization_id = p_organization_id
388: AND location_id = p_location_id
389: AND register_type = cp_register_type
390: AND inventory_item_id = p_inventory_item_id