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

Line 770: FA_DEPRN_DETAIL_MRC_V DD

766: sum(DD.DEPRN_RESERVE)
767: FROM FA_DISTRIBUTION_HISTORY DH,
768: FA_CATEGORY_BOOKS CB,
769: FA_ASSET_HISTORY AH,
770: FA_DEPRN_DETAIL_MRC_V DD
771: WHERE NOT EXISTS (SELECT ASSET_ID
772: FROM FA_BALANCES_REPORT_GT
773: WHERE ASSET_ID = DH.ASSET_ID
774: AND DISTRIBUTION_CCID = DH.CODE_COMBINATION_ID

Line 812: FA_DEPRN_DETAIL DD

808: sum(DD.DEPRN_RESERVE)
809: FROM FA_DISTRIBUTION_HISTORY DH,
810: FA_CATEGORY_BOOKS CB,
811: FA_ASSET_HISTORY AH,
812: FA_DEPRN_DETAIL DD
813: WHERE NOT EXISTS (SELECT ASSET_ID
814: FROM FA_BALANCES_REPORT_GT
815: WHERE ASSET_ID = DH.ASSET_ID
816: AND DISTRIBUTION_CCID = DH.CODE_COMBINATION_ID

Line 1112: FA_DEPRN_DETAIL_MRC_V DD,

1108: 'RESERVE', DD.Deprn_Reserve,
1109: 'REVAL RESERVE', DD.Reval_Reserve)
1110: FROM
1111: FA_DISTRIBUTION_HISTORY DH,
1112: FA_DEPRN_DETAIL_MRC_V DD,
1113: FA_ASSET_HISTORY AH,
1114: FA_CATEGORY_BOOKS CB,
1115: FA_BOOKS_MRC_V BK
1116: WHERE

Line 1138: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD

1134: DD.Deprn_Source_Code AND */
1135: -- End bug fix 5076193
1136: DD.Period_Counter =
1137: (SELECT MAX (SUB_DD.Period_Counter)
1138: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD
1139: WHERE SUB_DD.Book_Type_Code = Book AND
1140: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1141: DH.Distribution_ID = DD.Distribution_ID AND
1142: SUB_DD.Period_Counter <= Period_PC)

Line 1209: FA_DEPRN_DETAIL DD,

1205: 'RESERVE', DD.Deprn_Reserve,
1206: 'REVAL RESERVE', DD.Reval_Reserve)
1207: FROM
1208: FA_DISTRIBUTION_HISTORY DH,
1209: FA_DEPRN_DETAIL DD,
1210: FA_ASSET_HISTORY AH,
1211: FA_CATEGORY_BOOKS CB,
1212: FA_BOOKS BK
1213: WHERE

Line 1235: FROM FA_DEPRN_DETAIL SUB_DD

1231: DD.Deprn_Source_Code AND */
1232: -- End bug fix 5076193
1233: DD.Period_Counter =
1234: (SELECT MAX (SUB_DD.Period_Counter)
1235: FROM FA_DEPRN_DETAIL SUB_DD
1236: WHERE SUB_DD.Book_Type_Code = Book AND
1237: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1238: DH.Distribution_ID = DD.Distribution_ID AND
1239: SUB_DD.Period_Counter <= Period_PC)

Line 1303: FA_DEPRN_DETAIL DD,

1299: 'RESERVE', DD.Deprn_Reserve,
1300: 'REVAL RESERVE', DD.Reval_Reserve)
1301: FROM
1302: FA_DISTRIBUTION_HISTORY DH,
1303: FA_DEPRN_DETAIL DD,
1304: FA_ASSET_HISTORY AH,
1305: FA_CATEGORY_BOOKS CB,
1306: FA_BOOKS BK
1307: WHERE

Line 1323: FROM FA_DEPRN_DETAIL SUB_DD

1319: 'BEGIN', DD.Deprn_Source_Code, 'D') =
1320: DD.Deprn_Source_Code AND
1321: DD.Period_Counter =
1322: (SELECT MAX (SUB_DD.Period_Counter)
1323: FROM FA_DEPRN_DETAIL SUB_DD
1324: WHERE SUB_DD.Book_Type_Code = Book AND
1325: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1326: DH.Distribution_ID = DD.Distribution_ID AND
1327: SUB_DD.Period_Counter <= Period_PC)

