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_GROUPS

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