DBA Data[Home] [Help]

APPS.FA_FASCOSTS_XMLP_PKG dependencies on FA_BOOKS_GROUPS_MRC_V

Line 1707: = ( select min(fab.transaction_header_id_in) from fa_books_groups_mrc_v bg, fa_books_mrc_v fab

1703: BK.Book_Type_Code = Book AND
1704: BK.Asset_ID = DD.Asset_ID AND
1705: -- Commented by Prabakar
1706: ( bk.transaction_header_id_in
1707: = ( select min(fab.transaction_header_id_in) from fa_books_groups_mrc_v bg, fa_books_mrc_v fab
1708: where bg.group_asset_id = nvl(bk.group_asset_id,-2)
1709: and bg.book_type_code = fab.book_type_code
1710: and fab.transaction_header_id_in <= bg.transaction_header_id_in
1711: and nvl(fab.transaction_header_id_out,bg.transaction_header_id_in) >= bg.transaction_header_id_in

Line 2052: = ( select min(fab.transaction_header_id_in) from fa_books_groups_mrc_v bg, fa_books_mrc_v fab

2048: BK.Book_Type_Code = Book AND
2049: BK.Asset_ID = DD.Asset_ID AND
2050: -- Commented by Prabakar
2051: ( bk.transaction_header_id_in
2052: = ( select min(fab.transaction_header_id_in) from fa_books_groups_mrc_v bg, fa_books_mrc_v fab
2053: where bg.group_asset_id = nvl(bk.group_asset_id,-2)
2054: and bg.book_type_code = fab.book_type_code
2055: and fab.transaction_header_id_in <= bg.transaction_header_id_in
2056: and nvl(fab.transaction_header_id_out,bg.transaction_header_id_in) >= bg.transaction_header_id_in