Product: | XLA - Subledger Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XLA_SOURCES_FVL |
SELECT SRB.ROWID ROW_ID
, SRB.APPLICATION_ID APPLICATION_ID
, APL.APPLICATION_NAME APPLICATION_NAME
, SRB.SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, SRB.SOURCE_CODE SOURCE_CODE
, SRL.NAME NAME
, SRL.DESCRIPTION DESCRIPTION
, SRB.ENABLED_FLAG ENABLED_FLAG
, SRB.DATATYPE_CODE DATATYPE_CODE
, SRB.PLSQL_FUNCTION_NAME PLSQL_FUNCTION_NAME
, SRB.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, VAL.FLEX_VALUE_SET_NAME FLEX_VALUE_SET_NAME
, SRB.VISIBLE_FLAG VISIBLE_FLAG
, SRB.SUM_FLAG SUM_FLAG
, SRB.TRANSLATED_FLAG TRANSLATED_FLAG
, SRB.VIEW_APPLICATION_ID VIEW_APPLICATION_ID
, APL1.APPLICATION_NAME VIEW_APPLICATION_NAME
, SRB.LOOKUP_TYPE LOOKUP_TYPE
, LKP.MEANING LOOKUP_TYPE_MEANING
, SRB.FLEXFIELD_APPLICATION_ID FLEXFIELD_APPLICATION_ID
, APL2.APPLICATION_NAME FLEXFIELD_APPLICATION_NAME
, SRB.ID_FLEX_CODE ID_FLEX_CODE
, FLX.ID_FLEX_NAME ID_FLEX_NAME
, SRB.KEY_FLEXFIELD_FLAG KEY_FLEXFIELD_FLAG
, SRB.SEGMENT_CODE SEGMENT_CODE
, SAT.SEGMENT_PROMPT SEGMENT_NAME
, SRB.CREATION_DATE CREATION_DATE
, SRB.CREATED_BY CREATED_BY
, SRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SRB.LAST_UPDATED_BY LAST_UPDATED_BY
, SRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM XLA_SOURCES_B SRB
, XLA_SOURCES_TL SRL
, FND_APPLICATION_TL APL
, FND_FLEX_VALUE_SETS VAL
, FND_APPLICATION_TL APL1
, FND_APPLICATION_TL APL2
, FND_LOOKUP_TYPES_TL LKP
, FND_ID_FLEXS FLX
, FND_SEGMENT_ATTRIBUTE_TYPES SAT
WHERE SRB.APPLICATION_ID = SRL.APPLICATION_ID
AND SRB.SOURCE_TYPE_CODE = SRL.SOURCE_TYPE_CODE
AND SRB.SOURCE_CODE = SRL.SOURCE_CODE
AND SRL.LANGUAGE = USERENV('LANG')
AND SRB.APPLICATION_ID = APL.APPLICATION_ID
AND APL.LANGUAGE = USERENV('LANG')
AND SRB.FLEX_VALUE_SET_ID = VAL.FLEX_VALUE_SET_ID(+)
AND SRB.VIEW_APPLICATION_ID = APL1.APPLICATION_ID(+)
AND APL1.LANGUAGE (+) = USERENV('LANG')
AND SRB.VIEW_APPLICATION_ID = LKP.VIEW_APPLICATION_ID(+)
AND SRB.LOOKUP_TYPE = LKP.LOOKUP_TYPE(+)
AND LKP.LANGUAGE (+) = USERENV('LANG')
AND SRB.FLEXFIELD_APPLICATION_ID = APL2.APPLICATION_ID(+)
AND APL2.LANGUAGE (+) = USERENV('LANG')
AND SRB.FLEXFIELD_APPLICATION_ID = FLX.APPLICATION_ID (+)
AND SRB.ID_FLEX_CODE = FLX.ID_FLEX_CODE (+)
AND SRB.SEGMENT_CODE = SAT.SEGMENT_ATTRIBUTE_TYPE
AND SAT.APPLICATION_ID = 101
AND SAT.ID_FLEX_CODE = 'GL#'
AND SRB.SEGMENT_CODE IN ('GL_BALANCING'
, 'GL_ACCOUNT'
, 'GL_MANAGEMENT'
, 'GL_INTERCOMPANY'
, 'FA_COST_CTR') UNION SELECT SRB.ROWID ROW_ID
, SRB.APPLICATION_ID APPLICATION_ID
, APL.APPLICATION_NAME APPLICATION_NAME
, SRB.SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, SRB.SOURCE_CODE SOURCE_CODE
, SRL.NAME NAME
, SRL.DESCRIPTION DESCRIPTION
, SRB.ENABLED_FLAG ENABLED_FLAG
, SRB.DATATYPE_CODE DATATYPE_CODE
, SRB.PLSQL_FUNCTION_NAME PLSQL_FUNCTION_NAME
, SRB.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, VAL.FLEX_VALUE_SET_NAME FLEX_VALUE_SET_NAME
, SRB.VISIBLE_FLAG VISIBLE_FLAG
, SRB.SUM_FLAG SUM_FLAG
, SRB.TRANSLATED_FLAG TRANSLATED_FLAG
, SRB.VIEW_APPLICATION_ID VIEW_APPLICATION_ID
, APL1.APPLICATION_NAME VIEW_APPLICATION_NAME
, SRB.LOOKUP_TYPE LOOKUP_TYPE
, LKP.MEANING LOOKUP_TYPE_MEANING
, SRB.FLEXFIELD_APPLICATION_ID FLEXFIELD_APPLICATION_ID
, APL2.APPLICATION_NAME FLEXFIELD_APPLICATION_NAME
, SRB.ID_FLEX_CODE ID_FLEX_CODE
, FLX.ID_FLEX_NAME ID_FLEX_NAME
, SRB.KEY_FLEXFIELD_FLAG KEY_FLEXFIELD_FLAG
, SRB.SEGMENT_CODE SEGMENT_CODE
, LKP1.MEANING SEGMENT_NAME
, SRB.CREATION_DATE CREATION_DATE
, SRB.CREATED_BY CREATED_BY
, SRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SRB.LAST_UPDATED_BY LAST_UPDATED_BY
, SRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM XLA_SOURCES_B SRB
, XLA_SOURCES_TL SRL
, FND_APPLICATION_TL APL
, FND_FLEX_VALUE_SETS VAL
, FND_APPLICATION_TL APL1
, FND_APPLICATION_TL APL2
, FND_LOOKUP_TYPES_TL LKP
, FND_ID_FLEXS FLX
, XLA_LOOKUPS LKP1 WHERE SRB.APPLICATION_ID = SRL.APPLICATION_ID
AND SRB.SOURCE_TYPE_CODE = SRL.SOURCE_TYPE_CODE
AND SRB.SOURCE_CODE = SRL.SOURCE_CODE
AND SRL.LANGUAGE = USERENV('LANG')
AND SRB.APPLICATION_ID = APL.APPLICATION_ID
AND APL.LANGUAGE = USERENV('LANG')
AND SRB.FLEX_VALUE_SET_ID = VAL.FLEX_VALUE_SET_ID(+)
AND SRB.VIEW_APPLICATION_ID = APL1.APPLICATION_ID(+)
AND APL1.LANGUAGE (+) = USERENV('LANG')
AND SRB.VIEW_APPLICATION_ID = LKP.VIEW_APPLICATION_ID(+)
AND SRB.LOOKUP_TYPE = LKP.LOOKUP_TYPE(+)
AND LKP.LANGUAGE (+) = USERENV('LANG')
AND SRB.FLEXFIELD_APPLICATION_ID = APL2.APPLICATION_ID(+)
AND APL2.LANGUAGE (+) = USERENV('LANG')
AND SRB.FLEXFIELD_APPLICATION_ID = FLX.APPLICATION_ID
AND SRB.ID_FLEX_CODE = FLX.ID_FLEX_CODE
AND SRB.SEGMENT_CODE = LKP1.LOOKUP_CODE
AND LKP1.LOOKUP_TYPE = 'XLA_FLEXFIELD_SEGMENTS_QUAL'
AND SRB.SEGMENT_CODE = 'OTHER' UNION SELECT SRB.ROWID ROW_ID
, SRB.APPLICATION_ID APPLICATION_ID
, APL.APPLICATION_NAME APPLICATION_NAME
, SRB.SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, SRB.SOURCE_CODE SOURCE_CODE
, SRL.NAME NAME
, SRL.DESCRIPTION DESCRIPTION
, SRB.ENABLED_FLAG ENABLED_FLAG
, SRB.DATATYPE_CODE DATATYPE_CODE
, SRB.PLSQL_FUNCTION_NAME PLSQL_FUNCTION_NAME
, SRB.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, VAL.FLEX_VALUE_SET_NAME FLEX_VALUE_SET_NAME
, SRB.VISIBLE_FLAG VISIBLE_FLAG
, SRB.SUM_FLAG SUM_FLAG
, SRB.TRANSLATED_FLAG TRANSLATED_FLAG
, SRB.VIEW_APPLICATION_ID VIEW_APPLICATION_ID
, APL1.APPLICATION_NAME VIEW_APPLICATION_NAME
, SRB.LOOKUP_TYPE LOOKUP_TYPE
, LKP.MEANING LOOKUP_TYPE_MEANING
, SRB.FLEXFIELD_APPLICATION_ID FLEXFIELD_APPLICATION_ID
, APL2.APPLICATION_NAME FLEXFIELD_APPLICATION_NAME
, SRB.ID_FLEX_CODE ID_FLEX_CODE
, FLX.ID_FLEX_NAME ID_FLEX_NAME
, SRB.KEY_FLEXFIELD_FLAG KEY_FLEXFIELD_FLAG
, SRB.SEGMENT_CODE SEGMENT_CODE
, NULL SEGMENT_NAME
, SRB.CREATION_DATE CREATION_DATE
, SRB.CREATED_BY CREATED_BY
, SRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SRB.LAST_UPDATED_BY LAST_UPDATED_BY
, SRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM XLA_SOURCES_B SRB
, XLA_SOURCES_TL SRL
, FND_APPLICATION_TL APL
, FND_FLEX_VALUE_SETS VAL
, FND_APPLICATION_TL APL1
, FND_APPLICATION_TL APL2
, FND_LOOKUP_TYPES_TL LKP
, FND_ID_FLEXS FLX WHERE SRB.APPLICATION_ID = SRL.APPLICATION_ID
AND SRB.SOURCE_TYPE_CODE = SRL.SOURCE_TYPE_CODE
AND SRB.SOURCE_CODE = SRL.SOURCE_CODE
AND SRL.LANGUAGE = USERENV('LANG')
AND SRB.APPLICATION_ID = APL.APPLICATION_ID
AND APL.LANGUAGE = USERENV('LANG')
AND SRB.FLEX_VALUE_SET_ID = VAL.FLEX_VALUE_SET_ID(+)
AND SRB.VIEW_APPLICATION_ID = APL1.APPLICATION_ID(+)
AND APL1.LANGUAGE (+) = USERENV('LANG')
AND SRB.VIEW_APPLICATION_ID = LKP.VIEW_APPLICATION_ID(+)
AND SRB.LOOKUP_TYPE = LKP.LOOKUP_TYPE(+)
AND LKP.LANGUAGE (+) = USERENV('LANG')
AND SRB.FLEXFIELD_APPLICATION_ID = APL2.APPLICATION_ID(+)
AND APL2.LANGUAGE (+) = USERENV('LANG')
AND SRB.FLEXFIELD_APPLICATION_ID = FLX.APPLICATION_ID (+)
AND SRB.ID_FLEX_CODE = FLX.ID_FLEX_CODE (+)
AND SRB.SEGMENT_CODE IS NULL