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.FA_FASRSVES_XMLP_PKG dependencies on FA_DEPRN_DETAIL

Line 788: FA_DEPRN_DETAIL_MRC_V DD

784: sum(DD.DEPRN_RESERVE)
785: FROM FA_DISTRIBUTION_HISTORY DH,
786: FA_CATEGORY_BOOKS CB,
787: FA_ASSET_HISTORY AH,
788: FA_DEPRN_DETAIL_MRC_V DD
789: WHERE NOT EXISTS (SELECT ASSET_ID
790: FROM FA_BALANCES_REPORT_GT
791: WHERE ASSET_ID = DH.ASSET_ID
792: AND DISTRIBUTION_CCID = DH.CODE_COMBINATION_ID

Line 830: FA_DEPRN_DETAIL DD

826: sum(DD.DEPRN_RESERVE)
827: FROM FA_DISTRIBUTION_HISTORY DH,
828: FA_CATEGORY_BOOKS CB,
829: FA_ASSET_HISTORY AH,
830: FA_DEPRN_DETAIL DD
831: WHERE NOT EXISTS (SELECT ASSET_ID
832: FROM FA_BALANCES_REPORT_GT
833: WHERE ASSET_ID = DH.ASSET_ID
834: AND DISTRIBUTION_CCID = DH.CODE_COMBINATION_ID

Line 1144: FA_DEPRN_DETAIL_MRC_V DD,

1140: 'RESERVE', DD.Deprn_Reserve,
1141: 'REVAL RESERVE', DD.Reval_Reserve)
1142: FROM
1143: FA_DISTRIBUTION_HISTORY DH,
1144: FA_DEPRN_DETAIL_MRC_V DD,
1145: FA_ASSET_HISTORY AH,
1146: FA_CATEGORY_BOOKS CB,
1147: FA_BOOKS_MRC_V BK
1148: WHERE

Line 1170: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD

1166: DD.Deprn_Source_Code AND */
1167: -- End bug fix 5076193
1168: DD.Period_Counter =
1169: (SELECT MAX (SUB_DD.Period_Counter)
1170: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD
1171: WHERE SUB_DD.Book_Type_Code = Book AND
1172: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1173: DH.Distribution_ID = DD.Distribution_ID AND
1174: SUB_DD.Period_Counter <= Period_PC)

Line 1241: FA_DEPRN_DETAIL DD,

1237: 'RESERVE', DD.Deprn_Reserve,
1238: 'REVAL RESERVE', DD.Reval_Reserve)
1239: FROM
1240: FA_DISTRIBUTION_HISTORY DH,
1241: FA_DEPRN_DETAIL DD,
1242: FA_ASSET_HISTORY AH,
1243: FA_CATEGORY_BOOKS CB,
1244: FA_BOOKS BK
1245: WHERE

Line 1267: FROM FA_DEPRN_DETAIL SUB_DD

1263: DD.Deprn_Source_Code AND */
1264: -- End bug fix 5076193
1265: DD.Period_Counter =
1266: (SELECT MAX (SUB_DD.Period_Counter)
1267: FROM FA_DEPRN_DETAIL SUB_DD
1268: WHERE SUB_DD.Book_Type_Code = Book AND
1269: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1270: DH.Distribution_ID = DD.Distribution_ID AND
1271: SUB_DD.Period_Counter <= Period_PC)

Line 1335: FA_DEPRN_DETAIL DD,

1331: 'RESERVE', DD.Deprn_Reserve,
1332: 'REVAL RESERVE', DD.Reval_Reserve)
1333: FROM
1334: FA_DISTRIBUTION_HISTORY DH,
1335: FA_DEPRN_DETAIL DD,
1336: FA_ASSET_HISTORY AH,
1337: FA_CATEGORY_BOOKS CB,
1338: FA_BOOKS BK
1339: WHERE

Line 1355: FROM FA_DEPRN_DETAIL SUB_DD

1351: 'BEGIN', DD.Deprn_Source_Code, 'D') =
1352: DD.Deprn_Source_Code AND
1353: DD.Period_Counter =
1354: (SELECT MAX (SUB_DD.Period_Counter)
1355: FROM FA_DEPRN_DETAIL SUB_DD
1356: WHERE SUB_DD.Book_Type_Code = Book AND
1357: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1358: DH.Distribution_ID = DD.Distribution_ID AND
1359: SUB_DD.Period_Counter <= Period_PC)

