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_EER1_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 38: SELECT substr(ec_code,1,15) FROM JAI_CMN_INVENTORY_ORGS

34: p_end_date DATE ;
35:
36: CURSOR cur_ecc(p_organization_id IN NUMBER, p_location_id IN NUMBER)
37: IS
38: SELECT substr(ec_code,1,15) FROM JAI_CMN_INVENTORY_ORGS
39: WHERE organization_id = p_organization_id
40: AND location_id = p_location_id;
41:
42: BEGIN

Line 2601: FROM JAI_CMN_RG_23AC_II_TRXS JIRP,JAI_CMN_INVENTORY_ORGS JIHO

2597:
2598: CURSOR Cur_crdit_input_manf_iso
2599: IS
2600: SELECT SUM(DECODE(register_type, 'A', nvl(cr_basic_ed,0) + nvl(cr_additional_ed,0) + nvl(cr_other_ed,0),0)) credit_availed_on_inputs
2601: FROM JAI_CMN_RG_23AC_II_TRXS JIRP,JAI_CMN_INVENTORY_ORGS JIHO
2602: WHERE JIRP.location_id = p_location_id
2603: AND JIRP.organization_id = p_organization_id
2604: AND ABS(jirp.vendor_id) = jiho.organization_id
2605: AND ABS(jirp.vendor_site_id) = jiho.location_id

Line 2629: FROM JAI_CMN_RG_23AC_II_TRXS JIRP,JAI_CMN_INVENTORY_ORGS JIHO

2625:
2626: CURSOR Cur_crdit_input_stg_iso
2627: IS
2628: SELECT SUM(DECODE(register_type, 'A', nvl(cr_basic_ed,0) + nvl(cr_additional_ed,0) + nvl(cr_other_ed,0),0)) credit_availed_on_inputs
2629: FROM JAI_CMN_RG_23AC_II_TRXS JIRP,JAI_CMN_INVENTORY_ORGS JIHO
2630: WHERE JIRP.location_id = p_location_id
2631: AND JIRP.organization_id = p_organization_id
2632: AND ABS(JIRP.vendor_id) = JIHO.organization_id
2633: AND ABS(JIRP.vendor_site_id) = JIHO.location_id

Line 2723: SELECT NVL(SUM(credit),0) FROM JAI_CMN_RG_OTHERS JRO,JAI_CMN_RG_23AC_II_TRXS RG23,JAI_CMN_INVENTORY_ORGS JIHO

2719: and to_char(rg23.creation_date, 'YYYY') || to_char(rg23.creation_date, 'MM') = ln_yyyymm ;
2720:
2721: CURSOR Cur_cess_excise_input_manf_iso
2722: IS
2723: SELECT NVL(SUM(credit),0) FROM JAI_CMN_RG_OTHERS JRO,JAI_CMN_RG_23AC_II_TRXS RG23,JAI_CMN_INVENTORY_ORGS JIHO
2724: WHERE jro.source_register_id = RG23.register_id
2725: and abs(rg23.vendor_id) = jiho.organization_id
2726: and abs(rg23.vendor_site_id)= jiho.location_id
2727: and jiho.manufacturing = 'Y'

Line 2757: SELECT NVL(SUM(credit),0) FROM JAI_CMN_RG_OTHERS JRO,JAI_CMN_RG_23AC_II_TRXS RG23,JAI_CMN_INVENTORY_ORGS JIHO

2753: and to_char(rg23.creation_date, 'YYYY') || to_char(rg23.creation_date, 'MM') = ln_yyyymm ;
2754:
2755: CURSOR Cur_cess_excise_input_stg_iso
2756: IS
2757: SELECT NVL(SUM(credit),0) FROM JAI_CMN_RG_OTHERS JRO,JAI_CMN_RG_23AC_II_TRXS RG23,JAI_CMN_INVENTORY_ORGS JIHO
2758: WHERE jro.source_register_id = RG23.register_id
2759: AND ABS(RG23.vendor_id) = JIHO.organization_id
2760: AND ABS(RG23.vendor_site_id)= JIHO.location_id
2761: AND JIHO.trading = 'Y'