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_FASRSVED_XMLP_PKG dependencies on FA_DEPRN_DETAIL

Line 797: FA_DEPRN_DETAIL_MRC_V DD

793: sum(DD.DEPRN_RESERVE)
794: FROM FA_DISTRIBUTION_HISTORY DH,
795: FA_CATEGORY_BOOKS CB,
796: FA_ASSET_HISTORY AH,
797: FA_DEPRN_DETAIL_MRC_V DD
798: WHERE NOT EXISTS (SELECT ASSET_ID
799: FROM FA_BALANCES_REPORT_GT
800: WHERE ASSET_ID = DH.ASSET_ID
801: AND DISTRIBUTION_CCID = DH.CODE_COMBINATION_ID

Line 839: FA_DEPRN_DETAIL DD

835: sum(DD.DEPRN_RESERVE)
836: FROM FA_DISTRIBUTION_HISTORY DH,
837: FA_CATEGORY_BOOKS CB,
838: FA_ASSET_HISTORY AH,
839: FA_DEPRN_DETAIL DD
840: WHERE NOT EXISTS (SELECT ASSET_ID
841: FROM FA_BALANCES_REPORT_GT
842: WHERE ASSET_ID = DH.ASSET_ID
843: AND DISTRIBUTION_CCID = DH.CODE_COMBINATION_ID

Line 1139: FA_DEPRN_DETAIL_MRC_V DD,

1135: 'RESERVE', DD.Deprn_Reserve,
1136: 'REVAL RESERVE', DD.Reval_Reserve)
1137: FROM
1138: FA_DISTRIBUTION_HISTORY DH,
1139: FA_DEPRN_DETAIL_MRC_V DD,
1140: FA_ASSET_HISTORY AH,
1141: FA_CATEGORY_BOOKS CB,
1142: FA_BOOKS_MRC_V BK
1143: WHERE

Line 1165: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD

1161: DD.Deprn_Source_Code AND */
1162: -- End bug fix 5076193
1163: DD.Period_Counter =
1164: (SELECT MAX (SUB_DD.Period_Counter)
1165: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD
1166: WHERE SUB_DD.Book_Type_Code = Book AND
1167: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1168: DH.Distribution_ID = DD.Distribution_ID AND
1169: SUB_DD.Period_Counter <= Period_PC)

Line 1236: FA_DEPRN_DETAIL DD,

1232: 'RESERVE', DD.Deprn_Reserve,
1233: 'REVAL RESERVE', DD.Reval_Reserve)
1234: FROM
1235: FA_DISTRIBUTION_HISTORY DH,
1236: FA_DEPRN_DETAIL DD,
1237: FA_ASSET_HISTORY AH,
1238: FA_CATEGORY_BOOKS CB,
1239: FA_BOOKS BK
1240: WHERE

Line 1262: FROM FA_DEPRN_DETAIL SUB_DD

1258: DD.Deprn_Source_Code AND */
1259: -- End bug fix 5076193
1260: DD.Period_Counter =
1261: (SELECT MAX (SUB_DD.Period_Counter)
1262: FROM FA_DEPRN_DETAIL SUB_DD
1263: WHERE SUB_DD.Book_Type_Code = Book AND
1264: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1265: DH.Distribution_ID = DD.Distribution_ID AND
1266: SUB_DD.Period_Counter <= Period_PC)

Line 1330: FA_DEPRN_DETAIL DD,

1326: 'RESERVE', DD.Deprn_Reserve,
1327: 'REVAL RESERVE', DD.Reval_Reserve)
1328: FROM
1329: FA_DISTRIBUTION_HISTORY DH,
1330: FA_DEPRN_DETAIL DD,
1331: FA_ASSET_HISTORY AH,
1332: FA_CATEGORY_BOOKS CB,
1333: FA_BOOKS BK
1334: WHERE

Line 1350: FROM FA_DEPRN_DETAIL SUB_DD

1346: 'BEGIN', DD.Deprn_Source_Code, 'D') =
1347: DD.Deprn_Source_Code AND
1348: DD.Period_Counter =
1349: (SELECT MAX (SUB_DD.Period_Counter)
1350: FROM FA_DEPRN_DETAIL SUB_DD
1351: WHERE SUB_DD.Book_Type_Code = Book AND
1352: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1353: DH.Distribution_ID = DD.Distribution_ID AND
1354: SUB_DD.Period_Counter <= Period_PC)

