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_RGM_TRX_RECORDS

Line 412: JAI_RGM_TRX_RECORDS JRTR1,

408: SELECT
409: JRTR1.CREDIT_AMOUNT SERVICE_CREDIT,
410: JRTR2.CREDIT_AMOUNT EDU_CESS_CREDIT
411: FROM
412: JAI_RGM_TRX_RECORDS JRTR1,
413: JAI_RGM_TRX_RECORDS JRTR2
414: WHERE JRTR1.SOURCE = 'SERVICE_DISTRIBUTE_IN'
415: AND JRTR1.REGIME_CODE = 'SERVICE'
416: AND JRTR1.TAX_TYPE = 'Service'

Line 413: JAI_RGM_TRX_RECORDS JRTR2

409: JRTR1.CREDIT_AMOUNT SERVICE_CREDIT,
410: JRTR2.CREDIT_AMOUNT EDU_CESS_CREDIT
411: FROM
412: JAI_RGM_TRX_RECORDS JRTR1,
413: JAI_RGM_TRX_RECORDS JRTR2
414: WHERE JRTR1.SOURCE = 'SERVICE_DISTRIBUTE_IN'
415: AND JRTR1.REGIME_CODE = 'SERVICE'
416: AND JRTR1.TAX_TYPE = 'Service'
417: AND jrtr2.tax_type (+) = TAX_TYPE_SERVICE_EDU_CESS

Line 431: JAI_RGM_TRX_RECORDS JRTR1,

427: SELECT
428: JRTR1.CREDIT_AMOUNT SERVICE_CREDIT,
429: JRTR2.CREDIT_AMOUNT EDU_CESS_CREDIT
430: FROM
431: JAI_RGM_TRX_RECORDS JRTR1,
432: JAI_RGM_TRX_RECORDS JRTR2
433: WHERE JRTR1.SOURCE = 'MANUAL'
434: AND JRTR1.REGIME_CODE = 'SERVICE'
435: AND JRTR1.TAX_TYPE = 'Service'

Line 432: JAI_RGM_TRX_RECORDS JRTR2

428: JRTR1.CREDIT_AMOUNT SERVICE_CREDIT,
429: JRTR2.CREDIT_AMOUNT EDU_CESS_CREDIT
430: FROM
431: JAI_RGM_TRX_RECORDS JRTR1,
432: JAI_RGM_TRX_RECORDS JRTR2
433: WHERE JRTR1.SOURCE = 'MANUAL'
434: AND JRTR1.REGIME_CODE = 'SERVICE'
435: AND JRTR1.TAX_TYPE = 'Service'
436: AND jrtr2.tax_type (+) = TAX_TYPE_SERVICE_EDU_CESS

Line 485: JAI_RGM_TRX_RECORDS JRTR1,

481: SELECT
482: JRTR1.CREDIT_AMOUNT SERVICE_CREDIT,
483: JRTR2.CREDIT_AMOUNT EDU_CESS_CREDIT
484: FROM
485: JAI_RGM_TRX_RECORDS JRTR1,
486: JAI_RGM_TRX_RECORDS JRTR2
487: WHERE JRTR1.SOURCE = 'SERVICE_DISTRIBUTE_IN'
488: AND JRTR1.REGIME_CODE = 'SERVICE'
489: AND JRTR1.TAX_TYPE = 'Service'

Line 486: JAI_RGM_TRX_RECORDS JRTR2

482: JRTR1.CREDIT_AMOUNT SERVICE_CREDIT,
483: JRTR2.CREDIT_AMOUNT EDU_CESS_CREDIT
484: FROM
485: JAI_RGM_TRX_RECORDS JRTR1,
486: JAI_RGM_TRX_RECORDS JRTR2
487: WHERE JRTR1.SOURCE = 'SERVICE_DISTRIBUTE_IN'
488: AND JRTR1.REGIME_CODE = 'SERVICE'
489: AND JRTR1.TAX_TYPE = 'Service'
490: AND jrtr2.tax_type (+) = TAX_TYPE_SH_SERVICE_EDU_CESS

Line 504: JAI_RGM_TRX_RECORDS JRTR1,

500: SELECT
501: JRTR1.CREDIT_AMOUNT SERVICE_CREDIT,
502: JRTR2.CREDIT_AMOUNT EDU_CESS_CREDIT
503: FROM
504: JAI_RGM_TRX_RECORDS JRTR1,
505: JAI_RGM_TRX_RECORDS JRTR2
506: WHERE JRTR1.SOURCE = 'MANUAL'
507: AND JRTR1.REGIME_CODE = 'SERVICE'
508: AND JRTR1.TAX_TYPE = 'Service'

