eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.XLA_SOURCES_FVL

Source

View Text - Preformatted


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

View Text - HTML Formatted

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