Line 1429: FA_DEPRN_DETAIL_MRC_V DD,

1425: 'RESERVE', DD.Deprn_Reserve,
1426: 'REVAL RESERVE', DD.Reval_Reserve)
1427: FROM
1428: FA_DISTRIBUTION_HISTORY DH,
1429: FA_DEPRN_DETAIL_MRC_V DD,
1430: FA_ASSET_HISTORY AH,
1431: FA_CATEGORY_BOOKS CB,
1432: FA_BOOKS_MRC_V BK
1433: WHERE

Line 1455: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD

1451: DD.Deprn_Source_Code AND */
1452: -- end bug fix 5076193
1453: DD.Period_Counter =
1454: (SELECT MAX (SUB_DD.Period_Counter)
1455: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD
1456: WHERE SUB_DD.Book_Type_Code = Book AND
1457: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1458: DH.Distribution_ID = DD.Distribution_ID AND
1459: SUB_DD.Period_Counter <= Period_PC)

Line 1526: FA_DEPRN_DETAIL DD,

1522: 'RESERVE', DD.Deprn_Reserve,
1523: 'REVAL RESERVE', DD.Reval_Reserve)
1524: FROM
1525: FA_DISTRIBUTION_HISTORY DH,
1526: FA_DEPRN_DETAIL DD,
1527: FA_ASSET_HISTORY AH,
1528: FA_CATEGORY_BOOKS CB,
1529: FA_BOOKS BK
1530: WHERE

Line 1552: FROM FA_DEPRN_DETAIL SUB_DD

1548: DD.Deprn_Source_Code AND */
1549: -- End bug fix 5076193
1550: DD.Period_Counter =
1551: (SELECT MAX (SUB_DD.Period_Counter)
1552: FROM FA_DEPRN_DETAIL SUB_DD
1553: WHERE SUB_DD.Book_Type_Code = Book AND
1554: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1555: DH.Distribution_ID = DD.Distribution_ID AND
1556: SUB_DD.Period_Counter <= Period_PC)

Line 1683: FA_DEPRN_DETAIL_MRC_V DD,

1679: FROM
1680: FA_BOOKS_MRC_V BK,
1681: FA_CATEGORY_BOOKS CB,
1682: FA_ASSET_HISTORY AH,
1683: FA_DEPRN_DETAIL_MRC_V DD,
1684: FA_DISTRIBUTION_HISTORY DH,
1685: -- Commented by Prabakar
1686: fa_GROUP_ASSET_DEFAULT GAD
1687: WHERE

Line 1709: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD

1705: 'BEGIN', DD.Deprn_Source_Code, 'D') =
1706: DD.Deprn_Source_Code AND
1707: DD.Period_Counter =
1708: (SELECT MAX (SUB_DD.Period_Counter)
1709: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD
1710: WHERE SUB_DD.Book_Type_Code = Book AND
1711: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1712: SUB_DD.Period_Counter <= Period_PC)
1713: AND

Line 1786: FA_DEPRN_DETAIL DD,

1782: FROM
1783: FA_BOOKS BK,
1784: FA_CATEGORY_BOOKS CB,
1785: FA_ASSET_HISTORY AH,
1786: FA_DEPRN_DETAIL DD,
1787: FA_DISTRIBUTION_HISTORY DH,
1788: -- Commented by Prabakar
1789: fa_GROUP_ASSET_DEFAULT GAD
1790: WHERE

Line 1812: FROM FA_DEPRN_DETAIL SUB_DD

1808: 'BEGIN', DD.Deprn_Source_Code, 'D') =
1809: DD.Deprn_Source_Code AND
1810: DD.Period_Counter =
1811: (SELECT MAX (SUB_DD.Period_Counter)
1812: FROM FA_DEPRN_DETAIL SUB_DD
1813: WHERE SUB_DD.Book_Type_Code = Book AND
1814: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1815: SUB_DD.Period_Counter <= Period_PC)
1816: AND

Line 1895: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

