DBA Data[Home] [Help]

APPS.FA_MASSADD_CREATE_PKG dependencies on FA_CATEGORIES_B

Line 465: from fa_categories_b c

461: and p_def_dpis_dt between CBD.start_DPIS(+)
462: and nvl(CBD.end_DPIS(+),p_def_dpis_dt)),
463: inventorial =
464: (select nvl(inventorial, 'YES')
465: from fa_categories_b c
466: where c.category_id(+) = gt.asset_category_id)
467: where gt.book_type_code = p_book_type_code
468: and gt.line_status like 'VALID%'
469: and gt.asset_category_id is not null;