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.JA_JAINER1_XMLP_PKG dependencies on JAI_CMN_RG_OTHERS

Line 142: JAI_CMN_RG_OTHERS

138: SELECT
139: SUM(NVL(CREDIT
140: ,0))
141: FROM
142: JAI_CMN_RG_OTHERS
143: WHERE SOURCE_TYPE = 2
144: AND TAX_TYPE in ( TAX_TYPE_EXC_EDU_CESS , TAX_TYPE_CVD_EDU_CESS )
145: AND SOURCE_REGISTER_ID in (
146: SELECT

Line 217: JAI_CMN_RG_OTHERS

213: SELECT
214: SUM(NVL(DEBIT
215: ,0))
216: FROM
217: JAI_CMN_RG_OTHERS
218: WHERE TAX_TYPE in ( TAX_TYPE_EXC_EDU_CESS , TAX_TYPE_CVD_EDU_CESS )
219: AND SOURCE_TYPE = 1
220: AND SOURCE_REGISTER_ID in (
221: SELECT

Line 316: JAI_CMN_RG_OTHERS JRO,

312: SELECT
313: NVL(SUM(CREDIT)
314: ,0)
315: FROM
316: JAI_CMN_RG_OTHERS JRO,
317: JAI_CMN_RG_23AC_II_TRXS RG23
318: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
319: AND RG23.LOCATION_ID = P_LOCATION_ID
320: AND RG23.ORGANIZATION_ID = P_ORGANIZATION_ID

Line 348: JAI_CMN_RG_OTHERS JRO,

344: SELECT
345: NVL(SUM(CREDIT)
346: ,0)
347: FROM
348: JAI_CMN_RG_OTHERS JRO,
349: JAI_CMN_RG_23AC_II_TRXS RG23
350: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
351: AND RG23.LOCATION_ID = P_LOCATION_ID
352: AND RG23.ORGANIZATION_ID = P_ORGANIZATION_ID

Line 810: JAI_CMN_RG_OTHERS

806: SUM(NVL(CREDIT
807: ,0) - NVL(DEBIT
808: ,0))
809: FROM
810: JAI_CMN_RG_OTHERS
811: WHERE SOURCE_TYPE = 1
812: AND SOURCE_REGISTER_ID in (
813: SELECT
814: REGISTER_ID

Line 1522: JAI_CMN_RG_OTHERS

1518: SELECT
1519: NVL(SUM(DEBIT)
1520: ,0)
1521: FROM
1522: JAI_CMN_RG_OTHERS
1523: WHERE SOURCE_REGISTER_ID IN (
1524: SELECT
1525: REGISTER_ID_PART_II
1526: FROM

Line 1553: JAI_CMN_RG_OTHERS

1549: SELECT
1550: NVL(SUM(DEBIT)
1551: ,0)
1552: FROM
1553: JAI_CMN_RG_OTHERS
1554: WHERE SOURCE_REGISTER_ID IN (
1555: SELECT
1556: REGISTER_ID_PART_II
1557: FROM

Line 1584: JAI_CMN_RG_OTHERS

1580: SELECT
1581: NVL(SUM(DEBIT)
1582: ,0)
1583: FROM
1584: JAI_CMN_RG_OTHERS
1585: WHERE SOURCE_REGISTER_ID IN (
1586: SELECT
1587: REGISTER_ID_PART_II
1588: FROM

Line 1611: JAI_CMN_RG_OTHERS

1607: SELECT
1608: NVL(SUM(DEBIT)
1609: ,0)
1610: FROM
1611: JAI_CMN_RG_OTHERS
1612: WHERE SOURCE_REGISTER_ID IN (
1613: SELECT
1614: REGISTER_ID_PART_II
1615: FROM

Line 1688: JAI_CMN_RG_OTHERS JRO,

1684: NVL(SUM(DEBIT)
1685: ,0)
1686: INTO LN_EDU_CESS_EXCISE
1687: FROM
1688: JAI_CMN_RG_OTHERS JRO,
1689: JAI_CMN_RG_23AC_II_TRXS RG23
1690: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
1691: AND RG23.LOCATION_ID = P_LOCATION_ID
1692: AND RG23.ORGANIZATION_ID = P_ORGANIZATION_ID

Line 2024: JAI_CMN_RG_OTHERS JRO,

2020: SELECT
2021: NVL(SUM(CREDIT)
2022: ,0)
2023: FROM
2024: JAI_CMN_RG_OTHERS JRO,
2025: JAI_CMN_RG_23AC_II_TRXS RG23,
2026: JAI_CMN_VENDOR_SITES JIPV
2027: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2028: AND RG23.VENDOR_ID = JIPV.VENDOR_ID

Line 2045: JAI_CMN_RG_OTHERS JRO,

2041: SELECT
2042: NVL(SUM(CREDIT)
2043: ,0)
2044: FROM
2045: JAI_CMN_RG_OTHERS JRO,
2046: JAI_CMN_RG_23AC_II_TRXS RG23,
2047: JAI_CMN_CUS_ADDRESSES JICA,
2048: HZ_CUST_ACCT_SITES_ALL HZCAS,
2049: HZ_CUST_SITE_USES_ALL HZCSU

Line 2068: JAI_CMN_RG_OTHERS JRO,

2064: SELECT
2065: NVL(SUM(CREDIT)
2066: ,0)
2067: FROM
2068: JAI_CMN_RG_OTHERS JRO,
2069: JAI_CMN_RG_23AC_II_TRXS RG23,
2070: JAI_CMN_INVENTORY_ORGS JIHO
2071: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2072: AND ABS(RG23.VENDOR_ID) = JIHO.ORGANIZATION_ID

Line 2121: JAI_CMN_RG_OTHERS JRO,

2117: SELECT
2118: NVL(SUM(CREDIT)
2119: ,0)
2120: FROM
2121: JAI_CMN_RG_OTHERS JRO,
2122: JAI_CMN_RG_23AC_II_TRXS RG23,
2123: JAI_CMN_VENDOR_SITES JIPV
2124: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2125: AND RG23.VENDOR_ID = JIPV.vendor_id (+)

Line 2141: JAI_CMN_RG_OTHERS JRO,

2137: SELECT
2138: NVL(SUM(CREDIT)
2139: ,0)
2140: FROM
2141: JAI_CMN_RG_OTHERS JRO,
2142: JAI_CMN_RG_23AC_II_TRXS RG23,
2143: JAI_CMN_INVENTORY_ORGS JIHO
2144: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2145: AND ABS(RG23.VENDOR_ID) = JIHO.ORGANIZATION_ID

Line 2361: JAI_CMN_RG_OTHERS

2357: SELECT
2358: SUM(NVL(DEBIT
2359: ,0))
2360: FROM
2361: JAI_CMN_RG_OTHERS
2362: WHERE SOURCE_TYPE = 1
2363: AND TAX_TYPE in ( TAX_TYPE_CVD_EDU_CESS , TAX_TYPE_EXC_EDU_CESS )
2364: AND SOURCE_REGISTER_ID in (
2365: SELECT

Line 2384: JAI_CMN_RG_OTHERS

2380: SELECT
2381: SUM(NVL(DEBIT
2382: ,0))
2383: FROM
2384: JAI_CMN_RG_OTHERS
2385: WHERE SOURCE_TYPE = 1
2386: AND TAX_TYPE in ( TAX_TYPE_CVD_EDU_CESS , TAX_TYPE_EXC_EDU_CESS )
2387: AND SOURCE_REGISTER_ID in (
2388: SELECT

Line 2625: JAI_CMN_RG_OTHERS

2621: SUM(NVL(CREDIT
2622: ,0) - NVL(DEBIT
2623: ,0))
2624: FROM
2625: JAI_CMN_RG_OTHERS
2626: WHERE SOURCE_TYPE = 1
2627: AND SOURCE_REGISTER_ID in (
2628: SELECT
2629: REGISTER_ID

Line 2652: JAI_CMN_RG_OTHERS JRO,

2648: SELECT
2649: NVL(SUM(CREDIT)
2650: ,0)
2651: FROM
2652: JAI_CMN_RG_OTHERS JRO,
2653: JAI_CMN_RG_23AC_II_TRXS RG23,
2654: JAI_CMN_VENDOR_SITES JIPV
2655: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2656: AND RG23.VENDOR_ID = JIPV.VENDOR_ID

Line 2673: JAI_CMN_RG_OTHERS JRO,

2669: SELECT
2670: NVL(SUM(CREDIT)
2671: ,0)
2672: FROM
2673: JAI_CMN_RG_OTHERS JRO,
2674: JAI_CMN_RG_23AC_II_TRXS RG23,
2675: JAI_CMN_CUS_ADDRESSES JICA,
2676: HZ_CUST_ACCT_SITES_ALL HZCAS,
2677: HZ_CUST_SITE_USES_ALL HZCSU

Line 2696: JAI_CMN_RG_OTHERS JRO,

2692: SELECT
2693: NVL(SUM(CREDIT)
2694: ,0)
2695: FROM
2696: JAI_CMN_RG_OTHERS JRO,
2697: JAI_CMN_RG_23AC_II_TRXS RG23,
2698: JAI_CMN_INVENTORY_ORGS JIHO
2699: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2700: AND ABS(RG23.VENDOR_ID) = JIHO.ORGANIZATION_ID

Line 2749: JAI_CMN_RG_OTHERS JRO,

2745: SELECT
2746: NVL(SUM(CREDIT)
2747: ,0)
2748: FROM
2749: JAI_CMN_RG_OTHERS JRO,
2750: JAI_CMN_RG_23AC_II_TRXS RG23,
2751: JAI_CMN_VENDOR_SITES JIPV
2752: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2753: AND RG23.VENDOR_ID = JIPV.vendor_id (+)

Line 2769: JAI_CMN_RG_OTHERS JRO,

2765: SELECT
2766: NVL(SUM(CREDIT)
2767: ,0)
2768: FROM
2769: JAI_CMN_RG_OTHERS JRO,
2770: JAI_CMN_RG_23AC_II_TRXS RG23,
2771: JAI_CMN_INVENTORY_ORGS JIHO
2772: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2773: AND ABS(RG23.VENDOR_ID) = JIHO.ORGANIZATION_ID

Line 2817: JAI_CMN_RG_OTHERS JRO,

2813: SELECT
2814: NVL(SUM(CREDIT)
2815: ,0)
2816: FROM
2817: JAI_CMN_RG_OTHERS JRO,
2818: JAI_CMN_RG_23AC_II_TRXS RG23
2819: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2820: AND RG23.LOCATION_ID = P_LOCATION_ID
2821: AND RG23.ORGANIZATION_ID = P_ORGANIZATION_ID

Line 2858: JAI_CMN_RG_OTHERS JRO,

2854: SELECT
2855: NVL(SUM(CREDIT)
2856: ,0)
2857: FROM
2858: JAI_CMN_RG_OTHERS JRO,
2859: JAI_CMN_RG_23AC_II_TRXS RG23
2860: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2861: AND RG23.LOCATION_ID = P_LOCATION_ID
2862: AND RG23.ORGANIZATION_ID = P_ORGANIZATION_ID

Line 2890: JAI_CMN_RG_OTHERS JRO,

2886: SELECT
2887: NVL(SUM(DEBIT)
2888: ,0)
2889: FROM
2890: JAI_CMN_RG_OTHERS JRO,
2891: JAI_CMN_RG_23AC_II_TRXS RG23
2892: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2893: AND RG23.LOCATION_ID = P_LOCATION_ID
2894: AND RG23.ORGANIZATION_ID = P_ORGANIZATION_ID

Line 3092: JAI_CMN_RG_OTHERS

3088: SELECT
3089: SUM(NVL(DEBIT
3090: ,0))
3091: FROM
3092: JAI_CMN_RG_OTHERS
3093: WHERE SOURCE_TYPE = 1
3094: AND TAX_TYPE in ( TAX_TYPE_SH_CVD_EDU_CESS , TAX_TYPE_SH_EXC_EDU_CESS )
3095: AND SOURCE_REGISTER_ID in (
3096: SELECT

Line 3115: JAI_CMN_RG_OTHERS

3111: SELECT
3112: SUM(NVL(DEBIT
3113: ,0))
3114: FROM
3115: JAI_CMN_RG_OTHERS
3116: WHERE SOURCE_TYPE = 1
3117: AND TAX_TYPE in ( TAX_TYPE_SH_CVD_EDU_CESS , TAX_TYPE_SH_EXC_EDU_CESS )
3118: AND SOURCE_REGISTER_ID in (
3119: SELECT

Line 3311: JAI_CMN_RG_OTHERS

3307: SELECT
3308: SUM(NVL(DEBIT
3309: ,0))
3310: FROM
3311: JAI_CMN_RG_OTHERS
3312: WHERE TAX_TYPE in ( TAX_TYPE_SH_EXC_EDU_CESS , TAX_TYPE_SH_CVD_EDU_CESS )
3313: AND SOURCE_TYPE = 1
3314: AND SOURCE_REGISTER_ID in (
3315: SELECT

Line 3344: JAI_CMN_RG_OTHERS

3340: SELECT
3341: SUM(NVL(CREDIT
3342: ,0))
3343: FROM
3344: JAI_CMN_RG_OTHERS
3345: WHERE SOURCE_TYPE = 2
3346: AND TAX_TYPE in ( TAX_TYPE_SH_EXC_EDU_CESS , TAX_TYPE_SH_CVD_EDU_CESS )
3347: AND SOURCE_REGISTER_ID in (
3348: SELECT

Line 3395: JAI_CMN_RG_OTHERS

3391: SELECT
3392: NVL(SUM(DEBIT)
3393: ,0)
3394: FROM
3395: JAI_CMN_RG_OTHERS
3396: WHERE SOURCE_REGISTER_ID IN (
3397: SELECT
3398: REGISTER_ID_PART_II
3399: FROM

Line 3426: JAI_CMN_RG_OTHERS

3422: SELECT
3423: NVL(SUM(DEBIT)
3424: ,0)
3425: FROM
3426: JAI_CMN_RG_OTHERS
3427: WHERE SOURCE_REGISTER_ID IN (
3428: SELECT
3429: REGISTER_ID_PART_II
3430: FROM

Line 3457: JAI_CMN_RG_OTHERS

3453: SELECT
3454: NVL(SUM(DEBIT)
3455: ,0)
3456: FROM
3457: JAI_CMN_RG_OTHERS
3458: WHERE SOURCE_REGISTER_ID IN (
3459: SELECT
3460: REGISTER_ID_PART_II
3461: FROM

Line 3484: JAI_CMN_RG_OTHERS

3480: SELECT
3481: NVL(SUM(DEBIT)
3482: ,0)
3483: FROM
3484: JAI_CMN_RG_OTHERS
3485: WHERE SOURCE_REGISTER_ID IN (
3486: SELECT
3487: REGISTER_ID_PART_II
3488: FROM