APPS.FA_FASCOSTS_XMLP_PKG dependencies on FA_BOOKS_MRC_V

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

633: AND
634: (DECODE (RT.Lookup_Code, AJ.Adjustment_Type, 1, 0) *
635: AJ.Adjustment_Amount) <> 0
636: -- start of cua
637: and not exists ( select 'x' from fa_books_mrc_v bks
638: where bks.book_type_code = Book
639: and bks.asset_id = aj.asset_id
640: and bks.group_asset_id is not null
641: and bks.date_ineffective is not null )

Line 910: fa_books_mrc_v bk,

906: AJ.Adjustment_Amount)
907: FROM
908: FA_LOOKUPS RT,
909: FA_ADJUSTMENTS_MRC_V AJ,
910: fa_books_mrc_v bk,
911: fa_group_asset_default gad
912:
913: /* SLA Changes */
914: ,xla_ae_headers headers

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

919: and bk.book_type_code = book
920: and bk.group_asset_id = gad.group_asset_id
921: and bk.book_type_code = gad.book_type_code
922: and bk.date_ineffective is null
923: and aj.asset_id in (select asset_id from fa_books_mrc_v
924: where group_asset_id is not null
925: and date_ineffective is null)
926: and
927: RT.Lookup_Type = 'REPORT TYPE' AND

Line 1123: FA_BOOKS_MRC_V BK

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

Line 1408: FA_BOOKS_MRC_V BK

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

Line 1656: FA_BOOKS_MRC_V BK,

1652: 'CIP COST', DD.Cost,
1653: 'RESERVE', DD.Deprn_Reserve,
1654: 'REVAL RESERVE', DD.Reval_Reserve)
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,

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

1703: BK.Book_Type_Code = Book AND
1704: BK.Asset_ID = DD.Asset_ID AND
1705: -- Commented by Prabakar
1706: ( bk.transaction_header_id_in
1707: = ( select min(fab.transaction_header_id_in) from fa_books_groups_mrc_v bg, fa_books_mrc_v fab
1708: where bg.group_asset_id = nvl(bk.group_asset_id,-2)
1709: and bg.book_type_code = fab.book_type_code
1710: and fab.transaction_header_id_in <= bg.transaction_header_id_in
1711: and nvl(fab.transaction_header_id_out,bg.transaction_header_id_in) >= bg.transaction_header_id_in

Line 2002: FA_BOOKS_MRC_V BK,

1998: 'CIP COST', DD.Cost,
1999: 'RESERVE', DD.Deprn_Reserve,
2000: 'REVAL RESERVE', DD.Reval_Reserve)
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,

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

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