DBA Data[Home] [Help]

APPS.FA_FASRSVES_XMLP_PKG dependencies on FA_BOOKS_GROUPS_MRC_V

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