Line 505: JAI_RGM_TRX_RECORDS JRTR2

501: JRTR1.CREDIT_AMOUNT SERVICE_CREDIT,
502: JRTR2.CREDIT_AMOUNT EDU_CESS_CREDIT
503: FROM
504: JAI_RGM_TRX_RECORDS JRTR1,
505: JAI_RGM_TRX_RECORDS JRTR2
506: WHERE JRTR1.SOURCE = 'MANUAL'
507: AND JRTR1.REGIME_CODE = 'SERVICE'
508: AND JRTR1.TAX_TYPE = 'Service'
509: AND jrtr2.tax_type (+) = TAX_TYPE_SH_SERVICE_EDU_CESS

Line 570: JAI_RGM_TRX_RECORDS

566: SELECT
567: NVL(SUM(DEBIT_AMOUNT)
568: ,0)
569: FROM
570: JAI_RGM_TRX_RECORDS
571: WHERE SOURCE = 'SERVICE_DISTRIBUTE_OUT'
572: AND REGIME_CODE = 'SERVICE'
573: AND TAX_TYPE = 'Service'
574: AND REGIME_PRIMARY_REGNO = P_REGISTRATION_NUMBER

Line 587: JAI_RGM_TRX_RECORDS

583: SELECT
584: NVL(SUM(DEBIT_AMOUNT)
585: ,0)
586: FROM
587: JAI_RGM_TRX_RECORDS
588: WHERE SOURCE = 'MANUAL'
589: AND REGIME_CODE = 'SERVICE'
590: AND TAX_TYPE = 'Service'
591: AND SOURCE_TRX_TYPE IN ( 'ADJUSTMENT-LIABILITY' , 'LIABILITY' )

Line 605: JAI_RGM_TRX_RECORDS

601: SELECT
602: NVL(SUM(DEBIT_AMOUNT)
603: ,0)
604: FROM
605: JAI_RGM_TRX_RECORDS
606: WHERE SOURCE = 'MANUAL'
607: AND REGIME_CODE = 'SERVICE'
608: AND TAX_TYPE = 'Service'
609: AND SOURCE_TRX_TYPE = 'PAYMENT'

Line 678: JAI_RGM_TRX_RECORDS

674: SELECT
675: NVL(SUM(DEBIT_AMOUNT)
676: ,0)
677: FROM
678: JAI_RGM_TRX_RECORDS
679: WHERE SOURCE = 'SERVICE_DISTRIBUTE_OUT'
680: AND REGIME_CODE = 'SERVICE'
681: AND TAX_TYPE = TAX_TYPE_SERVICE_EDU_CESS
682: AND REGIME_PRIMARY_REGNO = P_REGISTRATION_NUMBER

Line 695: JAI_RGM_TRX_RECORDS

691: SELECT
692: NVL(SUM(DEBIT_AMOUNT)
693: ,0)
694: FROM
695: JAI_RGM_TRX_RECORDS
696: WHERE SOURCE = 'MANUAL'
697: AND REGIME_CODE = 'SERVICE'
698: AND TAX_TYPE = TAX_TYPE_SERVICE_EDU_CESS
699: AND SOURCE_TRX_TYPE IN ( 'ADJUSTMENT-LIABILITY' , 'LIABILITY' )

Line 713: JAI_RGM_TRX_RECORDS

709: SELECT
710: NVL(SUM(DEBIT_AMOUNT)
711: ,0)
712: FROM
713: JAI_RGM_TRX_RECORDS
714: WHERE SOURCE = 'MANUAL'
715: AND REGIME_CODE = 'SERVICE'
716: AND TAX_TYPE = TAX_TYPE_SERVICE_EDU_CESS
717: AND SOURCE_TRX_TYPE = 'PAYMENT'

Line 924: JAI_RGM_TRX_RECORDS

920: CURSOR CUR_DIST_IN IS
921: SELECT
922: SUM(CREDIT_AMOUNT)
923: FROM
924: JAI_RGM_TRX_RECORDS
925: WHERE SOURCE = 'SERVICE_DISTRIBUTE_IN'
926: AND REGIME_CODE = 'SERVICE'
927: AND TAX_TYPE = 'Service'
928: AND REGIME_PRIMARY_REGNO = P_REGISTRATION_NUMBER

Line 938: JAI_RGM_TRX_RECORDS