Line 1397: FA_DEPRN_DETAIL_MRC_V DD,

1393: 'RESERVE', DD.Deprn_Reserve,
1394: 'REVAL RESERVE', DD.Reval_Reserve)
1395: FROM
1396: FA_DISTRIBUTION_HISTORY DH,
1397: FA_DEPRN_DETAIL_MRC_V DD,
1398: FA_ASSET_HISTORY AH,
1399: FA_CATEGORY_BOOKS CB,
1400: FA_BOOKS_MRC_V BK
1401: WHERE

Line 1423: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD

1419: DD.Deprn_Source_Code AND */
1420: -- end bug fix 5076193
1421: DD.Period_Counter =
1422: (SELECT MAX (SUB_DD.Period_Counter)
1423: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD
1424: WHERE SUB_DD.Book_Type_Code = Book AND
1425: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1426: DH.Distribution_ID = DD.Distribution_ID AND
1427: SUB_DD.Period_Counter <= Period_PC)

Line 1494: FA_DEPRN_DETAIL DD,

1490: 'RESERVE', DD.Deprn_Reserve,
1491: 'REVAL RESERVE', DD.Reval_Reserve)
1492: FROM
1493: FA_DISTRIBUTION_HISTORY DH,
1494: FA_DEPRN_DETAIL DD,
1495: FA_ASSET_HISTORY AH,
1496: FA_CATEGORY_BOOKS CB,
1497: FA_BOOKS BK
1498: WHERE

Line 1520: FROM FA_DEPRN_DETAIL SUB_DD

1516: DD.Deprn_Source_Code AND */
1517: -- End bug fix 5076193
1518: DD.Period_Counter =
1519: (SELECT MAX (SUB_DD.Period_Counter)
1520: FROM FA_DEPRN_DETAIL SUB_DD
1521: WHERE SUB_DD.Book_Type_Code = Book AND
1522: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1523: DH.Distribution_ID = DD.Distribution_ID AND
1524: SUB_DD.Period_Counter <= Period_PC)

Line 1645: FA_DEPRN_DETAIL_MRC_V DD,

1641: FROM
1642: FA_BOOKS_MRC_V BK,
1643: FA_CATEGORY_BOOKS CB,
1644: FA_ASSET_HISTORY AH,
1645: FA_DEPRN_DETAIL_MRC_V DD,
1646: FA_DISTRIBUTION_HISTORY DH,
1647: -- Commented by Prabakar
1648: fa_GROUP_ASSET_DEFAULT GAD
1649: WHERE

Line 1671: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD

1667: 'BEGIN', DD.Deprn_Source_Code, 'D') =
1668: DD.Deprn_Source_Code AND
1669: DD.Period_Counter =
1670: (SELECT MAX (SUB_DD.Period_Counter)
1671: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD
1672: WHERE SUB_DD.Book_Type_Code = Book AND
1673: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1674: SUB_DD.Period_Counter <= Period_PC)
1675: AND

Line 1748: FA_DEPRN_DETAIL DD,

1744: FROM
1745: FA_BOOKS BK,
1746: FA_CATEGORY_BOOKS CB,
1747: FA_ASSET_HISTORY AH,
1748: FA_DEPRN_DETAIL DD,
1749: FA_DISTRIBUTION_HISTORY DH,
1750: -- Commented by Prabakar
1751: fa_GROUP_ASSET_DEFAULT GAD
1752: WHERE

Line 1774: FROM FA_DEPRN_DETAIL SUB_DD

1770: 'BEGIN', DD.Deprn_Source_Code, 'D') =
1771: DD.Deprn_Source_Code AND
1772: DD.Period_Counter =
1773: (SELECT MAX (SUB_DD.Period_Counter)
1774: FROM FA_DEPRN_DETAIL SUB_DD
1775: WHERE SUB_DD.Book_Type_Code = Book AND
1776: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1777: SUB_DD.Period_Counter <= Period_PC)
1778: AND

Line 1857: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

