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

Line 764: FA_DEPRN_DETAIL_MRC_V DD

760: sum(DD.DEPRN_RESERVE)
761: FROM FA_DISTRIBUTION_HISTORY DH,
762: FA_CATEGORY_BOOKS CB,
763: FA_ASSET_HISTORY AH,
764: FA_DEPRN_DETAIL_MRC_V DD
765: WHERE NOT EXISTS (SELECT ASSET_ID
766: FROM FA_BALANCES_REPORT_GT
767: WHERE ASSET_ID = DH.ASSET_ID
768: AND DISTRIBUTION_CCID = DH.CODE_COMBINATION_ID

Line 806: FA_DEPRN_DETAIL DD

802: sum(DD.DEPRN_RESERVE)
803: FROM FA_DISTRIBUTION_HISTORY DH,
804: FA_CATEGORY_BOOKS CB,
805: FA_ASSET_HISTORY AH,
806: FA_DEPRN_DETAIL DD
807: WHERE NOT EXISTS (SELECT ASSET_ID
808: FROM FA_BALANCES_REPORT_GT
809: WHERE ASSET_ID = DH.ASSET_ID
810: AND DISTRIBUTION_CCID = DH.CODE_COMBINATION_ID

Line 1120: FA_DEPRN_DETAIL_MRC_V DD,

1116: 'RESERVE', DD.Deprn_Reserve,
1117: 'REVAL RESERVE', DD.Reval_Reserve)
1118: FROM
1119: FA_DISTRIBUTION_HISTORY DH,
1120: FA_DEPRN_DETAIL_MRC_V DD,
1121: FA_ASSET_HISTORY AH,
1122: FA_CATEGORY_BOOKS CB,
1123: FA_BOOKS_MRC_V BK
1124: WHERE

Line 1146: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD

1142: DD.Deprn_Source_Code AND */
1143: -- End bug fix 5076193
1144: DD.Period_Counter =
1145: (SELECT MAX (SUB_DD.Period_Counter)
1146: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD
1147: WHERE SUB_DD.Book_Type_Code = Book AND
1148: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1149: DH.Distribution_ID = DD.Distribution_ID AND
1150: SUB_DD.Period_Counter <= Period_PC)

Line 1217: FA_DEPRN_DETAIL DD,

1213: 'RESERVE', DD.Deprn_Reserve,
1214: 'REVAL RESERVE', DD.Reval_Reserve)
1215: FROM
1216: FA_DISTRIBUTION_HISTORY DH,
1217: FA_DEPRN_DETAIL DD,
1218: FA_ASSET_HISTORY AH,
1219: FA_CATEGORY_BOOKS CB,
1220: FA_BOOKS BK
1221: WHERE

Line 1243: FROM FA_DEPRN_DETAIL SUB_DD

1239: DD.Deprn_Source_Code AND */
1240: -- End bug fix 5076193
1241: DD.Period_Counter =
1242: (SELECT MAX (SUB_DD.Period_Counter)
1243: FROM FA_DEPRN_DETAIL SUB_DD
1244: WHERE SUB_DD.Book_Type_Code = Book AND
1245: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1246: DH.Distribution_ID = DD.Distribution_ID AND
1247: SUB_DD.Period_Counter <= Period_PC)

Line 1311: FA_DEPRN_DETAIL DD,

1307: 'RESERVE', DD.Deprn_Reserve,
1308: 'REVAL RESERVE', DD.Reval_Reserve)
1309: FROM
1310: FA_DISTRIBUTION_HISTORY DH,
1311: FA_DEPRN_DETAIL DD,
1312: FA_ASSET_HISTORY AH,
1313: FA_CATEGORY_BOOKS CB,
1314: FA_BOOKS BK
1315: WHERE

Line 1331: FROM FA_DEPRN_DETAIL SUB_DD

1327: 'BEGIN', DD.Deprn_Source_Code, 'D') =
1328: DD.Deprn_Source_Code AND
1329: DD.Period_Counter =
1330: (SELECT MAX (SUB_DD.Period_Counter)
1331: FROM FA_DEPRN_DETAIL SUB_DD
1332: WHERE SUB_DD.Book_Type_Code = Book AND
1333: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1334: DH.Distribution_ID = DD.Distribution_ID AND
1335: SUB_DD.Period_Counter <= Period_PC)

