Home » Applications » Oracle Fusion Apps & E-Business Suite » which table stores, segment qualifiers in key flexfiled values (r12.1.3)
which table stores, segment qualifiers in key flexfiled values [message #653075] Mon, 27 June 2016 00:42 Go to next message
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'

/forum/fa/13176/0/
Re: which table stores, segment qualifiers in key flexfiled values [message #654496 is a reply to message #653075] Thu, 04 August 2016 02:10 Go to previous message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Hi,

It is in fnd_flex_values_vl only.
Try to use SUBSTR(compiled_value_attributes,5,1).

By
Vamsi
Previous Topic: payment method error
Next Topic: export to tsv
Goto Forum:
  


Current Time: Thu Jun 24 14:47:48 CDT 2021