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_TRX_HEADERS_PKG dependencies on JAI_CMN_RG_EXC_INV_NOS

Line 2009: FROM JAI_CMN_RG_EXC_INV_NOS

2005: p_fin_year IN NUMBER,
2006: p_batch_name IN VARCHAR2,
2007: p_register_code IN VARCHAR2) IS
2008: SELECT start_number, end_number, jump_by, prefix
2009: FROM JAI_CMN_RG_EXC_INV_NOS
2010: WHERE organization_id = p_organization_id
2011: AND location_id = p_location_id
2012: AND fin_year = p_fin_year
2013: AND transaction_type IN ('I', 'DOM', 'EXP')

Line 2021: FROM JAI_CMN_RG_EXC_INV_NOS

2017: CURSOR excise_invoice_cur(p_org_id IN NUMBER,
2018: p_loc_id IN NUMBER,
2019: p_fin_year IN NUMBER) IS
2020: SELECT NVL(MAX(GP1), 0), NVL(MAX(GP2), 0)
2021: FROM JAI_CMN_RG_EXC_INV_NOS
2022: WHERE organization_id = p_org_id
2023: AND location_id = p_loc_id
2024: AND fin_year = p_fin_year
2025: AND transaction_type IS NULL