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_JAINYEDE_XMLP_PKG dependencies on FA_RETIREMENTS

Line 53: FA_RETIREMENTS A,

49: ( NVL(A.PROCEEDS_OF_SALE
50: ,0) - NVL(A.COST_OF_REMOVAL
51: ,0) ) SALE
52: FROM
53: FA_RETIREMENTS A,
54: JAI_FA_AST_BLOCK_DTLS B,
55: JAI_FA_AST_BLOCKS C
56: WHERE A.ASSET_ID = B.ASSET_ID
57: AND A.STATUS = 'PROCESSED'

Line 111: FA_RETIREMENTS C

107: A.BLOCK_ID
108: FROM
109: JAI_FA_AST_BLOCKS A,
110: JAI_FA_AST_BLOCK_DTLS B,
111: FA_RETIREMENTS C
112: WHERE A.BLOCK_ID = B.BLOCK_ID
113: AND B.ASSET_ID = C.ASSET_ID
114: GROUP BY
115: A.BLOCK_ID;

Line 141: FA_RETIREMENTS A,

137: ( NVL(A.PROCEEDS_OF_SALE
138: ,0) - NVL(A.COST_OF_REMOVAL
139: ,0) ) SALE
140: FROM
141: FA_RETIREMENTS A,
142: JAI_FA_AST_BLOCK_DTLS B,
143: JAI_FA_AST_BLOCKS C
144: WHERE A.ASSET_ID = B.ASSET_ID
145: AND B.BLOCK_ID = P_BLOCK_ID

Line 195: CURSOR SALE_CUR(CP_OWNED_LEASED IN FA_ADDITIONS.OWNED_LEASED%TYPE,CP_STATUS IN FA_RETIREMENTS.STATUS%TYPE) IS

191: JAI_FA_AST_BLOCKS
192: WHERE TYPE = TYPE1
193: AND RATE = RATE
194: AND START_DATE < START_DATE;
195: CURSOR SALE_CUR(CP_OWNED_LEASED IN FA_ADDITIONS.OWNED_LEASED%TYPE,CP_STATUS IN FA_RETIREMENTS.STATUS%TYPE) IS
196: SELECT
197: NVL(SUM(FAR.PROCEEDS_OF_SALE - FAR.COST_OF_REMOVAL)
198: ,0) SALE
199: FROM

Line 203: FA_RETIREMENTS FAR

199: FROM
200: JAI_FA_AST_BLOCK_DTLS JBA,
201: FA_ADDITIONS FA,
202: JAI_FA_AST_BLOCKS JABLOA,
203: FA_RETIREMENTS FAR
204: WHERE FA.OWNED_LEASED = CP_OWNED_LEASED
205: AND FA.ASSET_ID = JBA.ASSET_ID
206: AND JBA.BLOCK_ID = JABLOA.BLOCK_ID
207: AND FAR.BOOK_TYPE_CODE = JABLOA.BOOK_TYPE_CODE

Line 327: FA_RETIREMENTS C,

323: ,0) SALE
324: FROM
325: JAI_FA_AST_BLOCKS A,
326: FA_ADDITIONS B,
327: FA_RETIREMENTS C,
328: JAI_FA_AST_PERIOD_RATES D
329: WHERE B.CONTEXT = P_CONTEXT_VALUE
330: AND TO_CHAR(A.BLOCK_ID) = B.ATTRIBUTE2
331: AND A.BOOK_TYPE_CODE = BOOK_NAME

Line 353: FA_RETIREMENTS C,

349: ,0) SALE
350: FROM
351: JAI_FA_AST_BLOCKS A,
352: FA_ADDITIONS B,
353: FA_RETIREMENTS C,
354: JAI_FA_AST_PERIOD_RATES D
355: WHERE B.CONTEXT = P_CONTEXT_VALUE
356: AND TO_CHAR(A.BLOCK_ID) = B.ATTRIBUTE2
357: AND A.BOOK_TYPE_CODE = BOOK_NAME

Line 739: FA_RETIREMENTS C

