OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » which table stores, segment qualifiers in key flexfiled values

Home » Applications » Oracle Fusion Apps & E-Business Suite » which table stores, segment qualifiers in key flexfiled values (r12.1.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

which table stores, segment qualifiers in key flexfiled values [message #653075]

Mon, 27 June 2016 00:42

m_shehpar
Messages: 73
Registered: October 2010
Location: Pakistan

Member

Hi all,

Can somebody help / guide me, which table stores segment qualifiers in key flexfiled values (Asset, Liability, Revenue, Owner Equity etc..). Please modify the below query for me. (snap of the GL account from the application is attached to the message !)

SELECT fvs.FLEX_VALUE_SET_NAME
      ,FVL.DESCRIPTION
      ,null ACCOUNT_TYPE        -------------   ????
FROM   FND_ID_FLEX_STRUCTURES_VL FST
      ,FND_ID_FLEX_SEGMENTS      FSEG
      ,FND_FLEX_VALUE_SETS       FVS
      ,FND_FLEX_VALUES_VL        FVL
WHERE FST.ID_FLEX_NUM        = FSEG.ID_FLEX_NUM
  AND FSEG.FLEX_VALUE_SET_ID = FVS.FLEX_VALUE_SET_ID
  AND FVL.FLEX_VALUE_SET_ID  = FVS.FLEX_VALUE_SET_ID      
  and FVL.ENABLED_FLAG       = 'Y'
  and FVL.END_DATE_ACTIVE   is null
  AND FST.APPLICATION_ID     = 101
  AND FST.ID_FLEX_CODE       = 'GL#'
  and FSEG.ID_FLEX_CODE      = 'GL#'
  and FSEG.SEGMENT_NAME      = 'Natural Account'
  AND FVL.FLEX_VALUE = '21010100'