Line 1424: FA_DEPRN_DETAIL_MRC_V DD,

1420: 'RESERVE', DD.Deprn_Reserve,
1421: 'REVAL RESERVE', DD.Reval_Reserve)
1422: FROM
1423: FA_DISTRIBUTION_HISTORY DH,
1424: FA_DEPRN_DETAIL_MRC_V DD,
1425: FA_ASSET_HISTORY AH,
1426: FA_CATEGORY_BOOKS CB,
1427: FA_BOOKS_MRC_V BK
1428: WHERE

Line 1450: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD

1446: DD.Deprn_Source_Code AND */
1447: -- end bug fix 5076193
1448: DD.Period_Counter =
1449: (SELECT MAX (SUB_DD.Period_Counter)
1450: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD
1451: WHERE SUB_DD.Book_Type_Code = Book AND
1452: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1453: DH.Distribution_ID = DD.Distribution_ID AND
1454: SUB_DD.Period_Counter <= Period_PC)

Line 1521: FA_DEPRN_DETAIL DD,

1517: 'RESERVE', DD.Deprn_Reserve,
1518: 'REVAL RESERVE', DD.Reval_Reserve)
1519: FROM
1520: FA_DISTRIBUTION_HISTORY DH,
1521: FA_DEPRN_DETAIL DD,
1522: FA_ASSET_HISTORY AH,
1523: FA_CATEGORY_BOOKS CB,
1524: FA_BOOKS BK
1525: WHERE

Line 1547: FROM FA_DEPRN_DETAIL SUB_DD

1543: DD.Deprn_Source_Code AND */
1544: -- End bug fix 5076193
1545: DD.Period_Counter =
1546: (SELECT MAX (SUB_DD.Period_Counter)
1547: FROM FA_DEPRN_DETAIL SUB_DD
1548: WHERE SUB_DD.Book_Type_Code = Book AND
1549: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1550: DH.Distribution_ID = DD.Distribution_ID AND
1551: SUB_DD.Period_Counter <= Period_PC)

Line 1672: FA_DEPRN_DETAIL_MRC_V DD,

1668: FROM
1669: FA_BOOKS_MRC_V BK,
1670: FA_CATEGORY_BOOKS CB,
1671: FA_ASSET_HISTORY AH,
1672: FA_DEPRN_DETAIL_MRC_V DD,
1673: FA_DISTRIBUTION_HISTORY DH,
1674: -- Commented by Prabakar
1675: fa_GROUP_ASSET_DEFAULT GAD
1676: WHERE

Line 1698: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD

1694: 'BEGIN', DD.Deprn_Source_Code, 'D') =
1695: DD.Deprn_Source_Code AND
1696: DD.Period_Counter =
1697: (SELECT MAX (SUB_DD.Period_Counter)
1698: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD
1699: WHERE SUB_DD.Book_Type_Code = Book AND
1700: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1701: SUB_DD.Period_Counter <= Period_PC)
1702: AND

Line 1775: FA_DEPRN_DETAIL DD,

1771: FROM
1772: FA_BOOKS BK,
1773: FA_CATEGORY_BOOKS CB,
1774: FA_ASSET_HISTORY AH,
1775: FA_DEPRN_DETAIL DD,
1776: FA_DISTRIBUTION_HISTORY DH,
1777: -- Commented by Prabakar
1778: fa_GROUP_ASSET_DEFAULT GAD
1779: WHERE

Line 1801: FROM FA_DEPRN_DETAIL SUB_DD

1797: 'BEGIN', DD.Deprn_Source_Code, 'D') =
1798: DD.Deprn_Source_Code AND
1799: DD.Period_Counter =
1800: (SELECT MAX (SUB_DD.Period_Counter)
1801: FROM FA_DEPRN_DETAIL SUB_DD
1802: WHERE SUB_DD.Book_Type_Code = Book AND
1803: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1804: SUB_DD.Period_Counter <= Period_PC)
1805: AND

Line 1884: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

