VIEW: APPS.FEM_MONTHLY_ACCRUAL_BASIS_VL

Source

View Text - Preformatted

SELECT B.ACCRUAL_BASIS_ID,B.ACCRUAL_BASIS_DISPLAY_CODE,B.ENABLED_FLAG,B.PERSONAL_FLAG,B.READ_ONLY_FLAG,B.CREATION_DATE,B.CREATED_BY,B.LAST_UPDATED_BY,B.LAST_UPDATE_DATE,B.LAST_UPDATE_LOGIN,B.OBJECT_VERSION_NUMBER,T.ACCRUAL_BASIS_NAME,T.DESCRIPTION FROM FEM_ACCRUAL_BASIS_B B,FEM_ACCRUAL_BASIS_TL T,FEM_ACCRUAL_BASIS_ATTR A WHERE B.accrual_basis_id = T.accrual_basis_id AND B.accrual_basis_id = A.accrual_basis_id AND T.language = USERENV('LANG') AND A.attribute_id = (SELECT attribute_id FROM fem_dim_attributes_b WHERE attribute_varchar_label = 'MONTHLY_ACCRUAL_BASIS_FLAG' AND dimension_id = (SELECT dimension_id FROM fem_dimensions_b WHERE dimension_varchar_label = 'ACCRUAL_BASIS')) AND A.version_id = (SELECT version_id FROM fem_dim_attr_versions_b WHERE attribute_id = (SELECT attribute_id FROM fem_dim_attributes_b WHERE attribute_varchar_label = 'MONTHLY_ACCRUAL_BASIS_FLAG' AND dimension_id = (SELECT dimension_id FROM fem_dimensions_b WHERE dimension_varchar_label = 'ACCRUAL_BASIS')) AND default_version_flag = 'Y') AND A.dim_attribute_varchar_member = 'Y'

View Text - HTML Formatted

SELECT B.ACCRUAL_BASIS_ID
, B.ACCRUAL_BASIS_DISPLAY_CODE
, B.ENABLED_FLAG
, B.PERSONAL_FLAG
, B.READ_ONLY_FLAG
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, T.ACCRUAL_BASIS_NAME
, T.DESCRIPTION
FROM FEM_ACCRUAL_BASIS_B B
, FEM_ACCRUAL_BASIS_TL T
, FEM_ACCRUAL_BASIS_ATTR A
WHERE B.ACCRUAL_BASIS_ID = T.ACCRUAL_BASIS_ID
AND B.ACCRUAL_BASIS_ID = A.ACCRUAL_BASIS_ID
AND T.LANGUAGE = USERENV('LANG')
AND A.ATTRIBUTE_ID = (SELECT ATTRIBUTE_ID
FROM FEM_DIM_ATTRIBUTES_B
WHERE ATTRIBUTE_VARCHAR_LABEL = 'MONTHLY_ACCRUAL_BASIS_FLAG'
AND DIMENSION_ID = (SELECT DIMENSION_ID
FROM FEM_DIMENSIONS_B
WHERE DIMENSION_VARCHAR_LABEL = 'ACCRUAL_BASIS'))
AND A.VERSION_ID = (SELECT VERSION_ID
FROM FEM_DIM_ATTR_VERSIONS_B
WHERE ATTRIBUTE_ID = (SELECT ATTRIBUTE_ID
FROM FEM_DIM_ATTRIBUTES_B
WHERE ATTRIBUTE_VARCHAR_LABEL = 'MONTHLY_ACCRUAL_BASIS_FLAG'
AND DIMENSION_ID = (SELECT DIMENSION_ID
FROM FEM_DIMENSIONS_B
WHERE DIMENSION_VARCHAR_LABEL = 'ACCRUAL_BASIS'))
AND DEFAULT_VERSION_FLAG = 'Y')
AND A.DIM_ATTRIBUTE_VARCHAR_MEMBER = 'Y'