1891: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1892: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1893: AND DD.PERIOD_COUNTER =
1894: (SELECT max (DD_SUB.PERIOD_COUNTER)
1895: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
1896: WHERE DD_SUB.BOOK_TYPE_CODE = book
1897: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1898: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
1899: else

Line 1934: FROM FA_DEPRN_DETAIL DD_SUB

1930: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1931: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1932: AND DD.PERIOD_COUNTER =
1933: (SELECT max (DD_SUB.PERIOD_COUNTER)
1934: FROM FA_DEPRN_DETAIL DD_SUB
1935: WHERE DD_SUB.BOOK_TYPE_CODE = book
1936: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1937: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
1938: end if;

Line 2029: FA_DEPRN_DETAIL_MRC_V DD,

2025: FROM
2026: FA_BOOKS_MRC_V BK,
2027: FA_CATEGORY_BOOKS CB,
2028: FA_ASSET_HISTORY AH,
2029: FA_DEPRN_DETAIL_MRC_V DD,
2030: FA_DISTRIBUTION_HISTORY DH,
2031: -- Commented by Prabakar
2032: fa_GROUP_ASSET_DEFAULT GAD
2033: WHERE

Line 2054: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD

2050: 'BEGIN', DD.Deprn_Source_Code, 'D') =
2051: DD.Deprn_Source_Code AND
2052: DD.Period_Counter =
2053: (SELECT MAX (SUB_DD.Period_Counter)
2054: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD
2055: WHERE SUB_DD.Book_Type_Code = Book AND
2056: SUB_DD.Distribution_ID = DH.Distribution_ID AND
2057: SUB_DD.Period_Counter <= Period_PC)
2058: AND

Line 2129: FA_DEPRN_DETAIL DD,

2125: FROM
2126: FA_BOOKS BK,
2127: FA_CATEGORY_BOOKS CB,
2128: FA_ASSET_HISTORY AH,
2129: FA_DEPRN_DETAIL DD,
2130: FA_DISTRIBUTION_HISTORY DH,
2131: -- Commented by Prabakar
2132: fa_GROUP_ASSET_DEFAULT GAD
2133: WHERE

Line 2154: FROM FA_DEPRN_DETAIL SUB_DD

2150: 'BEGIN', DD.Deprn_Source_Code, 'D') =
2151: DD.Deprn_Source_Code AND
2152: DD.Period_Counter =
2153: (SELECT MAX (SUB_DD.Period_Counter)
2154: FROM FA_DEPRN_DETAIL SUB_DD
2155: WHERE SUB_DD.Book_Type_Code = Book AND
2156: SUB_DD.Distribution_ID = DH.Distribution_ID AND
2157: SUB_DD.Period_Counter <= Period_PC)
2158: AND

Line 2235: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

2231: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
2232: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
2233: AND DD.PERIOD_COUNTER =
2234: (SELECT max (DD_SUB.PERIOD_COUNTER)
2235: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
2236: WHERE DD_SUB.BOOK_TYPE_CODE = book
2237: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
2238: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
2239: else

Line 2273: FROM FA_DEPRN_DETAIL DD_SUB

2269: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
2270: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
2271: AND DD.PERIOD_COUNTER =
2272: (SELECT max (DD_SUB.PERIOD_COUNTER)
2273: FROM FA_DEPRN_DETAIL DD_SUB
2274: WHERE DD_SUB.BOOK_TYPE_CODE = book
2275: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
2276: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
2277: end if;

Line 2350: FA_DEPRN_DETAIL_MRC_V DD,

2346: FA_LOOKUPS_B RT,
2347: FA_CATEGORY_BOOKS CB,
2348: FA_DISTRIBUTION_HISTORY DH,
2349: FA_ASSET_HISTORY AH,
2350: FA_DEPRN_DETAIL_MRC_V DD,
2351: FA_DEPRN_PERIODS_MRC_V DP,
2352: FA_ADJUSTMENTS_MRC_V ADJ
2353: WHERE
2354: DH.Book_Type_Code = Distribution_Source_Book

Line 2429: FA_DEPRN_DETAIL DD,

2425: FA_LOOKUPS_B RT,
2426: FA_CATEGORY_BOOKS CB,
2427: FA_DISTRIBUTION_HISTORY DH,
2428: FA_ASSET_HISTORY AH,
2429: FA_DEPRN_DETAIL DD,
2430: FA_DEPRN_PERIODS DP,
2431: FA_ADJUSTMENTS ADJ
2432: WHERE
2433: DH.Book_Type_Code = Distribution_Source_Book