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_FASRSVED_XMLP_PKG dependencies on FA_BOOKS

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 751: and not exists ( select 'x' from fa_books bks

747: AND
748: (DECODE (RT.Lookup_Code, AJ.Adjustment_Type, 1, 0) *
749: AJ.Adjustment_Amount) <> 0
750: -- start of cua
751: and not exists ( select 'x' from fa_books bks
752: where bks.book_type_code = Book
753: and bks.asset_id = aj.asset_id
754: and bks.group_asset_id is not null
755: 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 1008: fa_books bk,

1004: AJ.Adjustment_Amount)
1005: FROM
1006: FA_LOOKUPS RT,
1007: FA_ADJUSTMENTS AJ,
1008: fa_books bk,
1009: fa_group_asset_default gad
1010:
1011: /* SLA Changes */
1012: ,xla_ae_headers headers

Line 1021: and aj.asset_id in (select asset_id from fa_books

1017: and bk.book_type_code = book
1018: and bk.group_asset_id = gad.group_asset_id
1019: and bk.book_type_code = gad.book_type_code
1020: and bk.date_ineffective is null
1021: and aj.asset_id in (select asset_id from fa_books
1022: where group_asset_id is not null
1023: and date_ineffective is null)
1024: and
1025: 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 1239: FA_BOOKS BK

1235: FA_DISTRIBUTION_HISTORY DH,
1236: FA_DEPRN_DETAIL DD,
1237: FA_ASSET_HISTORY AH,
1238: FA_CATEGORY_BOOKS CB,
1239: FA_BOOKS BK
1240: WHERE
1241: DH.Book_Type_Code = Distribution_Source_Book AND
1242: DECODE(DD.Deprn_Source_Code, 'D', P_Date,
1243: A_Date) BETWEEN

Line 1333: FA_BOOKS BK

1329: FA_DISTRIBUTION_HISTORY DH,
1330: FA_DEPRN_DETAIL DD,
1331: FA_ASSET_HISTORY AH,
1332: FA_CATEGORY_BOOKS CB,
1333: FA_BOOKS BK
1334: WHERE
1335: DH.Book_Type_Code = Distribution_Source_Book AND
1336: DECODE(DD.Deprn_Source_Code, 'D', P_Date,
1337: 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 1524: FA_BOOKS BK

1520: FA_DISTRIBUTION_HISTORY DH,
1521: FA_DEPRN_DETAIL DD,
1522: FA_ASSET_HISTORY AH,
1523: FA_CATEGORY_BOOKS CB,
1524: FA_BOOKS BK
1525: WHERE
1526: DH.Book_Type_Code = Distribution_Source_Book AND
1527: DECODE(DD.Deprn_Source_Code, 'D', P_Date,
1528: 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 1772: FA_BOOKS BK,

1768: 'CIP COST', DD.Cost,
1769: 'RESERVE', DD.Deprn_Reserve,
1770: 'REVAL RESERVE', DD.Reval_Reserve)
1771: FROM
1772: FA_BOOKS BK,
1773: FA_CATEGORY_BOOKS CB,
1774: FA_ASSET_HISTORY AH,
1775: FA_DEPRN_DETAIL DD,
1776: FA_DISTRIBUTION_HISTORY DH,

Line 1823: = ( select min(fab.transaction_header_id_in) from fa_books_groups bg, fa_books fab

1819: BK.Book_Type_Code = Book AND
1820: BK.Asset_ID = DD.Asset_ID AND
1821: -- Commented by Prabakar
1822: ( bk.transaction_header_id_in
1823: = ( select min(fab.transaction_header_id_in) from fa_books_groups bg, fa_books fab
1824: where bg.group_asset_id = nvl(bk.group_asset_id,-2)
1825: and bg.book_type_code = fab.book_type_code
1826: and fab.transaction_header_id_in <= bg.transaction_header_id_in
1827: 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

Line 2106: FA_BOOKS BK,

2102: 'CIP COST', DD.Cost,
2103: 'RESERVE', DD.Deprn_Reserve,
2104: 'REVAL RESERVE', DD.Reval_Reserve)
2105: FROM
2106: FA_BOOKS BK,
2107: FA_CATEGORY_BOOKS CB,
2108: FA_ASSET_HISTORY AH,
2109: FA_DEPRN_DETAIL DD,
2110: FA_DISTRIBUTION_HISTORY DH,

Line 2156: = ( select min(fab.transaction_header_id_in) from fa_books_groups bg, fa_books fab

2152: BK.Book_Type_Code = Book AND
2153: BK.Asset_ID = DD.Asset_ID AND
2154: -- Commented by Prabakar
2155: ( bk.transaction_header_id_in
2156: = ( select min(fab.transaction_header_id_in) from fa_books_groups bg, fa_books fab
2157: where bg.group_asset_id = nvl(bk.group_asset_id,-2)
2158: and bg.book_type_code = fab.book_type_code
2159: and fab.transaction_header_id_in <= bg.transaction_header_id_in
2160: and nvl(fab.transaction_header_id_out,bg.transaction_header_id_in) >= bg.transaction_header_id_in