934: CURSOR CUR_MANUAL_IN IS
935: SELECT
936: SUM(CREDIT_AMOUNT)
937: FROM
938: JAI_RGM_TRX_RECORDS
939: WHERE SOURCE = 'MANUAL'
940: AND REGIME_CODE = 'SERVICE'
941: AND TAX_TYPE = 'Service'
942: AND SOURCE_TRX_TYPE IN ( 'ADJUSTMENT-RECOVERY' , 'RECOVERY' )

Line 975: JAI_RGM_TRX_RECORDS

971: SELECT
972: NVL(SUM(DEBIT_AMOUNT)
973: ,0)
974: FROM
975: JAI_RGM_TRX_RECORDS
976: WHERE SOURCE = 'SERVICE_DISTRIBUTE_OUT'
977: AND REGIME_CODE = 'SERVICE'
978: AND TAX_TYPE = 'Service'
979: AND REGIME_PRIMARY_REGNO = P_REGISTRATION_NUMBER

Line 990: JAI_RGM_TRX_RECORDS

986: SELECT
987: NVL(SUM(DEBIT_AMOUNT)
988: ,0)
989: FROM
990: JAI_RGM_TRX_RECORDS
991: WHERE SOURCE = 'MANUAL'
992: AND REGIME_CODE = 'SERVICE'
993: AND TAX_TYPE = 'Service'
994: AND SOURCE_TRX_TYPE IN ( 'ADJUSTMENT-LIABILITY' , 'LIABILITY' )

Line 1006: JAI_RGM_TRX_RECORDS

1002: SELECT
1003: NVL(SUM(DEBIT_AMOUNT)
1004: ,0)
1005: FROM
1006: JAI_RGM_TRX_RECORDS
1007: WHERE SOURCE = 'MANUAL'
1008: AND REGIME_CODE = 'SERVICE'
1009: AND TAX_TYPE = ( 'Service' )
1010: AND SOURCE_TRX_TYPE = 'PAYMENT'

Line 1090: JAI_RGM_TRX_RECORDS

1086: CURSOR CUR_DIST_IN IS
1087: SELECT
1088: SUM(CREDIT_AMOUNT)
1089: FROM
1090: JAI_RGM_TRX_RECORDS
1091: WHERE SOURCE = 'SERVICE_DISTRIBUTE_IN'
1092: AND REGIME_CODE = 'SERVICE'
1093: AND TAX_TYPE = TAX_TYPE_SERVICE_EDU_CESS
1094: AND REGIME_PRIMARY_REGNO = P_REGISTRATION_NUMBER

Line 1104: JAI_RGM_TRX_RECORDS

1100: CURSOR CUR_MANUAL_IN IS
1101: SELECT
1102: SUM(CREDIT_AMOUNT)
1103: FROM
1104: JAI_RGM_TRX_RECORDS
1105: WHERE SOURCE = 'MANUAL'
1106: AND REGIME_CODE = 'SERVICE'
1107: AND TAX_TYPE = TAX_TYPE_SERVICE_EDU_CESS
1108: AND SOURCE_TRX_TYPE IN ( 'ADJUSTMENT-RECOVERY' , 'RECOVERY' )

Line 1141: JAI_RGM_TRX_RECORDS

1137: SELECT
1138: NVL(SUM(DEBIT_AMOUNT)
1139: ,0)
1140: FROM
1141: JAI_RGM_TRX_RECORDS
1142: WHERE SOURCE = 'SERVICE_DISTRIBUTE_OUT'
1143: AND REGIME_CODE = 'SERVICE'
1144: AND TAX_TYPE = TAX_TYPE_SERVICE_EDU_CESS
1145: AND REGIME_PRIMARY_REGNO = P_REGISTRATION_NUMBER

Line 1156: JAI_RGM_TRX_RECORDS

1152: SELECT
1153: NVL(SUM(DEBIT_AMOUNT)
1154: ,0)
1155: FROM
1156: JAI_RGM_TRX_RECORDS
1157: WHERE SOURCE = 'MANUAL'
1158: AND REGIME_CODE = 'SERVICE'
1159: AND TAX_TYPE = TAX_TYPE_SERVICE_EDU_CESS
1160: AND SOURCE_TRX_TYPE IN ( 'ADJUSTMENT-LIABILITY' , 'LIABILITY' )

Line 1172: JAI_RGM_TRX_RECORDS

1168: SELECT
1169: NVL(SUM(DEBIT_AMOUNT)
1170: ,0)
1171: FROM
1172: JAI_RGM_TRX_RECORDS
1173: WHERE SOURCE = 'MANUAL'
1174: AND REGIME_CODE = 'SERVICE'
1175: AND TAX_TYPE = TAX_TYPE_SERVICE_EDU_CESS
1176: AND SOURCE_TRX_TYPE = 'PAYMENT'

