DBA Data[Home] [Help]

APPS.FA_FASCOSTD_XMLP_PKG dependencies on FA_BOOKS_GROUPS_MRC_V

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