1880: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1881: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1882: AND DD.PERIOD_COUNTER =
1883: (SELECT max (DD_SUB.PERIOD_COUNTER)
1884: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
1885: WHERE DD_SUB.BOOK_TYPE_CODE = book
1886: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1887: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
1888: else

Line 1923: FROM FA_DEPRN_DETAIL DD_SUB

1919: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1920: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1921: AND DD.PERIOD_COUNTER =
1922: (SELECT max (DD_SUB.PERIOD_COUNTER)
1923: FROM FA_DEPRN_DETAIL DD_SUB
1924: WHERE DD_SUB.BOOK_TYPE_CODE = book
1925: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1926: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
1927: end if;

Line 2009: FA_DEPRN_DETAIL_MRC_V DD,

2005: FROM
2006: FA_BOOKS_MRC_V BK,
2007: FA_CATEGORY_BOOKS CB,
2008: FA_ASSET_HISTORY AH,
2009: FA_DEPRN_DETAIL_MRC_V DD,
2010: FA_DISTRIBUTION_HISTORY DH,
2011: -- Commented by Prabakar
2012: fa_GROUP_ASSET_DEFAULT GAD
2013: WHERE

Line 2034: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD

2030: 'BEGIN', DD.Deprn_Source_Code, 'D') =
2031: DD.Deprn_Source_Code AND
2032: DD.Period_Counter =
2033: (SELECT MAX (SUB_DD.Period_Counter)
2034: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD
2035: WHERE SUB_DD.Book_Type_Code = Book AND
2036: SUB_DD.Distribution_ID = DH.Distribution_ID AND
2037: SUB_DD.Period_Counter <= Period_PC)
2038: AND

Line 2109: FA_DEPRN_DETAIL DD,

2105: FROM
2106: FA_BOOKS BK,
2107: FA_CATEGORY_BOOKS CB,
2108: FA_ASSET_HISTORY AH,
2109: FA_DEPRN_DETAIL DD,
2110: FA_DISTRIBUTION_HISTORY DH,
2111: -- Commented by Prabakar
2112: fa_GROUP_ASSET_DEFAULT GAD
2113: WHERE

Line 2134: FROM FA_DEPRN_DETAIL SUB_DD

2130: 'BEGIN', DD.Deprn_Source_Code, 'D') =
2131: DD.Deprn_Source_Code AND
2132: DD.Period_Counter =
2133: (SELECT MAX (SUB_DD.Period_Counter)
2134: FROM FA_DEPRN_DETAIL SUB_DD
2135: WHERE SUB_DD.Book_Type_Code = Book AND
2136: SUB_DD.Distribution_ID = DH.Distribution_ID AND
2137: SUB_DD.Period_Counter <= Period_PC)
2138: AND

Line 2215: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

2211: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
2212: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
2213: AND DD.PERIOD_COUNTER =
2214: (SELECT max (DD_SUB.PERIOD_COUNTER)
2215: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
2216: WHERE DD_SUB.BOOK_TYPE_CODE = book
2217: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
2218: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
2219: else

Line 2253: FROM FA_DEPRN_DETAIL DD_SUB

2249: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
2250: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
2251: AND DD.PERIOD_COUNTER =
2252: (SELECT max (DD_SUB.PERIOD_COUNTER)
2253: FROM FA_DEPRN_DETAIL DD_SUB
2254: WHERE DD_SUB.BOOK_TYPE_CODE = book
2255: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
2256: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
2257: end if;

Line 2322: FA_DEPRN_DETAIL_MRC_V DD,

2318: FA_LOOKUPS_B RT,
2319: FA_CATEGORY_BOOKS CB,
2320: FA_DISTRIBUTION_HISTORY DH,
2321: FA_ASSET_HISTORY AH,
2322: FA_DEPRN_DETAIL_MRC_V DD,
2323: FA_DEPRN_PERIODS_MRC_V DP,
2324: FA_ADJUSTMENTS_MRC_V ADJ
2325: WHERE
2326: DH.Book_Type_Code = Distribution_Source_Book

Line 2401: FA_DEPRN_DETAIL DD,

2397: FA_LOOKUPS_B RT,
2398: FA_CATEGORY_BOOKS CB,
2399: FA_DISTRIBUTION_HISTORY DH,
2400: FA_ASSET_HISTORY AH,
2401: FA_DEPRN_DETAIL DD,
2402: FA_DEPRN_PERIODS DP,
2403: FA_ADJUSTMENTS ADJ
2404: WHERE
2405: DH.Book_Type_Code = Distribution_Source_Book