VIEW: APPS.FEM_LN_ITEMS_ATTRD_V

Source

View Text - Preformatted

SELECT b.LINE_ITEM_ID ,b.value_set_id ,b.LINE_ITEM_DISPLAY_CODE ,b.dimension_group_id ,dgb.dimension_group_display_code ,b.enabled_flag ,b.read_only_flag ,b.personal_flag ,( select adb.FLAG_CODE from FEM_FLAGS_B adb ,FEM_LN_ITEMS_ATTR attr ,fem_dim_attributes_b a ,fem_dim_attr_versions_b v WHERE adb.FLAG_CODE = attr.DIM_ATTRIBUTE_VARCHAR_MEMBER and a.dimension_id = 14 and a.attribute_varchar_label = 'BETTER_FLAG' and v.attribute_id = a.attribute_id and v.version_display_code = 'Default' and attr.attribute_id = a.attribute_id and attr.version_id = v.version_id and attr.LINE_ITEM_ID = b.LINE_ITEM_ID and attr.value_set_id = b.value_set_id) BETTER_FLAG ,( select adb.EXT_ACCOUNT_TYPE_CODE from FEM_EXT_ACCOUNT_TYPES_B adb ,FEM_LN_ITEMS_ATTR attr ,fem_dim_attributes_b a ,fem_dim_attr_versions_b v where adb.EXT_ACCOUNT_TYPE_CODE = attr.DIM_ATTRIBUTE_VARCHAR_MEMBER and a.dimension_id = 14 and a.attribute_varchar_label = 'EXTENDED_ACCOUNT_TYPE' and v.attribute_id = a.attribute_id and v.version_display_code = 'Default' and attr.attribute_id = a.attribute_id and attr.version_id = v.version_id and attr.LINE_ITEM_ID = b.LINE_ITEM_ID and attr.value_set_id = b.value_set_id) EXTENDED_ACCOUNT_TYPE ,( select ext_attr.number_assign_value from FEM_LN_ITEMS_ATTR attr ,fem_dim_attributes_b a ,fem_dim_attr_versions_b v ,fem_ext_acct_types_attr ext_attr ,fem_dim_attributes_b ext_a ,fem_dim_attr_versions_b ext_v where a.dimension_id = 14 and a.attribute_varchar_label = 'EXTENDED_ACCOUNT_TYPE' and v.attribute_id = a.attribute_id and v.version_display_code = 'Default' and attr.attribute_id = a.attribute_id and attr.version_id = v.version_id and attr.LINE_ITEM_ID = b.LINE_ITEM_ID and attr.value_set_id = b.value_set_id and ext_a.dimension_id = 32 and ext_a.attribute_varchar_label = 'SIGN' and ext_v.attribute_id = ext_a.attribute_id and ext_v.version_display_code = 'Default' and ext_attr.attribute_id = ext_a.attribute_id and ext_attr.version_id = ext_v.version_id and ext_attr.ext_account_type_code = attr.DIM_ATTRIBUTE_VARCHAR_MEMBER) EXTENDED_ACCOUNT_SIGN ,( select ext_attr.dim_attribute_varchar_member from FEM_LN_ITEMS_ATTR attr ,fem_dim_attributes_b a ,fem_dim_attr_versions_b v ,fem_ext_acct_types_attr ext_attr ,fem_dim_attributes_b ext_a ,fem_dim_attr_versions_b ext_v where a.dimension_id = 14 and a.attribute_varchar_label = 'EXTENDED_ACCOUNT_TYPE' and v.attribute_id = a.attribute_id and v.version_display_code = 'Default' and attr.attribute_id = a.attribute_id and attr.version_id = v.version_id and attr.LINE_ITEM_ID = b.LINE_ITEM_ID and attr.value_set_id = b.value_set_id and ext_a.dimension_id = 32 and ext_a.attribute_varchar_label = 'BASIC_ACCOUNT_TYPE_CODE' and ext_v.attribute_id = ext_a.attribute_id and ext_v.version_display_code = 'Default' and ext_attr.attribute_id = ext_a.attribute_id and ext_attr.version_id = ext_v.version_id and ext_attr.ext_account_type_code = attr.DIM_ATTRIBUTE_VARCHAR_MEMBER) BASIC_ACCOUNT_TYPE ,( select adb.FLAG_CODE from FEM_FLAGS_B adb ,FEM_LN_ITEMS_ATTR attr ,fem_dim_attributes_b a ,fem_dim_attr_versions_b v where adb.FLAG_CODE = attr.DIM_ATTRIBUTE_VARCHAR_MEMBER and a.dimension_id = 14 and a.attribute_varchar_label = 'RECON_LEAF_NODE_FLAG' and v.attribute_id = a.attribute_id and v.version_display_code = 'Default' and attr.attribute_id = a.attribute_id and attr.version_id = v.version_id and attr.LINE_ITEM_ID = b.LINE_ITEM_ID and attr.value_set_id = b.value_set_id) RECON_LEAF_NODE_FLAG ,( select adb.SOURCE_SYSTEM_DISPLAY_CODE from FEM_SOURCE_SYSTEMS_B adb ,FEM_LN_ITEMS_ATTR attr ,fem_dim_attributes_b a ,fem_dim_attr_versions_b v where adb.SOURCE_SYSTEM_CODE = attr.DIM_ATTRIBUTE_NUMERIC_MEMBER and a.dimension_id = 14 and a.attribute_varchar_label = 'SOURCE_SYSTEM_CODE' and v.attribute_id = a.attribute_id and v.version_display_code = 'Default' and attr.attribute_id = a.attribute_id and attr.version_id = v.version_id and attr.LINE_ITEM_ID = b.LINE_ITEM_ID and attr.value_set_id = b.value_set_id) SOURCE_SYSTEM_CODE ,( select adb.AGG_METHOD_CODE from FEM_AGG_METHODS_B adb ,FEM_LN_ITEMS_ATTR attr ,fem_dim_attributes_b a ,fem_dim_attr_versions_b v where adb.AGG_METHOD_CODE = attr.DIM_ATTRIBUTE_VARCHAR_MEMBER and a.dimension_id = 14 and a.attribute_varchar_label = 'DEFAULT_AGG_METHOD' and v.attribute_id = a.attribute_id and v.version_display_code = 'Default' and attr.attribute_id = a.attribute_id and attr.version_id = v.version_id and attr.LINE_ITEM_ID = b.LINE_ITEM_ID and attr.value_set_id = b.value_set_id) DEFAULT_AGG_METHOD ,( select attr.VARCHAR_ASSIGN_VALUE from FEM_LN_ITEMS_ATTR attr ,fem_dim_attributes_b a ,fem_dim_attr_versions_b v where a.dimension_id = 14 and a.attribute_varchar_label = 'DEFAULT_NUMBER_FORMAT' and v.attribute_id = a.attribute_id and v.version_display_code = 'Default' and attr.attribute_id = a.attribute_id and attr.version_id = v.version_id and attr.LINE_ITEM_ID = b.LINE_ITEM_ID and attr.value_set_id = b.value_set_id) DEFAULT_NUMBER_FORMAT ,( select adb.ACCRUAL_BASIS_DISPLAY_CODE from FEM_MONTHLY_ACCRUAL_BASIS_VL adb ,FEM_LN_ITEMS_ATTR attr ,fem_dim_attributes_b a ,fem_dim_attr_versions_b v where adb.ACCRUAL_BASIS_ID = attr.DIM_ATTRIBUTE_NUMERIC_MEMBER and a.dimension_id = 14 and a.attribute_varchar_label = 'MONTHLY_ACCRUAL_BASIS' and v.attribute_id = a.attribute_id and v.version_display_code = 'Default' and attr.attribute_id = a.attribute_id and attr.version_id = v.version_id and attr.LINE_ITEM_ID = b.LINE_ITEM_ID and attr.value_set_id = b.value_set_id) MONTHLY_ACCRUAL_BASIS ,( select adb.AGG_METHOD_CODE from FEM_AGG_METHODS_B adb ,FEM_LN_ITEMS_ATTR attr ,fem_dim_attributes_b a ,fem_dim_attr_versions_b v where adb.AGG_METHOD_CODE = attr.DIM_ATTRIBUTE_VARCHAR_MEMBER and a.dimension_id = 14 and a.attribute_varchar_label = 'TIME_AGG_METHOD' and v.attribute_id = a.attribute_id and v.version_display_code = 'Default' and attr.attribute_id = a.attribute_id and attr.version_id = v.version_id and attr.LINE_ITEM_ID = b.LINE_ITEM_ID and attr.value_set_id = b.value_set_id) TIME_AGG_METHOD ,b.created_by ,b.creation_date ,b.last_updated_by ,b.last_update_date ,b.last_update_login from FEM_LN_ITEMS_B b ,fem_dimension_grps_b dgb

