APPS.FA_FASRSVED_XMLP_PKG dependencies on FA_BOOKS_MRC_V

Line 670: and not exists ( select 'x' from fa_books_mrc_v bks

666: AND
667: (DECODE (RT.Lookup_Code, AJ.Adjustment_Type, 1, 0) *
668: AJ.Adjustment_Amount) <> 0
669: -- start of cua
670: and not exists ( select 'x' from fa_books_mrc_v bks
671: where bks.book_type_code = Book
672: and bks.asset_id = aj.asset_id
673: and bks.group_asset_id is not null
674: and bks.date_ineffective is not null )

Line 937: fa_books_mrc_v bk,

933: AJ.Adjustment_Amount)
934: FROM
935: FA_LOOKUPS RT,
936: FA_ADJUSTMENTS_MRC_V AJ,
937: fa_books_mrc_v bk,
938: fa_group_asset_default gad
939:
940: /* SLA Changes */
941: ,xla_ae_headers headers

Line 950: and aj.asset_id in (select asset_id from fa_books_mrc_v

946: and bk.book_type_code = book
947: and bk.group_asset_id = gad.group_asset_id
948: and bk.book_type_code = gad.book_type_code
949: and bk.date_ineffective is null
950: and aj.asset_id in (select asset_id from fa_books_mrc_v
951: where group_asset_id is not null
952: and date_ineffective is null)
953: and
954: RT.Lookup_Type = 'REPORT TYPE' AND

Line 1142: FA_BOOKS_MRC_V BK

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
1144: DH.Book_Type_Code = Distribution_Source_Book AND
1145: DECODE(DD.Deprn_Source_Code, 'D', P_Date,
1146: A_Date) BETWEEN

Line 1427: FA_BOOKS_MRC_V BK

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
1429: DH.Book_Type_Code = Distribution_Source_Book AND
1430: DECODE(DD.Deprn_Source_Code, 'D', P_Date,
1431: A_Date) BETWEEN

Line 1669: FA_BOOKS_MRC_V BK,

1665: 'CIP COST', DD.Cost,
1666: 'RESERVE', DD.Deprn_Reserve,
1667: 'REVAL RESERVE', DD.Reval_Reserve)
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,

Line 1720: = ( select min(fab.transaction_header_id_in) from fa_books_groups_mrc_v bg, fa_books_mrc_v fab

1716: BK.Book_Type_Code = Book AND
1717: BK.Asset_ID = DD.Asset_ID AND
1718: -- Commented by Prabakar
1719: ( bk.transaction_header_id_in
1720: = ( select min(fab.transaction_header_id_in) from fa_books_groups_mrc_v bg, fa_books_mrc_v fab
1721: where bg.group_asset_id = nvl(bk.group_asset_id,-2)
1722: and bg.book_type_code = fab.book_type_code
1723: and fab.transaction_header_id_in <= bg.transaction_header_id_in
1724: and nvl(fab.transaction_header_id_out,bg.transaction_header_id_in) >= bg.transaction_header_id_in

Line 2006: FA_BOOKS_MRC_V BK,

2002: 'CIP COST', DD.Cost,
2003: 'RESERVE', DD.Deprn_Reserve,
2004: 'REVAL RESERVE', DD.Reval_Reserve)
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,

Line 2056: = ( select min(fab.transaction_header_id_in) from fa_books_groups_mrc_v bg, fa_books_mrc_v fab

2052: BK.Book_Type_Code = Book AND
2053: BK.Asset_ID = DD.Asset_ID AND
2054: -- Commented by Prabakar
2055: ( bk.transaction_header_id_in
2056: = ( select min(fab.transaction_header_id_in) from fa_books_groups_mrc_v bg, fa_books_mrc_v fab
2057: where bg.group_asset_id = nvl(bk.group_asset_id,-2)
2058: and bg.book_type_code = fab.book_type_code
2059: and fab.transaction_header_id_in <= bg.transaction_header_id_in
2060: and nvl(fab.transaction_header_id_out,bg.transaction_header_id_in) >= bg.transaction_header_id_in