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

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

714: AND
715: (DECODE (RT.Lookup_Code, AJ.Adjustment_Type, 1, 0) *
716: AJ.Adjustment_Amount) <> 0
717: -- start of cua
718: and not exists ( select 'x' from fa_books bks
719: where bks.book_type_code = Book
720: and bks.asset_id = aj.asset_id
721: and bks.group_asset_id is not null
722: 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 981: fa_books bk,

977: AJ.Adjustment_Amount)
978: FROM
979: FA_LOOKUPS RT,
980: FA_ADJUSTMENTS AJ,
981: fa_books bk,
982: fa_group_asset_default gad
983:
984: /* SLA Changes */
985: ,xla_ae_headers headers

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

990: and bk.book_type_code = book
991: and bk.group_asset_id = gad.group_asset_id
992: and bk.book_type_code = gad.book_type_code
993: and bk.date_ineffective is null
994: and aj.asset_id in (select asset_id from fa_books
995: where group_asset_id is not null
996: and date_ineffective is null)
997: and
998: 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 1220: FA_BOOKS BK

1216: FA_DISTRIBUTION_HISTORY DH,
1217: FA_DEPRN_DETAIL DD,
1218: FA_ASSET_HISTORY AH,
1219: FA_CATEGORY_BOOKS CB,
1220: FA_BOOKS BK
1221: WHERE
1222: DH.Book_Type_Code = Distribution_Source_Book AND
1223: DECODE(DD.Deprn_Source_Code, 'D', P_Date,
1224: A_Date) BETWEEN

Line 1314: FA_BOOKS BK

1310: FA_DISTRIBUTION_HISTORY DH,
1311: FA_DEPRN_DETAIL DD,
1312: FA_ASSET_HISTORY AH,
1313: FA_CATEGORY_BOOKS CB,
1314: FA_BOOKS BK
1315: WHERE
1316: DH.Book_Type_Code = Distribution_Source_Book AND
1317: DECODE(DD.Deprn_Source_Code, 'D', P_Date,
1318: 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 1505: FA_BOOKS BK

1501: FA_DISTRIBUTION_HISTORY DH,
1502: FA_DEPRN_DETAIL DD,
1503: FA_ASSET_HISTORY AH,
1504: FA_CATEGORY_BOOKS CB,
1505: FA_BOOKS BK
1506: WHERE
1507: DH.Book_Type_Code = Distribution_Source_Book AND
1508: DECODE(DD.Deprn_Source_Code, 'D', P_Date,
1509: 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 1759: FA_BOOKS BK,

1755: 'CIP COST', DD.Cost,
1756: 'RESERVE', DD.Deprn_Reserve,
1757: 'REVAL RESERVE', DD.Reval_Reserve)
1758: FROM
1759: FA_BOOKS BK,
1760: FA_CATEGORY_BOOKS CB,
1761: FA_ASSET_HISTORY AH,
1762: FA_DEPRN_DETAIL DD,
1763: FA_DISTRIBUTION_HISTORY DH,

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

1806: BK.Book_Type_Code = Book AND
1807: BK.Asset_ID = DD.Asset_ID AND
1808: -- Commented by Prabakar
1809: ( bk.transaction_header_id_in
1810: = ( select min(fab.transaction_header_id_in) from fa_books_groups bg, fa_books fab
1811: where bg.group_asset_id = nvl(bk.group_asset_id,-2)
1812: and bg.book_type_code = fab.book_type_code
1813: and fab.transaction_header_id_in <= bg.transaction_header_id_in
1814: 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

Line 2102: FA_BOOKS BK,

2098: 'CIP COST', DD.Cost,
2099: 'RESERVE', DD.Deprn_Reserve,
2100: 'REVAL RESERVE', DD.Reval_Reserve)
2101: FROM
2102: FA_BOOKS BK,
2103: FA_CATEGORY_BOOKS CB,
2104: FA_ASSET_HISTORY AH,
2105: FA_DEPRN_DETAIL DD,
2106: FA_DISTRIBUTION_HISTORY DH,

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

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