APPS.FA_FASCOSTD_XMLP_PKG dependencies on FA_DEPRN_DETAIL_MRC_V

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