oracle ebs fah,EBS 资产方面的查询SQL

-----------成本中心段

select v.flex_value, v.description

from fnd_id_flex_segments_vl f,--------弹性域段----------------弹性域

fnd_flex_values_vl      v,-----弹性域值集的值---------弹性域值

gl_code_combinations    gcc----------帐户组合定义

where f.id_flex_code = 'GL#'-------GL# 加个#号，表示弹性域

and f.application_column_name='SEGMENT2'

and v.flex_value_set_id = f.flex_value_set_id

and gcc.code_combination_id = 97968

and gcc.segment2 = v.flex_value

-----------------------------------------地点查询

SELECT V1.FLEX_VALUE,

V1.DESCRIPTION,

V2.FLEX_VALUE,

V2.DESCRIPTION,

V3.FLEX_VALUE,

V3.DESCRIPTION

FROM FND_ID_FLEXS      FIF,--------弹性域

FND_ID_FLEX_SEGMENTS_VL f1,------弹性域段--------

FND_ID_FLEX_SEGMENTS_VL f2,------弹性域段--------

FND_ID_FLEX_SEGMENTS_VL f3,------弹性域段--------

FND_FLEX_VALUES_VL      V1,-----弹性域值集的值------

FND_FLEX_VALUES_VL      V2,-----弹性域值集的值------

FND_FLEX_VALUES_VL      V3,-----弹性域值集的值------

FA_LOCATIONS            L-----地点

where FIF.ID_FLEX_CODE = 'LOC#'----------------加个# 号，表示弹性域-----地点弹性域

AND FIF.ID_FLEX_CODE=F1.ID_FLEX_CODE

and F1.APPLICATION_COLUMN_NAME = 'SEGMENT1'

AND F1.FLEX_VALUE_SET_ID = V1.FLEX_VALUE_SET_ID

AND FIF.ID_FLEX_CODE=F2.ID_FLEX_CODE

AND F2.APPLICATION_COLUMN_NAME = 'SEGMENT2'

AND F2.FLEX_VALUE_SET_ID = V2.FLEX_VALUE_SET_ID

AND FIF.ID_FLEX_CODE=F3.ID_FLEX_CODE

AND F3.APPLICATION_COLUMN_NAME = 'SEGMENT3'

AND F3.FLEX_VALUE_SET_ID = V3