DBA Data[Home] [Help]

APPS.FA_FASRSVED_XMLP_PKG dependencies on FA_BOOKS_GROUPS_MRC_V

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