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.

[Home] [Help]

APPS.JAI_GENERAL_PKG dependencies on JAI_CMN_RG_I_TRXS

Line 395: SELECT register_id FROM JAI_CMN_RG_I_TRXS

391: AND fin_year = cp_fin_year);
392:
393: -- RG1
394: CURSOR c_rg1(cp_fin_year IN NUMBER) IS
395: SELECT register_id FROM JAI_CMN_RG_I_TRXS
396: WHERE organization_id = p_organization_id
397: AND location_id = p_location_id
398: AND inventory_item_id = p_inventory_item_id
399: AND fin_year = cp_fin_year

Line 400: AND slno = (select max(slno) from JAI_CMN_RG_I_TRXS

396: WHERE organization_id = p_organization_id
397: AND location_id = p_location_id
398: AND inventory_item_id = p_inventory_item_id
399: AND fin_year = cp_fin_year
400: AND slno = (select max(slno) from JAI_CMN_RG_I_TRXS
401: WHERE organization_id = p_organization_id
402: AND location_id = p_location_id
403: AND inventory_item_id = p_inventory_item_id
404: AND fin_year = cp_fin_year);