735: ,0) SALE
736: FROM
737: JAI_FA_AST_BLOCKS A,
738: JAI_FA_AST_BLOCK_DTLS B,
739: FA_RETIREMENTS C
740: WHERE A.BLOCK_ID = B.BLOCK_ID
741: AND A.BOOK_TYPE_CODE = P_BOOK_NAME
742: AND B.ASSET_ID = C.ASSET_ID
743: AND C.DATE_RETIRED between P_YEAR_START

Line 770: CURSOR FA_RETIREMENTS_CUR(P_BLOCK_ID IN NUMBER) IS

766: AND RATE = P_RATE
767: AND BOOK_TYPE_CODE = P_BOOK_NAME
768: AND START_DATE BETWEEN P_YEAR_START
769: AND P_YEAR_END;
770: CURSOR FA_RETIREMENTS_CUR(P_BLOCK_ID IN NUMBER) IS
771: SELECT
772: DISTINCT
773: SUM(NVL(A.PROCEEDS_OF_SALE
774: ,0)) SALE

Line 776: FA_RETIREMENTS A,

772: DISTINCT
773: SUM(NVL(A.PROCEEDS_OF_SALE
774: ,0)) SALE
775: FROM
776: FA_RETIREMENTS A,
777: JAI_FA_AST_BLOCK_DTLS B,
778: JAI_FA_AST_BLOCKS C
779: WHERE A.ASSET_ID = B.ASSET_ID
780: AND B.BLOCK_ID = P_BLOCK_ID

Line 875: FA_RETIREMENTS A,

871: SELECT
872: A.UNITS,
873: B.BLOCK_ID
874: FROM
875: FA_RETIREMENTS A,
876: JAI_FA_AST_BLOCK_DTLS B
877: WHERE A.DATE_RETIRED <= P_YEAR_END
878: AND A.ASSET_ID = B.ASSET_ID
879: AND A.STATUS = 'PROCESSED'

Line 945: FA_RETIREMENTS

941: CURSOR RETIRE_COUNT IS
942: SELECT
943: COUNT(*)
944: FROM
945: FA_RETIREMENTS
946: WHERE DATE_RETIRED BETWEEN P_YEAR_START
947: AND P_YEAR_END;
948: CURSOR RET_ASSET_BLOCK_CUR IS
949: SELECT

Line 952: FA_RETIREMENTS A,

948: CURSOR RET_ASSET_BLOCK_CUR IS
949: SELECT
950: count(*)
951: FROM
952: FA_RETIREMENTS A,
953: JAI_FA_AST_BLOCK_DTLS B,
954: JAI_FA_AST_BLOCKS C
955: WHERE A.DATE_RETIRED BETWEEN P_YEAR_START
956: AND P_YEAR_END

Line 1175: LV_STATUS FA_RETIREMENTS.STATUS%TYPE;

1171: LV_CAPITALIZED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
1172: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;
1173: LV_EXPENSED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
1174: LV_OWNED_LEASED FA_ADDITIONS.OWNED_LEASED%TYPE;
1175: LV_STATUS FA_RETIREMENTS.STATUS%TYPE;
1176: V_C NUMBER := 0;
1177: K NUMBER := 0;
1178: I NUMBER := 0;
1179: V_DEPR_VAL NUMBER;

Line 1319: FA_RETIREMENTS A,

1315: SELECT
1316: NVL(SUM(A.PROCEEDS_OF_SALE - A.COST_OF_REMOVAL)
1317: ,0) SALE
1318: FROM
1319: FA_RETIREMENTS A,
1320: JAI_FA_AST_BLOCK_DTLS B,
1321: JAI_FA_AST_BLOCKS C,
1322: FA_BOOKS D
1323: WHERE A.ASSET_ID = B.ASSET_ID

Line 1343: FA_RETIREMENTS C

1339: ,0) SALE
1340: FROM
1341: JAI_FA_AST_BLOCKS A,
1342: JAI_FA_AST_BLOCK_DTLS B,
1343: FA_RETIREMENTS C
1344: WHERE A.BLOCK_ID = B.BLOCK_ID
1345: AND A.BOOK_TYPE_CODE = P_BOOK_NAME
1346: AND B.ASSET_ID = C.ASSET_ID
1347: AND C.STATUS = LV_STATUS

