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_GROUPS

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