eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_FASRSVES_XMLP_PKG dependencies on FA_BOOKS_MRC_V

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

657: AND
658: (DECODE (RT.Lookup_Code, AJ.Adjustment_Type, 1, 0) *
659: AJ.Adjustment_Amount) <> 0
660: -- start of cua
661: and not exists ( select 'x' from fa_books_mrc_v bks
662: where bks.book_type_code = Book
663: and bks.asset_id = aj.asset_id
664: and bks.group_asset_id is not null
665: and bks.date_ineffective is not null )

Line 934: fa_books_mrc_v bk,

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

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

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

Line 1147: FA_BOOKS_MRC_V BK

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

Line 1432: FA_BOOKS_MRC_V BK

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

Line 1680: FA_BOOKS_MRC_V BK,

1676: 'CIP COST', DD.Cost,
1677: 'RESERVE', DD.Deprn_Reserve,
1678: 'REVAL RESERVE', DD.Reval_Reserve)
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,

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

1727: BK.Book_Type_Code = Book AND
1728: BK.Asset_ID = DD.Asset_ID AND
1729: -- Commented by Prabakar
1730: ( bk.transaction_header_id_in
1731: = ( select min(fab.transaction_header_id_in) from fa_books_groups_mrc_v bg, fa_books_mrc_v fab
1732: where bg.group_asset_id = nvl(bk.group_asset_id,-2)
1733: and bg.book_type_code = fab.book_type_code
1734: and fab.transaction_header_id_in <= bg.transaction_header_id_in
1735: and nvl(fab.transaction_header_id_out,bg.transaction_header_id_in) >= bg.transaction_header_id_in

Line 2026: FA_BOOKS_MRC_V BK,

2022: 'CIP COST', DD.Cost,
2023: 'RESERVE', DD.Deprn_Reserve,
2024: 'REVAL RESERVE', DD.Reval_Reserve)
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,

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

2072: BK.Book_Type_Code = Book AND
2073: BK.Asset_ID = DD.Asset_ID AND
2074: -- Commented by Prabakar
2075: ( bk.transaction_header_id_in
2076: = ( select min(fab.transaction_header_id_in) from fa_books_groups_mrc_v bg, fa_books_mrc_v fab
2077: where bg.group_asset_id = nvl(bk.group_asset_id,-2)
2078: and bg.book_type_code = fab.book_type_code
2079: and fab.transaction_header_id_in <= bg.transaction_header_id_in
2080: and nvl(fab.transaction_header_id_out,bg.transaction_header_id_in) >= bg.transaction_header_id_in