APPS.FA_FASRSVED_XMLP_PKG dependencies on FA_DEPRN_DETAIL_MRC_V

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 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 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 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 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 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 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 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