Line 1405: FA_DEPRN_DETAIL_MRC_V DD,

1401: 'RESERVE', DD.Deprn_Reserve,
1402: 'REVAL RESERVE', DD.Reval_Reserve)
1403: FROM
1404: FA_DISTRIBUTION_HISTORY DH,
1405: FA_DEPRN_DETAIL_MRC_V DD,
1406: FA_ASSET_HISTORY AH,
1407: FA_CATEGORY_BOOKS CB,
1408: FA_BOOKS_MRC_V BK
1409: WHERE

Line 1431: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD

1427: DD.Deprn_Source_Code AND */
1428: -- end bug fix 5076193
1429: DD.Period_Counter =
1430: (SELECT MAX (SUB_DD.Period_Counter)
1431: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD
1432: WHERE SUB_DD.Book_Type_Code = Book AND
1433: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1434: DH.Distribution_ID = DD.Distribution_ID AND
1435: SUB_DD.Period_Counter <= Period_PC)

Line 1502: FA_DEPRN_DETAIL DD,

1498: 'RESERVE', DD.Deprn_Reserve,
1499: 'REVAL RESERVE', DD.Reval_Reserve)
1500: FROM
1501: FA_DISTRIBUTION_HISTORY DH,
1502: FA_DEPRN_DETAIL DD,
1503: FA_ASSET_HISTORY AH,
1504: FA_CATEGORY_BOOKS CB,
1505: FA_BOOKS BK
1506: WHERE

Line 1528: FROM FA_DEPRN_DETAIL SUB_DD

1524: DD.Deprn_Source_Code AND */
1525: -- End bug fix 5076193
1526: DD.Period_Counter =
1527: (SELECT MAX (SUB_DD.Period_Counter)
1528: FROM FA_DEPRN_DETAIL SUB_DD
1529: WHERE SUB_DD.Book_Type_Code = Book AND
1530: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1531: DH.Distribution_ID = DD.Distribution_ID AND
1532: SUB_DD.Period_Counter <= Period_PC)

Line 1659: FA_DEPRN_DETAIL_MRC_V DD,

1655: FROM
1656: FA_BOOKS_MRC_V BK,
1657: FA_CATEGORY_BOOKS CB,
1658: FA_ASSET_HISTORY AH,
1659: FA_DEPRN_DETAIL_MRC_V DD,
1660: FA_DISTRIBUTION_HISTORY DH,
1661: -- Commented by Prabakar
1662: fa_GROUP_ASSET_DEFAULT GAD
1663: WHERE

Line 1685: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD

1681: 'BEGIN', DD.Deprn_Source_Code, 'D') =
1682: DD.Deprn_Source_Code AND
1683: DD.Period_Counter =
1684: (SELECT MAX (SUB_DD.Period_Counter)
1685: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD
1686: WHERE SUB_DD.Book_Type_Code = Book AND
1687: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1688: SUB_DD.Period_Counter <= Period_PC)
1689: AND

Line 1762: FA_DEPRN_DETAIL DD,

1758: FROM
1759: FA_BOOKS BK,
1760: FA_CATEGORY_BOOKS CB,
1761: FA_ASSET_HISTORY AH,
1762: FA_DEPRN_DETAIL DD,
1763: FA_DISTRIBUTION_HISTORY DH,
1764: -- Commented by Prabakar
1765: fa_GROUP_ASSET_DEFAULT GAD
1766: WHERE

Line 1788: FROM FA_DEPRN_DETAIL SUB_DD

1784: 'BEGIN', DD.Deprn_Source_Code, 'D') =
1785: DD.Deprn_Source_Code AND
1786: DD.Period_Counter =
1787: (SELECT MAX (SUB_DD.Period_Counter)
1788: FROM FA_DEPRN_DETAIL SUB_DD
1789: WHERE SUB_DD.Book_Type_Code = Book AND
1790: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1791: SUB_DD.Period_Counter <= Period_PC)
1792: AND

Line 1871: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

