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_RGM_ORG_REGNS_V

Line 2851: FROM jai_rgm_org_regns_v

2847: AND trunc(creation_date) < cp_start_date
2848: AND organization_id in
2849: (
2850: SELECT DISTINCT organization_id
2851: FROM jai_rgm_org_regns_v
2852: WHERE regime_code = 'SERVICE'
2853: AND registration_type = 'OTHERS'
2854: AND attribute_type_code = 'PRIMARY'
2855: AND attribute_code = 'SERVICE_TAX_REGISTRATION_NO'

Line 2891: FROM jai_rgm_org_regns_v

2887: AND trunc(creation_date) < cp_start_date
2888: AND organization_id IN
2889: (
2890: SELECT DISTINCT organization_id
2891: FROM jai_rgm_org_regns_v
2892: WHERE regime_code = 'SERVICE'
2893: AND registration_type = 'OTHERS'
2894: AND attribute_type_code = 'PRIMARY'
2895: AND attribute_code = 'SERVICE_TAX_REGISTRATION_NO'

Line 2948: FROM jai_rgm_org_regns_v

2944: AND to_char(jrtf1.creation_date, 'YYYY') || to_char(jrtf1.creation_date, 'MM') = ln_yyyymm
2945: AND jrtf1.organization_id IN
2946: (
2947: SELECT DISTINCT organization_id
2948: FROM jai_rgm_org_regns_v
2949: WHERE regime_code = 'SERVICE'
2950: AND registration_type = 'OTHERS'
2951: AND attribute_type_code = 'PRIMARY'
2952: AND attribute_code = 'SERVICE_TAX_REGISTRATION_NO'

Line 2993: FROM jai_rgm_org_regns_v

2989: AND tax_type = 'Service'
2990: AND organization_id IN
2991: (
2992: SELECT DISTINCT organization_id
2993: FROM jai_rgm_org_regns_v
2994: WHERE regime_code = 'SERVICE'
2995: AND registration_type = 'OTHERS'
2996: AND attribute_type_code = 'PRIMARY'
2997: AND attribute_code = 'SERVICE_TAX_REGISTRATION_NO'

Line 3055: FROM jai_rgm_org_regns_v

3051: AND trunc(creation_date) < cp_start_date
3052: AND organization_id in
3053: (
3054: SELECT DISTINCT organization_id
3055: FROM jai_rgm_org_regns_v
3056: WHERE regime_code = 'SERVICE'
3057: AND registration_type = 'OTHERS'
3058: AND attribute_type_code = 'PRIMARY'
3059: AND attribute_code = 'SERVICE_TAX_REGISTRATION_NO'

Line 3094: FROM jai_rgm_org_regns_v

3090: AND trunc(creation_date) < cp_start_date
3091: AND organization_id IN
3092: (
3093: SELECT DISTINCT organization_id
3094: FROM jai_rgm_org_regns_v
3095: WHERE regime_code = 'SERVICE'
3096: AND registration_type = 'OTHERS'
3097: AND attribute_type_code = 'PRIMARY'
3098: AND attribute_code = 'SERVICE_TAX_REGISTRATION_NO'

Line 3145: FROM jai_rgm_org_regns_v

3141: AND tax_type = 'SERVICE_EDUCATION_CESS'
3142: AND organization_id IN
3143: (
3144: SELECT DISTINCT organization_id
3145: FROM jai_rgm_org_regns_v
3146: WHERE regime_code = 'SERVICE'
3147: AND registration_type = 'OTHERS'
3148: AND attribute_type_code = 'PRIMARY'
3149: AND attribute_code = 'SERVICE_TAX_REGISTRATION_NO'