VIEW: APPS.XLA_DESCRIPTIONS_FVL

Source

View Text - Preformatted

SELECT b.rowid row_id ,b.application_id application_id ,x.application_name application_name ,b.amb_context_code amb_context_code ,b.description_type_code description_type_code ,l.meaning description_type_code_dsp ,b.description_code description_code ,t.name name ,t.description description ,b.transaction_coa_id transaction_coa_id ,b.enabled_flag enabled_flag ,f.id_flex_structure_name transaction_coa_name ,b.creation_date creation_date ,b.created_by created_by ,b.last_update_date last_update_date ,b.last_updated_by last_updated_by ,b.last_update_login last_update_login FROM xla_descriptions_b b ,xla_descriptions_tl t ,xla_lookups l ,fnd_id_flex_structures_v f ,xla_applications_xvl x WHERE b.application_id = t.application_id AND b.amb_context_code = t.amb_context_code AND b.description_type_code = t.description_type_code AND b.description_code = t.description_code AND t.LANGUAGE = USERENV('LANG') AND b.description_type_code = l.lookup_code AND l.lookup_type = 'XLA_OWNER_TYPE' AND b.transaction_coa_id = f.id_flex_num(+) AND f.id_flex_code(+) = 'GL#' AND f.application_id(+) = 101 AND b.application_id = x.application_id

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.APPLICATION_ID APPLICATION_ID
, X.APPLICATION_NAME APPLICATION_NAME
, B.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, B.DESCRIPTION_TYPE_CODE DESCRIPTION_TYPE_CODE
, L.MEANING DESCRIPTION_TYPE_CODE_DSP
, B.DESCRIPTION_CODE DESCRIPTION_CODE
, T.NAME NAME
, T.DESCRIPTION DESCRIPTION
, B.TRANSACTION_COA_ID TRANSACTION_COA_ID
, B.ENABLED_FLAG ENABLED_FLAG
, F.ID_FLEX_STRUCTURE_NAME TRANSACTION_COA_NAME
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_DESCRIPTIONS_B B
, XLA_DESCRIPTIONS_TL T
, XLA_LOOKUPS L
, FND_ID_FLEX_STRUCTURES_V F
, XLA_APPLICATIONS_XVL X
WHERE B.APPLICATION_ID = T.APPLICATION_ID
AND B.AMB_CONTEXT_CODE = T.AMB_CONTEXT_CODE
AND B.DESCRIPTION_TYPE_CODE = T.DESCRIPTION_TYPE_CODE
AND B.DESCRIPTION_CODE = T.DESCRIPTION_CODE
AND T.LANGUAGE = USERENV('LANG')
AND B.DESCRIPTION_TYPE_CODE = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND B.TRANSACTION_COA_ID = F.ID_FLEX_NUM(+)
AND F.ID_FLEX_CODE(+) = 'GL#'
AND F.APPLICATION_ID(+) = 101
AND B.APPLICATION_ID = X.APPLICATION_ID