View Text - HTML Formatted

SELECT B.LINE_ITEM_ID
, B.VALUE_SET_ID
, B.LINE_ITEM_DISPLAY_CODE
, B.DIMENSION_GROUP_ID
, DGB.DIMENSION_GROUP_DISPLAY_CODE
, B.ENABLED_FLAG
, B.READ_ONLY_FLAG
, B.PERSONAL_FLAG
, ( SELECT ADB.FLAG_CODE
FROM FEM_FLAGS_B ADB
, FEM_LN_ITEMS_ATTR ATTR
, FEM_DIM_ATTRIBUTES_B A
, FEM_DIM_ATTR_VERSIONS_B V
WHERE ADB.FLAG_CODE = ATTR.DIM_ATTRIBUTE_VARCHAR_MEMBER
AND A.DIMENSION_ID = 14
AND A.ATTRIBUTE_VARCHAR_LABEL = 'BETTER_FLAG'
AND V.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND V.VERSION_DISPLAY_CODE = 'DEFAULT'
AND ATTR.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND ATTR.VERSION_ID = V.VERSION_ID
AND ATTR.LINE_ITEM_ID = B.LINE_ITEM_ID
AND ATTR.VALUE_SET_ID = B.VALUE_SET_ID) BETTER_FLAG
, ( SELECT ADB.EXT_ACCOUNT_TYPE_CODE
FROM FEM_EXT_ACCOUNT_TYPES_B ADB
, FEM_LN_ITEMS_ATTR ATTR
, FEM_DIM_ATTRIBUTES_B A
, FEM_DIM_ATTR_VERSIONS_B V
WHERE ADB.EXT_ACCOUNT_TYPE_CODE = ATTR.DIM_ATTRIBUTE_VARCHAR_MEMBER
AND A.DIMENSION_ID = 14
AND A.ATTRIBUTE_VARCHAR_LABEL = 'EXTENDED_ACCOUNT_TYPE'
AND V.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND V.VERSION_DISPLAY_CODE = 'DEFAULT'
AND ATTR.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND ATTR.VERSION_ID = V.VERSION_ID
AND ATTR.LINE_ITEM_ID = B.LINE_ITEM_ID
AND ATTR.VALUE_SET_ID = B.VALUE_SET_ID) EXTENDED_ACCOUNT_TYPE
, ( SELECT EXT_ATTR.NUMBER_ASSIGN_VALUE
FROM FEM_LN_ITEMS_ATTR ATTR
, FEM_DIM_ATTRIBUTES_B A
, FEM_DIM_ATTR_VERSIONS_B V
, FEM_EXT_ACCT_TYPES_ATTR EXT_ATTR
, FEM_DIM_ATTRIBUTES_B EXT_A
, FEM_DIM_ATTR_VERSIONS_B EXT_V
WHERE A.DIMENSION_ID = 14
AND A.ATTRIBUTE_VARCHAR_LABEL = 'EXTENDED_ACCOUNT_TYPE'
AND V.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND V.VERSION_DISPLAY_CODE = 'DEFAULT'
AND ATTR.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND ATTR.VERSION_ID = V.VERSION_ID
AND ATTR.LINE_ITEM_ID = B.LINE_ITEM_ID
AND ATTR.VALUE_SET_ID = B.VALUE_SET_ID
AND EXT_A.DIMENSION_ID = 32
AND EXT_A.ATTRIBUTE_VARCHAR_LABEL = 'SIGN'
AND EXT_V.ATTRIBUTE_ID = EXT_A.ATTRIBUTE_ID
AND EXT_V.VERSION_DISPLAY_CODE = 'DEFAULT'
AND EXT_ATTR.ATTRIBUTE_ID = EXT_A.ATTRIBUTE_ID
AND EXT_ATTR.VERSION_ID = EXT_V.VERSION_ID
AND EXT_ATTR.EXT_ACCOUNT_TYPE_CODE = ATTR.DIM_ATTRIBUTE_VARCHAR_MEMBER) EXTENDED_ACCOUNT_SIGN
, ( SELECT EXT_ATTR.DIM_ATTRIBUTE_VARCHAR_MEMBER
FROM FEM_LN_ITEMS_ATTR ATTR
, FEM_DIM_ATTRIBUTES_B A
, FEM_DIM_ATTR_VERSIONS_B V
, FEM_EXT_ACCT_TYPES_ATTR EXT_ATTR
, FEM_DIM_ATTRIBUTES_B EXT_A
, FEM_DIM_ATTR_VERSIONS_B EXT_V
WHERE A.DIMENSION_ID = 14
AND A.ATTRIBUTE_VARCHAR_LABEL = 'EXTENDED_ACCOUNT_TYPE'
AND V.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND V.VERSION_DISPLAY_CODE = 'DEFAULT'
AND ATTR.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND ATTR.VERSION_ID = V.VERSION_ID
AND ATTR.LINE_ITEM_ID = B.LINE_ITEM_ID
AND ATTR.VALUE_SET_ID = B.VALUE_SET_ID
AND EXT_A.DIMENSION_ID = 32
AND EXT_A.ATTRIBUTE_VARCHAR_LABEL = 'BASIC_ACCOUNT_TYPE_CODE'
AND EXT_V.ATTRIBUTE_ID = EXT_A.ATTRIBUTE_ID
AND EXT_V.VERSION_DISPLAY_CODE = 'DEFAULT'
AND EXT_ATTR.ATTRIBUTE_ID = EXT_A.ATTRIBUTE_ID
AND EXT_ATTR.VERSION_ID = EXT_V.VERSION_ID
AND EXT_ATTR.EXT_ACCOUNT_TYPE_CODE = ATTR.DIM_ATTRIBUTE_VARCHAR_MEMBER) BASIC_ACCOUNT_TYPE
, ( SELECT ADB.FLAG_CODE
FROM FEM_FLAGS_B ADB
, FEM_LN_ITEMS_ATTR ATTR
, FEM_DIM_ATTRIBUTES_B A
, FEM_DIM_ATTR_VERSIONS_B V
WHERE ADB.FLAG_CODE = ATTR.DIM_ATTRIBUTE_VARCHAR_MEMBER
AND A.DIMENSION_ID = 14
AND A.ATTRIBUTE_VARCHAR_LABEL = 'RECON_LEAF_NODE_FLAG'
AND V.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND V.VERSION_DISPLAY_CODE = 'DEFAULT'
AND ATTR.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND ATTR.VERSION_ID = V.VERSION_ID
AND ATTR.LINE_ITEM_ID = B.LINE_ITEM_ID
AND ATTR.VALUE_SET_ID = B.VALUE_SET_ID) RECON_LEAF_NODE_FLAG
, ( SELECT ADB.SOURCE_SYSTEM_DISPLAY_CODE
FROM FEM_SOURCE_SYSTEMS_B ADB
, FEM_LN_ITEMS_ATTR ATTR
, FEM_DIM_ATTRIBUTES_B A
, FEM_DIM_ATTR_VERSIONS_B V
WHERE ADB.SOURCE_SYSTEM_CODE = ATTR.DIM_ATTRIBUTE_NUMERIC_MEMBER
AND A.DIMENSION_ID = 14
AND A.ATTRIBUTE_VARCHAR_LABEL = 'SOURCE_SYSTEM_CODE'
AND V.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND V.VERSION_DISPLAY_CODE = 'DEFAULT'
AND ATTR.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND ATTR.VERSION_ID = V.VERSION_ID
AND ATTR.LINE_ITEM_ID = B.LINE_ITEM_ID
AND ATTR.VALUE_SET_ID = B.VALUE_SET_ID) SOURCE_SYSTEM_CODE
, ( SELECT ADB.AGG_METHOD_CODE
FROM FEM_AGG_METHODS_B ADB
, FEM_LN_ITEMS_ATTR ATTR
, FEM_DIM_ATTRIBUTES_B A
, FEM_DIM_ATTR_VERSIONS_B V
WHERE ADB.AGG_METHOD_CODE = ATTR.DIM_ATTRIBUTE_VARCHAR_MEMBER
AND A.DIMENSION_ID = 14
AND A.ATTRIBUTE_VARCHAR_LABEL = 'DEFAULT_AGG_METHOD'
AND V.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND V.VERSION_DISPLAY_CODE = 'DEFAULT'
AND ATTR.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND ATTR.VERSION_ID = V.VERSION_ID
AND ATTR.LINE_ITEM_ID = B.LINE_ITEM_ID
AND ATTR.VALUE_SET_ID = B.VALUE_SET_ID) DEFAULT_AGG_METHOD
, ( SELECT ATTR.VARCHAR_ASSIGN_VALUE
FROM FEM_LN_ITEMS_ATTR ATTR
, FEM_DIM_ATTRIBUTES_B A
, FEM_DIM_ATTR_VERSIONS_B V
WHERE A.DIMENSION_ID = 14
AND A.ATTRIBUTE_VARCHAR_LABEL = 'DEFAULT_NUMBER_FORMAT'
AND V.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND V.VERSION_DISPLAY_CODE = 'DEFAULT'
AND ATTR.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND ATTR.VERSION_ID = V.VERSION_ID
AND ATTR.LINE_ITEM_ID = B.LINE_ITEM_ID
AND ATTR.VALUE_SET_ID = B.VALUE_SET_ID) DEFAULT_NUMBER_FORMAT
, ( SELECT ADB.ACCRUAL_BASIS_DISPLAY_CODE
FROM FEM_MONTHLY_ACCRUAL_BASIS_VL ADB
, FEM_LN_ITEMS_ATTR ATTR
, FEM_DIM_ATTRIBUTES_B A
, FEM_DIM_ATTR_VERSIONS_B V
WHERE ADB.ACCRUAL_BASIS_ID = ATTR.DIM_ATTRIBUTE_NUMERIC_MEMBER
AND A.DIMENSION_ID = 14
AND A.ATTRIBUTE_VARCHAR_LABEL = 'MONTHLY_ACCRUAL_BASIS'
AND V.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND V.VERSION_DISPLAY_CODE = 'DEFAULT'
AND ATTR.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND ATTR.VERSION_ID = V.VERSION_ID
AND ATTR.LINE_ITEM_ID = B.LINE_ITEM_ID
AND ATTR.VALUE_SET_ID = B.VALUE_SET_ID) MONTHLY_ACCRUAL_BASIS
, ( SELECT ADB.AGG_METHOD_CODE
FROM FEM_AGG_METHODS_B ADB
, FEM_LN_ITEMS_ATTR ATTR
, FEM_DIM_ATTRIBUTES_B A
, FEM_DIM_ATTR_VERSIONS_B V
WHERE ADB.AGG_METHOD_CODE = ATTR.DIM_ATTRIBUTE_VARCHAR_MEMBER
AND A.DIMENSION_ID = 14
AND A.ATTRIBUTE_VARCHAR_LABEL = 'TIME_AGG_METHOD'
AND V.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND V.VERSION_DISPLAY_CODE = 'DEFAULT'
AND ATTR.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND ATTR.VERSION_ID = V.VERSION_ID
AND ATTR.LINE_ITEM_ID = B.LINE_ITEM_ID
AND ATTR.VALUE_SET_ID = B.VALUE_SET_ID) TIME_AGG_METHOD
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM FEM_LN_ITEMS_B B
, FEM_DIMENSION_GRPS_B DGB