ECC Assets, Reconciliation (1)

select
x.*
from
(
select * from ((SELECT fnd_ecc_kff_util.get_vset_values_kff('CAT#','CATEGORY_FLEXFIELD','SEGMENT1',kfv."SEGMENT1",1002485, NULL ,NULL,140,rec_v.language)  "BASED_CATEGORY",fnd_ecc_kff_util.get_vset_values_kff('CAT#','CATEGORY_FLEXFIELD','SEGMENT2',kfv."SEGMENT2",1002486,kfv.SEGMENT1,NULL ,140,rec_v.language)  "MINOR_CATEGORY",kfv.SEGMENT1  "BASED_CATEGORY_CODE",kfv.SEGMENT2  "MINOR_CATEGORY_CODE" , rec_v.* FROM FA_ECC_F_REC_V rec_v , FA_CATEGORIES_B_KFV kfv where rec_v.language in ('US')
                                                   AND rec_v.asset_category_id = kfv.category_id
                                                  )
                                       PIVOT (MAX( "BASED_CATEGORY") AS  "BASED_CATEGORY",MAX( "MINOR_CATEGORY") AS  "MINOR_CATEGORY" ,
                                              max(ACCT_LINE_TYPE_NAME) as ACCT_LINE_TYPE_NAME,
                                              max(AE_LINE_REFERENCE) as AE_LINE_REFERENCE,
                                              max(ASSET_DESCRIPTION) as ASSET_DESCRIPTION,
                                              max(GL_TRANSFER_STATUS_NAME) as GL_TRANSFER_STATUS_NAME,
                                              max(CURRENCY) as CURRENCY,
                                              max(XLA_BALANCE_TYPE) as XLA_BALANCE_TYPE,
                                              MAX(ACCOUNTING_ENTRY_STATUS) AS ACCOUNTING_ENTRY_STATUS,
                                              MAX(XLA_GL_TRANSFER_STATUS) AS XLA_GL_TRANSFER_STATUS,
                                              max(JE_SOURCE_NAME) as JE_SOURCE_NAME,
                                              max(JE_CATEGORY_NAME) as JE_CATEGORY_NAME
                                       for LANGUAGE in ('US' "US")))
) x
where
2=2