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

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

720: AND
721: (DECODE (RT.Lookup_Code, AJ.Adjustment_Type, 1, 0) *
722: AJ.Adjustment_Amount) <> 0
723: -- start of cua
724: and not exists ( select 'x' from fa_books bks
725: where bks.book_type_code = Book
726: and bks.asset_id = aj.asset_id
727: and bks.group_asset_id is not null
728: 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 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 1212: FA_BOOKS BK

1208: FA_DISTRIBUTION_HISTORY DH,
1209: FA_DEPRN_DETAIL DD,
1210: FA_ASSET_HISTORY AH,
1211: FA_CATEGORY_BOOKS CB,
1212: FA_BOOKS BK
1213: WHERE
1214: DH.Book_Type_Code = Distribution_Source_Book AND
1215: DECODE(DD.Deprn_Source_Code, 'D', P_Date,
1216: A_Date) BETWEEN

Line 1306: FA_BOOKS BK

1302: FA_DISTRIBUTION_HISTORY DH,
1303: FA_DEPRN_DETAIL DD,
1304: FA_ASSET_HISTORY AH,
1305: FA_CATEGORY_BOOKS CB,
1306: FA_BOOKS BK
1307: WHERE
1308: DH.Book_Type_Code = Distribution_Source_Book AND
1309: DECODE(DD.Deprn_Source_Code, 'D', P_Date,
1310: 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 1497: FA_BOOKS BK

1493: FA_DISTRIBUTION_HISTORY DH,
1494: FA_DEPRN_DETAIL DD,
1495: FA_ASSET_HISTORY AH,
1496: FA_CATEGORY_BOOKS CB,
1497: FA_BOOKS BK
1498: WHERE
1499: DH.Book_Type_Code = Distribution_Source_Book AND
1500: DECODE(DD.Deprn_Source_Code, 'D', P_Date,
1501: 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 1745: FA_BOOKS BK,

1741: 'CIP COST', DD.Cost,
1742: 'RESERVE', DD.Deprn_Reserve,
1743: 'REVAL RESERVE', DD.Reval_Reserve)
1744: FROM
1745: FA_BOOKS BK,
1746: FA_CATEGORY_BOOKS CB,
1747: FA_ASSET_HISTORY AH,
1748: FA_DEPRN_DETAIL DD,
1749: FA_DISTRIBUTION_HISTORY DH,

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

1792: BK.Book_Type_Code = Book AND
1793: BK.Asset_ID = DD.Asset_ID AND
1794: -- Commented by Prabakar
1795: ( bk.transaction_header_id_in
1796: = ( select min(fab.transaction_header_id_in) from fa_books_groups bg, fa_books fab
1797: where bg.group_asset_id = nvl(bk.group_asset_id,-2)
1798: and bg.book_type_code = fab.book_type_code
1799: and fab.transaction_header_id_in <= bg.transaction_header_id_in
1800: 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

Line 2079: FA_BOOKS BK,

2075: 'CIP COST', DD.Cost,
2076: 'RESERVE', DD.Deprn_Reserve,
2077: 'REVAL RESERVE', DD.Reval_Reserve)
2078: FROM
2079: FA_BOOKS BK,
2080: FA_CATEGORY_BOOKS CB,
2081: FA_ASSET_HISTORY AH,
2082: FA_DEPRN_DETAIL DD,
2083: FA_DISTRIBUTION_HISTORY DH,

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

2125: BK.Book_Type_Code = Book AND
2126: BK.Asset_ID = DD.Asset_ID AND
2127: -- Commented by Prabakar
2128: ( bk.transaction_header_id_in
2129: = ( select min(fab.transaction_header_id_in) from fa_books_groups bg, fa_books fab
2130: where bg.group_asset_id = nvl(bk.group_asset_id,-2)
2131: and bg.book_type_code = fab.book_type_code
2132: and fab.transaction_header_id_in <= bg.transaction_header_id_in
2133: and nvl(fab.transaction_header_id_out,bg.transaction_header_id_in) >= bg.transaction_header_id_in