1867: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1868: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1869: AND DD.PERIOD_COUNTER =
1870: (SELECT max (DD_SUB.PERIOD_COUNTER)
1871: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
1872: WHERE DD_SUB.BOOK_TYPE_CODE = book
1873: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1874: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
1875: else

Line 1910: FROM FA_DEPRN_DETAIL DD_SUB

1906: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1907: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1908: AND DD.PERIOD_COUNTER =
1909: (SELECT max (DD_SUB.PERIOD_COUNTER)
1910: FROM FA_DEPRN_DETAIL DD_SUB
1911: WHERE DD_SUB.BOOK_TYPE_CODE = book
1912: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1913: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
1914: end if;

Line 2005: FA_DEPRN_DETAIL_MRC_V DD,

2001: FROM
2002: FA_BOOKS_MRC_V BK,
2003: FA_CATEGORY_BOOKS CB,
2004: FA_ASSET_HISTORY AH,
2005: FA_DEPRN_DETAIL_MRC_V DD,
2006: FA_DISTRIBUTION_HISTORY DH,
2007: -- Commented by Prabakar
2008: fa_GROUP_ASSET_DEFAULT GAD
2009: WHERE

Line 2030: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD

2026: 'BEGIN', DD.Deprn_Source_Code, 'D') =
2027: DD.Deprn_Source_Code AND
2028: DD.Period_Counter =
2029: (SELECT MAX (SUB_DD.Period_Counter)
2030: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD
2031: WHERE SUB_DD.Book_Type_Code = Book AND
2032: SUB_DD.Distribution_ID = DH.Distribution_ID AND
2033: SUB_DD.Period_Counter <= Period_PC)
2034: AND

Line 2105: FA_DEPRN_DETAIL DD,

2101: FROM
2102: FA_BOOKS BK,
2103: FA_CATEGORY_BOOKS CB,
2104: FA_ASSET_HISTORY AH,
2105: FA_DEPRN_DETAIL DD,
2106: FA_DISTRIBUTION_HISTORY DH,
2107: -- Commented by Prabakar
2108: fa_GROUP_ASSET_DEFAULT GAD
2109: WHERE

Line 2130: FROM FA_DEPRN_DETAIL SUB_DD

2126: 'BEGIN', DD.Deprn_Source_Code, 'D') =
2127: DD.Deprn_Source_Code AND
2128: DD.Period_Counter =
2129: (SELECT MAX (SUB_DD.Period_Counter)
2130: FROM FA_DEPRN_DETAIL SUB_DD
2131: WHERE SUB_DD.Book_Type_Code = Book AND
2132: SUB_DD.Distribution_ID = DH.Distribution_ID AND
2133: SUB_DD.Period_Counter <= Period_PC)
2134: AND

Line 2211: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

2207: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
2208: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
2209: AND DD.PERIOD_COUNTER =
2210: (SELECT max (DD_SUB.PERIOD_COUNTER)
2211: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
2212: WHERE DD_SUB.BOOK_TYPE_CODE = book
2213: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
2214: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
2215: else

Line 2249: FROM FA_DEPRN_DETAIL DD_SUB

2245: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
2246: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
2247: AND DD.PERIOD_COUNTER =
2248: (SELECT max (DD_SUB.PERIOD_COUNTER)
2249: FROM FA_DEPRN_DETAIL DD_SUB
2250: WHERE DD_SUB.BOOK_TYPE_CODE = book
2251: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
2252: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
2253: end if;

Line 2326: FA_DEPRN_DETAIL_MRC_V DD,

2322: FA_LOOKUPS_B RT,
2323: FA_CATEGORY_BOOKS CB,
2324: FA_DISTRIBUTION_HISTORY DH,
2325: FA_ASSET_HISTORY AH,
2326: FA_DEPRN_DETAIL_MRC_V DD,
2327: FA_DEPRN_PERIODS_MRC_V DP,
2328: FA_ADJUSTMENTS_MRC_V ADJ
2329: WHERE
2330: DH.Book_Type_Code = Distribution_Source_Book

Line 2405: FA_DEPRN_DETAIL DD,

2401: FA_LOOKUPS_B RT,
2402: FA_CATEGORY_BOOKS CB,
2403: FA_DISTRIBUTION_HISTORY DH,
2404: FA_ASSET_HISTORY AH,
2405: FA_DEPRN_DETAIL DD,
2406: FA_DEPRN_PERIODS DP,
2407: FA_ADJUSTMENTS ADJ
2408: WHERE
2409: DH.Book_Type_Code = Distribution_Source_Book