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_GROUPS

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 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 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 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