Line 1351: CURSOR FA_RETIREMENTS_CUR(P_BLOCK_ID IN NUMBER) IS

1347: AND C.STATUS = LV_STATUS
1348: AND A.TYPE = P_BLOCK_TYPE
1349: AND C.DATE_RETIRED BETWEEN P_YEAR_START
1350: AND P_YEAR_END;
1351: CURSOR FA_RETIREMENTS_CUR(P_BLOCK_ID IN NUMBER) IS
1352: SELECT
1353: DISTINCT
1354: SUM(NVL(A.PROCEEDS_OF_SALE
1355: ,0)) SALE

Line 1357: FA_RETIREMENTS A,

1353: DISTINCT
1354: SUM(NVL(A.PROCEEDS_OF_SALE
1355: ,0)) SALE
1356: FROM
1357: FA_RETIREMENTS A,
1358: JAI_FA_AST_BLOCK_DTLS B,
1359: JAI_FA_AST_BLOCKS C
1360: WHERE A.ASSET_ID = B.ASSET_ID
1361: AND B.ASSET_TYPE IN ( LV_CAPITALIZED , LV_EXPENSED )

Line 1454: FA_RETIREMENTS A,

1450: SELECT
1451: A.UNITS,
1452: TO_NUMBER(B.BLOCK_ID)
1453: FROM
1454: FA_RETIREMENTS A,
1455: JAI_FA_AST_BLOCK_DTLS B
1456: WHERE A.DATE_RETIRED <= P_YEAR_END
1457: AND A.ASSET_ID = B.ASSET_ID
1458: AND A.STATUS = LV_STATUS

Line 1528: FA_RETIREMENTS

1524: CURSOR RETIRE_COUNT IS
1525: SELECT
1526: count(*)
1527: FROM
1528: FA_RETIREMENTS
1529: WHERE DATE_RETIRED BETWEEN P_YEAR_START
1530: AND P_YEAR_END;
1531: CURSOR RET_ASSET_BLOCK_CUR IS
1532: SELECT

Line 1535: FA_RETIREMENTS A,

1531: CURSOR RET_ASSET_BLOCK_CUR IS
1532: SELECT
1533: COUNT(*)
1534: FROM
1535: FA_RETIREMENTS A,
1536: JAI_FA_AST_BLOCK_DTLS B,
1537: JAI_FA_AST_BLOCKS C
1538: WHERE A.DATE_RETIRED BETWEEN P_YEAR_START
1539: AND P_YEAR_END

Line 2209: OPEN FA_RETIREMENTS_CUR(TEMP_REC.BLOCK_ID);

2205: OPEN TYPE_CUR(TEMP_REC.BLOCK_ID);
2206: FETCH TYPE_CUR
2207: INTO V_TYPE,V_BLOCK_RATE,V_OPENING_WDV1,V_OPENING_WDV_ADJ,V_DEPN_ADJ;
2208: CLOSE TYPE_CUR;
2209: OPEN FA_RETIREMENTS_CUR(TEMP_REC.BLOCK_ID);
2210: FETCH FA_RETIREMENTS_CUR
2211: INTO V_PROCEEDS_OF_SALE;
2212: CLOSE FA_RETIREMENTS_CUR;
2213: V_RETIRED := NULL;

Line 2210: FETCH FA_RETIREMENTS_CUR

2206: FETCH TYPE_CUR
2207: INTO V_TYPE,V_BLOCK_RATE,V_OPENING_WDV1,V_OPENING_WDV_ADJ,V_DEPN_ADJ;
2208: CLOSE TYPE_CUR;
2209: OPEN FA_RETIREMENTS_CUR(TEMP_REC.BLOCK_ID);
2210: FETCH FA_RETIREMENTS_CUR
2211: INTO V_PROCEEDS_OF_SALE;
2212: CLOSE FA_RETIREMENTS_CUR;
2213: V_RETIRED := NULL;
2214: OPEN BLOCK_RET_CUR(V_TYPE);

Line 2212: CLOSE FA_RETIREMENTS_CUR;

