APPS.FA_FASRSVES_XMLP_PKG dependencies on FA_DEPRN_DETAIL_MRC_V

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