APPS.FA_FASCOSTD_XMLP_PKG dependencies on FA_BOOKS_MRC_V

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

639: AND
640: (DECODE (RT.Lookup_Code, AJ.Adjustment_Type, 1, 0) *
641: AJ.Adjustment_Amount) <> 0
642: -- start of cua
643: and not exists ( select 'x' from fa_books_mrc_v bks
644: where bks.book_type_code = Book
645: and bks.asset_id = aj.asset_id
646: and bks.group_asset_id is not null
647: 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 1115: FA_BOOKS_MRC_V BK

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

Line 1400: FA_BOOKS_MRC_V BK

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

Line 1642: FA_BOOKS_MRC_V BK,

1638: 'CIP COST', DD.Cost,
1639: 'RESERVE', DD.Deprn_Reserve,
1640: 'REVAL RESERVE', DD.Reval_Reserve)
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,

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

1689: BK.Book_Type_Code = Book AND
1690: BK.Asset_ID = DD.Asset_ID AND
1691: -- Commented by Prabakar
1692: ( bk.transaction_header_id_in
1693: = ( select min(fab.transaction_header_id_in) from fa_books_groups_mrc_v bg, fa_books_mrc_v fab
1694: where bg.group_asset_id = nvl(bk.group_asset_id,-2)
1695: and bg.book_type_code = fab.book_type_code
1696: and fab.transaction_header_id_in <= bg.transaction_header_id_in
1697: and nvl(fab.transaction_header_id_out,bg.transaction_header_id_in) >= bg.transaction_header_id_in

Line 1979: FA_BOOKS_MRC_V BK,

1975: 'CIP COST', DD.Cost,
1976: 'RESERVE', DD.Deprn_Reserve,
1977: 'REVAL RESERVE', DD.Reval_Reserve)
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,

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

2025: BK.Book_Type_Code = Book AND
2026: BK.Asset_ID = DD.Asset_ID AND
2027: -- Commented by Prabakar
2028: ( bk.transaction_header_id_in
2029: = ( select min(fab.transaction_header_id_in) from fa_books_groups_mrc_v bg, fa_books_mrc_v fab
2030: where bg.group_asset_id = nvl(bk.group_asset_id,-2)
2031: and bg.book_type_code = fab.book_type_code
2032: and fab.transaction_header_id_in <= bg.transaction_header_id_in
2033: and nvl(fab.transaction_header_id_out,bg.transaction_header_id_in) >= bg.transaction_header_id_in