2208: CLOSE TYPE_CUR;
2209: OPEN FA_RETIREMENTS_CUR(TEMP_REC.BLOCK_ID);
2210: FETCH FA_RETIREMENTS_CUR
2211: INTO V_PROCEEDS_OF_SALE;
2212: CLOSE FA_RETIREMENTS_CUR;
2213: V_RETIRED := NULL;
2214: OPEN BLOCK_RET_CUR(V_TYPE);
2215: FETCH BLOCK_RET_CUR
2216: INTO V_RETIRED;

Line 2770: FA_RETIREMENTS C

2766: ,0) SALE
2767: FROM
2768: JAI_FA_AST_BLOCKS A,
2769: FA_MASS_ADDITIONS B,
2770: FA_RETIREMENTS C
2771: WHERE A.BLOCK_ID = B.ATTRIBUTE2
2772: AND A.BOOK_TYPE_CODE = P_BOOK_NAME
2773: AND B.MASS_ADDITION_ID = C.ASSET_ID
2774: AND A.BLOCK_ID = P_BLOCK_ID

Line 2779: CURSOR FA_RETIREMENTS_CUR(P_BLOCK_ID IN NUMBER) IS

2775: AND C.DATE_RETIRED between P_YEAR_START
2776: AND P_YEAR_END
2777: GROUP BY
2778: A.BLOCK_ID;
2779: CURSOR FA_RETIREMENTS_CUR(P_BLOCK_ID IN NUMBER) IS
2780: SELECT
2781: DISTINCT
2782: SUM(NVL(A.PROCEEDS_OF_SALE
2783: ,0)) SALE

Line 2785: FA_RETIREMENTS A,

2781: DISTINCT
2782: SUM(NVL(A.PROCEEDS_OF_SALE
2783: ,0)) SALE
2784: FROM
2785: FA_RETIREMENTS A,
2786: FA_MASS_ADDITIONS B,
2787: JAI_FA_AST_BLOCKS C
2788: WHERE A.ASSET_ID = B.MASS_ADDITION_ID
2789: AND B.ATTRIBUTE2 = P_BLOCK_ID

Line 2885: FA_RETIREMENTS A,

2881: SELECT
2882: A.UNITS,
2883: TO_NUMBER(B.ATTRIBUTE2)
2884: FROM
2885: FA_RETIREMENTS A,
2886: FA_MASS_ADDITIONS B
2887: WHERE A.DATE_RETIRED <= P_YEAR_END
2888: AND A.ASSET_ID = B.MASS_ADDITION_ID
2889: AND A.STATUS = 'PROCESSED'

Line 2956: FA_RETIREMENTS

2952: CURSOR RETIRE_COUNT IS
2953: SELECT
2954: COUNT(*)
2955: FROM
2956: FA_RETIREMENTS
2957: WHERE DATE_RETIRED BETWEEN P_YEAR_START
2958: AND P_YEAR_END;
2959: CURSOR RET_ASSET_BLOCK_CUR IS
2960: SELECT

Line 2963: FA_RETIREMENTS A,

2959: CURSOR RET_ASSET_BLOCK_CUR IS
2960: SELECT
2961: count(*)
2962: FROM
2963: FA_RETIREMENTS A,
2964: FA_MASS_ADDITIONS B,
2965: JAI_FA_AST_BLOCKS C
2966: WHERE A.DATE_RETIRED BETWEEN P_YEAR_START
2967: AND P_YEAR_END

Line 3497: OPEN FA_RETIREMENTS_CUR(TEMP_REC.BLOCK_ID);

3493: OPEN TYPE_CUR(TEMP_REC.BLOCK_ID);
3494: FETCH TYPE_CUR
3495: INTO V_TYPE,V_BLOCK_RATE,V_OPENING_WDV1,V_OPENING_WDV_ADJ,V_DEPN_ADJ;
3496: CLOSE TYPE_CUR;
3497: OPEN FA_RETIREMENTS_CUR(TEMP_REC.BLOCK_ID);
3498: FETCH FA_RETIREMENTS_CUR
3499: INTO V_PROCEEDS_OF_SALE;
3500: CLOSE FA_RETIREMENTS_CUR;
3501: OPEN BLOCK_RET_CUR(TEMP_REC.BLOCK_ID);

