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 JAI_FA_AST_PERIOD_RATES

Line 303: JAI_FA_AST_PERIOD_RATES D

299: FROM
300: FA_BOOKS A,
301: JAI_FA_AST_BLOCKS B,
302: JAI_FA_AST_BLOCK_DTLS C,
303: JAI_FA_AST_PERIOD_RATES D
304: WHERE A.ASSET_ID = C.ASSET_ID
305: AND ( ( C.ASSET_TYPE = LV_CAPITALIZED
306: AND A.CAPITALIZE_FLAG = LV_FLAG )
307: OR C.ASSET_TYPE = LV_EXPENSED )

Line 328: JAI_FA_AST_PERIOD_RATES D

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
332: AND B.OWNED_LEASED = 'OWNED'

Line 354: JAI_FA_AST_PERIOD_RATES D

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
358: AND B.OWNED_LEASED = 'OWNED'

Line 674: JAI_FA_AST_PERIOD_RATES C,

670: E.CURRENT_UNITS
671: FROM
672: JAI_FA_AST_BLOCK_DTLS A,
673: JAI_FA_AST_BLOCKS B,
674: JAI_FA_AST_PERIOD_RATES C,
675: FA_BOOKS D,
676: FA_ADDITIONS E
677: WHERE E.OWNED_LEASED = LV_OWNED
678: AND E.ASSET_ID = A.ASSET_ID

Line 703: JAI_FA_AST_PERIOD_RATES C,

699: count(*)
700: FROM
701: JAI_FA_AST_BLOCK_DTLS A,
702: JAI_FA_AST_BLOCKS B,
703: JAI_FA_AST_PERIOD_RATES C,
704: FA_BOOKS D,
705: FA_ADDITIONS E
706: WHERE E.OWNED_LEASED = 'OWNED'
707: AND E.ASSET_ID = A.ASSET_ID

Line 923: JAI_FA_AST_PERIOD_RATES C

919: B.BLOCK_ID,
920: B.TYPE
921: FROM
922: JAI_FA_AST_BLOCKS B,
923: JAI_FA_AST_PERIOD_RATES C
924: WHERE B.START_DATE >= P_YEAR_START
925: AND B.START_DATE <= P_YEAR_END
926: AND C.YEAR_START >= P_YEAR_START
927: AND C.YEAR_END <= P_YEAR_END

Line 1261: JAI_FA_AST_PERIOD_RATES C,

1257: A.CURRENT_UNITS
1258: FROM
1259: FA_ADDITIONS A,
1260: JAI_FA_AST_BLOCKS B,
1261: JAI_FA_AST_PERIOD_RATES C,
1262: FA_BOOKS D,
1263: JAI_FA_AST_BLOCK_DTLS E
1264: WHERE A.OWNED_LEASED = LV_OWNED_LEASED
1265: AND ( ( A.ASSET_TYPE = LV_CAPITALIZED

Line 1307: JAI_FA_AST_PERIOD_RATES C

1303: B.BLOCK_ID,
1304: B.TYPE
1305: FROM
1306: JAI_FA_AST_BLOCKS B,
1307: JAI_FA_AST_PERIOD_RATES C
1308: WHERE B.START_DATE >= P_YEAR_START
1309: AND B.START_DATE <= P_YEAR_END
1310: AND C.YEAR_START >= P_YEAR_START
1311: AND C.YEAR_END <= P_YEAR_END

Line 1485: JAI_FA_AST_PERIOD_RATES C,

1481: count(*)
1482: FROM
1483: FA_ADDITIONS A,
1484: JAI_FA_AST_BLOCKS B,
1485: JAI_FA_AST_PERIOD_RATES C,
1486: FA_BOOKS D,
1487: JAI_FA_AST_BLOCK_DTLS E
1488: WHERE A.OWNED_LEASED = LV_OWNED_LEASED
1489: AND ( ( A.ASSET_TYPE = LV_CAPITALIZED

Line 2709: JAI_FA_AST_PERIOD_RATES C,

2705: A.FIXED_ASSETS_UNITS
2706: FROM
2707: FA_MASS_ADDITIONS A,
2708: JAI_FA_AST_BLOCKS B,
2709: JAI_FA_AST_PERIOD_RATES C,
2710: FA_BOOKS D
2711: WHERE NVL(A.MASS_ADDITION_ID
2712: ,0) = NVL(D.ASSET_ID
2713: ,0)

Line 2736: JAI_FA_AST_PERIOD_RATES C,

2732: count(*)
2733: FROM
2734: FA_MASS_ADDITIONS A,
2735: JAI_FA_AST_BLOCKS B,
2736: JAI_FA_AST_PERIOD_RATES C,
2737: FA_BOOKS D
2738: WHERE NVL(A.MASS_ADDITION_ID
2739: ,0) = NVL(D.ASSET_ID
2740: ,0)

Line 2934: JAI_FA_AST_PERIOD_RATES C

2930: B.BLOCK_ID,
2931: B.TYPE
2932: FROM
2933: JAI_FA_AST_BLOCKS B,
2934: JAI_FA_AST_PERIOD_RATES C
2935: WHERE B.START_DATE >= P_YEAR_START
2936: AND B.START_DATE <= P_YEAR_END
2937: AND C.YEAR_START >= P_YEAR_START
2938: AND C.YEAR_END <= P_YEAR_END

Line 3962: JAI_FA_AST_PERIOD_RATES D

3958: FROM
3959: FA_BOOKS A,
3960: JAI_FA_AST_BLOCKS B,
3961: JAI_FA_AST_BLOCK_DTLS C,
3962: JAI_FA_AST_PERIOD_RATES D
3963: WHERE A.ASSET_ID = C.ASSET_ID
3964: AND ( ( C.ASSET_TYPE = LV_CAPITALIZED
3965: AND A.CAPITALIZE_FLAG = LV_FLAG )
3966: OR C.ASSET_TYPE = LV_EXPENSED )

Line 3998: JAI_FA_AST_PERIOD_RATES D

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
4002: AND B.OWNED_LEASED = 'OWNED'

Line 4024: JAI_FA_AST_PERIOD_RATES D

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
4028: AND B.OWNED_LEASED = 'OWNED'