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_GROUPS

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