Line 3498: FETCH FA_RETIREMENTS_CUR

3494: FETCH TYPE_CUR
3495: INTO V_TYPE,V_BLOCK_RATE,V_OPENING_WDV1,V_OPENING_WDV_ADJ,V_DEPN_ADJ;
3496: CLOSE TYPE_CUR;
3497: OPEN FA_RETIREMENTS_CUR(TEMP_REC.BLOCK_ID);
3498: FETCH FA_RETIREMENTS_CUR
3499: INTO V_PROCEEDS_OF_SALE;
3500: CLOSE FA_RETIREMENTS_CUR;
3501: OPEN BLOCK_RET_CUR(TEMP_REC.BLOCK_ID);
3502: FETCH BLOCK_RET_CUR

Line 3500: CLOSE FA_RETIREMENTS_CUR;

3496: CLOSE TYPE_CUR;
3497: OPEN FA_RETIREMENTS_CUR(TEMP_REC.BLOCK_ID);
3498: FETCH FA_RETIREMENTS_CUR
3499: INTO V_PROCEEDS_OF_SALE;
3500: CLOSE FA_RETIREMENTS_CUR;
3501: OPEN BLOCK_RET_CUR(TEMP_REC.BLOCK_ID);
3502: FETCH BLOCK_RET_CUR
3503: INTO V_CLOSING_BLOCK_ID,V_RETIRED;
3504: CLOSE BLOCK_RET_CUR;

Line 3866: CURSOR ASSET_COST(CP_STATUS IN FA_RETIREMENTS.STATUS%TYPE) IS

3862: RETURN (TRUE);
3863: END AFTERREPORT;
3864:
3865: FUNCTION CF_9FORMULA(BLOCK_ID IN NUMBER) RETURN NUMBER IS
3866: CURSOR ASSET_COST(CP_STATUS IN FA_RETIREMENTS.STATUS%TYPE) IS
3867: SELECT
3868: NVL(SUM(SLNO)
3869: ,0) COST
3870: FROM

Line 3876: FA_RETIREMENTS

3872: WHERE ASSET_ID Not In (
3873: SELECT
3874: ASSET_ID
3875: FROM
3876: FA_RETIREMENTS
3877: WHERE BOOK_TYPE_CODE = BOOK_NAME
3878: AND STATUS = CP_STATUS
3879: AND DATE_RETIRED between START_DATE
3880: AND END_DATE_N )

Line 3903: LV_STATUS FA_RETIREMENTS.STATUS%TYPE;

3899: ,P_NO_ASSETS OUT NOCOPY VARCHAR2) RETURN NUMBER IS
3900: LV_CAPITALIZED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
3901: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;
3902: LV_EXPENSED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
3903: LV_STATUS FA_RETIREMENTS.STATUS%TYPE;
3904: CURSOR CUR_GET_VALID_ASSETS IS
3905: SELECT
3906: '1'
3907: FROM

Line 3997: FA_RETIREMENTS C,

3993: ,0) SALE
3994: FROM
3995: JAI_FA_AST_BLOCKS A,
3996: FA_ADDITIONS B,
3997: FA_RETIREMENTS C,
3998: JAI_FA_AST_PERIOD_RATES D
3999: WHERE B.CONTEXT = P_CONTEXT_VALUE
4000: AND TO_CHAR(A.BLOCK_ID) = B.ATTRIBUTE2
4001: AND A.BOOK_TYPE_CODE = P_BOOK_NAME

Line 4023: FA_RETIREMENTS C,

4019: ,0) SALE
4020: FROM
4021: JAI_FA_AST_BLOCKS A,
4022: FA_ADDITIONS B,
4023: FA_RETIREMENTS C,
4024: JAI_FA_AST_PERIOD_RATES D
4025: WHERE B.CONTEXT = P_CONTEXT_VALUE
4026: AND TO_CHAR(A.BLOCK_ID) = B.ATTRIBUTE2
4027: AND A.BOOK_TYPE_CODE = P_BOOK_NAME