1853: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1854: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1855: AND DD.PERIOD_COUNTER =
1856: (SELECT max (DD_SUB.PERIOD_COUNTER)
1857: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
1858: WHERE DD_SUB.BOOK_TYPE_CODE = book
1859: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1860: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
1861: else

Line 1896: FROM FA_DEPRN_DETAIL DD_SUB

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

Line 1982: FA_DEPRN_DETAIL_MRC_V DD,

1978: FROM
1979: FA_BOOKS_MRC_V BK,
1980: FA_CATEGORY_BOOKS CB,
1981: FA_ASSET_HISTORY AH,
1982: FA_DEPRN_DETAIL_MRC_V DD,
1983: FA_DISTRIBUTION_HISTORY DH,
1984: -- Commented by Prabakar
1985: fa_GROUP_ASSET_DEFAULT GAD
1986: WHERE

Line 2007: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD

2003: 'BEGIN', DD.Deprn_Source_Code, 'D') =
2004: DD.Deprn_Source_Code AND
2005: DD.Period_Counter =
2006: (SELECT MAX (SUB_DD.Period_Counter)
2007: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD
2008: WHERE SUB_DD.Book_Type_Code = Book AND
2009: SUB_DD.Distribution_ID = DH.Distribution_ID AND
2010: SUB_DD.Period_Counter <= Period_PC)
2011: AND

Line 2082: FA_DEPRN_DETAIL DD,

2078: FROM
2079: FA_BOOKS BK,
2080: FA_CATEGORY_BOOKS CB,
2081: FA_ASSET_HISTORY AH,
2082: FA_DEPRN_DETAIL DD,
2083: FA_DISTRIBUTION_HISTORY DH,
2084: -- Commented by Prabakar
2085: fa_GROUP_ASSET_DEFAULT GAD
2086: WHERE

Line 2107: FROM FA_DEPRN_DETAIL SUB_DD

2103: 'BEGIN', DD.Deprn_Source_Code, 'D') =
2104: DD.Deprn_Source_Code AND
2105: DD.Period_Counter =
2106: (SELECT MAX (SUB_DD.Period_Counter)
2107: FROM FA_DEPRN_DETAIL SUB_DD
2108: WHERE SUB_DD.Book_Type_Code = Book AND
2109: SUB_DD.Distribution_ID = DH.Distribution_ID AND
2110: SUB_DD.Period_Counter <= Period_PC)
2111: AND

Line 2188: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

2184: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
2185: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
2186: AND DD.PERIOD_COUNTER =
2187: (SELECT max (DD_SUB.PERIOD_COUNTER)
2188: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
2189: WHERE DD_SUB.BOOK_TYPE_CODE = book
2190: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
2191: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
2192: else

Line 2226: FROM FA_DEPRN_DETAIL DD_SUB

2222: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
2223: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
2224: AND DD.PERIOD_COUNTER =
2225: (SELECT max (DD_SUB.PERIOD_COUNTER)
2226: FROM FA_DEPRN_DETAIL DD_SUB
2227: WHERE DD_SUB.BOOK_TYPE_CODE = book
2228: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
2229: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
2230: end if;

Line 2295: FA_DEPRN_DETAIL_MRC_V DD,

2291: FA_LOOKUPS_B RT,
2292: FA_CATEGORY_BOOKS CB,
2293: FA_DISTRIBUTION_HISTORY DH,
2294: FA_ASSET_HISTORY AH,
2295: FA_DEPRN_DETAIL_MRC_V DD,
2296: FA_DEPRN_PERIODS_MRC_V DP,
2297: FA_ADJUSTMENTS_MRC_V ADJ
2298: WHERE
2299: DH.Book_Type_Code = Distribution_Source_Book

Line 2374: FA_DEPRN_DETAIL DD,

2370: FA_LOOKUPS_B RT,
2371: FA_CATEGORY_BOOKS CB,
2372: FA_DISTRIBUTION_HISTORY DH,
2373: FA_ASSET_HISTORY AH,
2374: FA_DEPRN_DETAIL DD,
2375: FA_DEPRN_PERIODS DP,
2376: FA_ADJUSTMENTS ADJ
2377: WHERE
2378: DH.Book_Type_Code = Distribution_Source_Book