Line 2939: JAI_RGM_TRX_RECORDS

2935: CURSOR CUR_DIST_IN IS
2936: SELECT
2937: SUM(CREDIT_AMOUNT)
2938: FROM
2939: JAI_RGM_TRX_RECORDS
2940: WHERE SOURCE = 'SERVICE_DISTRIBUTE_IN'
2941: AND REGIME_CODE = 'SERVICE'
2942: AND TAX_TYPE = TAX_TYPE_SH_SERVICE_EDU_CESS
2943: AND REGIME_PRIMARY_REGNO = P_REGISTRATION_NUMBER

Line 2953: JAI_RGM_TRX_RECORDS

2949: CURSOR CUR_MANUAL_IN IS
2950: SELECT
2951: SUM(CREDIT_AMOUNT)
2952: FROM
2953: JAI_RGM_TRX_RECORDS
2954: WHERE SOURCE = 'MANUAL'
2955: AND REGIME_CODE = 'SERVICE'
2956: AND TAX_TYPE = TAX_TYPE_SH_SERVICE_EDU_CESS
2957: AND SOURCE_TRX_TYPE IN ( 'ADJUSTMENT-RECOVERY' , 'RECOVERY' )

Line 2990: JAI_RGM_TRX_RECORDS

2986: SELECT
2987: NVL(SUM(DEBIT_AMOUNT)
2988: ,0)
2989: FROM
2990: JAI_RGM_TRX_RECORDS
2991: WHERE SOURCE = 'SERVICE_DISTRIBUTE_OUT'
2992: AND REGIME_CODE = 'SERVICE'
2993: AND TAX_TYPE = TAX_TYPE_SH_SERVICE_EDU_CESS
2994: AND REGIME_PRIMARY_REGNO = P_REGISTRATION_NUMBER

Line 3005: JAI_RGM_TRX_RECORDS

3001: SELECT
3002: NVL(SUM(DEBIT_AMOUNT)
3003: ,0)
3004: FROM
3005: JAI_RGM_TRX_RECORDS
3006: WHERE SOURCE = 'MANUAL'
3007: AND REGIME_CODE = 'SERVICE'
3008: AND TAX_TYPE = TAX_TYPE_SH_SERVICE_EDU_CESS
3009: AND SOURCE_TRX_TYPE IN ( 'ADJUSTMENT-LIABILITY' , 'LIABILITY' )

Line 3021: JAI_RGM_TRX_RECORDS

3017: SELECT
3018: NVL(SUM(DEBIT_AMOUNT)
3019: ,0)
3020: FROM
3021: JAI_RGM_TRX_RECORDS
3022: WHERE SOURCE = 'MANUAL'
3023: AND REGIME_CODE = 'SERVICE'
3024: AND TAX_TYPE = TAX_TYPE_SH_SERVICE_EDU_CESS
3025: AND SOURCE_TRX_TYPE = 'PAYMENT'

Line 3215: JAI_RGM_TRX_RECORDS

3211: SELECT
3212: NVL(SUM(DEBIT_AMOUNT)
3213: ,0)
3214: FROM
3215: JAI_RGM_TRX_RECORDS
3216: WHERE SOURCE = 'SERVICE_DISTRIBUTE_OUT'
3217: AND REGIME_CODE = 'SERVICE'
3218: AND TAX_TYPE = TAX_TYPE_SH_SERVICE_EDU_CESS
3219: AND REGIME_PRIMARY_REGNO = P_REGISTRATION_NUMBER

Line 3232: JAI_RGM_TRX_RECORDS

3228: SELECT
3229: NVL(SUM(DEBIT_AMOUNT)
3230: ,0)
3231: FROM
3232: JAI_RGM_TRX_RECORDS
3233: WHERE SOURCE = 'MANUAL'
3234: AND REGIME_CODE = 'SERVICE'
3235: AND TAX_TYPE = TAX_TYPE_SH_SERVICE_EDU_CESS
3236: AND SOURCE_TRX_TYPE IN ( 'ADJUSTMENT-LIABILITY' , 'LIABILITY' )

Line 3250: JAI_RGM_TRX_RECORDS

3246: SELECT
3247: NVL(SUM(DEBIT_AMOUNT)
3248: ,0)
3249: FROM
3250: JAI_RGM_TRX_RECORDS
3251: WHERE SOURCE = 'MANUAL'
3252: AND REGIME_CODE = 'SERVICE'
3253: AND TAX_TYPE = TAX_TYPE_SH_SERVICE_EDU_CESS
3254: AND SOURCE_TRX_TYPE = 'PAYMENT'