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

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

738: AND
739: (DECODE (RT.Lookup_Code, AJ.Adjustment_Type, 1, 0) *
740: AJ.Adjustment_Amount) <> 0
741: -- start of cua
742: and not exists ( select 'x' from fa_books bks
743: where bks.book_type_code = Book
744: and bks.asset_id = aj.asset_id
745: and bks.group_asset_id is not null
746: 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 1005: fa_books bk,

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

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

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

1240: FA_DISTRIBUTION_HISTORY DH,
1241: FA_DEPRN_DETAIL DD,
1242: FA_ASSET_HISTORY AH,
1243: FA_CATEGORY_BOOKS CB,
1244: FA_BOOKS BK
1245: WHERE
1246: DH.Book_Type_Code = Distribution_Source_Book AND
1247: DECODE(DD.Deprn_Source_Code, 'D', P_Date,
1248: A_Date) BETWEEN

Line 1338: FA_BOOKS BK

1334: FA_DISTRIBUTION_HISTORY DH,
1335: FA_DEPRN_DETAIL DD,
1336: FA_ASSET_HISTORY AH,
1337: FA_CATEGORY_BOOKS CB,
1338: FA_BOOKS BK
1339: WHERE
1340: DH.Book_Type_Code = Distribution_Source_Book AND
1341: DECODE(DD.Deprn_Source_Code, 'D', P_Date,
1342: 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 1529: FA_BOOKS BK

1525: FA_DISTRIBUTION_HISTORY DH,
1526: FA_DEPRN_DETAIL DD,
1527: FA_ASSET_HISTORY AH,
1528: FA_CATEGORY_BOOKS CB,
1529: FA_BOOKS BK
1530: WHERE
1531: DH.Book_Type_Code = Distribution_Source_Book AND
1532: DECODE(DD.Deprn_Source_Code, 'D', P_Date,
1533: 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 1783: FA_BOOKS BK,

1779: 'CIP COST', DD.Cost,
1780: 'RESERVE', DD.Deprn_Reserve,
1781: 'REVAL RESERVE', DD.Reval_Reserve)
1782: FROM
1783: FA_BOOKS BK,
1784: FA_CATEGORY_BOOKS CB,
1785: FA_ASSET_HISTORY AH,
1786: FA_DEPRN_DETAIL DD,
1787: FA_DISTRIBUTION_HISTORY DH,

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

1830: BK.Book_Type_Code = Book AND
1831: BK.Asset_ID = DD.Asset_ID AND
1832: -- Commented by Prabakar
1833: ( bk.transaction_header_id_in
1834: = ( select min(fab.transaction_header_id_in) from fa_books_groups bg, fa_books fab
1835: where bg.group_asset_id = nvl(bk.group_asset_id,-2)
1836: and bg.book_type_code = fab.book_type_code
1837: and fab.transaction_header_id_in <= bg.transaction_header_id_in
1838: 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

Line 2126: FA_BOOKS BK,

2122: 'CIP COST', DD.Cost,
2123: 'RESERVE', DD.Deprn_Reserve,
2124: 'REVAL RESERVE', DD.Reval_Reserve)
2125: FROM
2126: FA_BOOKS BK,
2127: FA_CATEGORY_BOOKS CB,
2128: FA_ASSET_HISTORY AH,
2129: FA_DEPRN_DETAIL DD,
2130: FA_DISTRIBUTION_HISTORY DH,

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

2172: BK.Book_Type_Code = Book AND
2173: BK.Asset_ID = DD.Asset_ID AND
2174: -- Commented by Prabakar
2175: ( bk.transaction_header_id_in
2176: = ( select min(fab.transaction_header_id_in) from fa_books_groups bg, fa_books fab
2177: where bg.group_asset_id = nvl(bk.group_asset_id,-2)
2178: and bg.book_type_code = fab.book_type_code
2179: and fab.transaction_header_id_in <= bg.transaction_header_id_in
2180: and nvl(fab.transaction_header_id_out,bg.transaction_header_id_in) >= bg.transaction_header_id_in