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.FEM_NAT_ACCTS_ATTRD_V

Source

View Text - Preformatted


SELECT b.NATURAL_ACCOUNT_ID ,b.value_set_id ,b.NATURAL_ACCOUNT_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_NAT_ACCTS_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 = 2 and a.attribute_varchar_label = 'BUDGET_ALLOWED_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.NATURAL_ACCOUNT_ID = b.NATURAL_ACCOUNT_ID and attr.value_set_id = b.value_set_id) BUDGET_ALLOWED_FLAG ,( select adb.EXT_ACCOUNT_TYPE_CODE from FEM_EXT_ACCOUNT_TYPES_B adb ,FEM_NAT_ACCTS_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 = 2 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.NATURAL_ACCOUNT_ID = b.NATURAL_ACCOUNT_ID and attr.value_set_id = b.value_set_id) EXTENDED_ACCOUNT_TYPE ,( select ext_attr.number_assign_value from FEM_NAT_ACCTS_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 = 2 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.NATURAL_ACCOUNT_ID = b.NATURAL_ACCOUNT_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_NAT_ACCTS_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 = 2 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.NATURAL_ACCOUNT_ID = b.NATURAL_ACCOUNT_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_NAT_ACCTS_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 = 2 and a.attribute_varchar_label = 'INVENTORIABLE_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.NATURAL_ACCOUNT_ID = b.NATURAL_ACCOUNT_ID and attr.value_set_id = b.value_set_id) INVENTORIABLE_FLAG ,( select adb.FLAG_CODE from FEM_FLAGS_B adb ,FEM_NAT_ACCTS_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 = 2 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.NATURAL_ACCOUNT_ID = b.NATURAL_ACCOUNT_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_NAT_ACCTS_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 = 2 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.NATURAL_ACCOUNT_ID = b.NATURAL_ACCOUNT_ID and attr.value_set_id = b.value_set_id) SOURCE_SYSTEM_CODE ,( select adb.FINANCIAL_ELEM_DISPLAY_CODE from FEM_FIN_ELEMS_B adb ,FEM_NAT_ACCTS_ATTR attr ,fem_dim_attributes_b a ,fem_dim_attr_versions_b v where adb.FINANCIAL_ELEM_ID = attr.DIM_ATTRIBUTE_NUMERIC_MEMBER and adb.value_set_id = attr.dim_attribute_value_set_id and a.dimension_id = 2 and a.attribute_varchar_label = 'FINANCIAL_ELEMENT' 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.NATURAL_ACCOUNT_ID = b.NATURAL_ACCOUNT_ID and attr.value_set_id = b.value_set_id) FINANCIAL_ELEMENT ,( select adb.LINE_ITEM_DISPLAY_CODE from FEM_LN_ITEMS_B adb ,FEM_NAT_ACCTS_ATTR attr ,fem_dim_attributes_b a ,fem_dim_attr_versions_b v where adb.LINE_ITEM_ID = attr.DIM_ATTRIBUTE_NUMERIC_MEMBER and adb.value_set_id = attr.dim_attribute_value_set_id and a.dimension_id = 2 and a.attribute_varchar_label = 'LINE_ITEM' 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.NATURAL_ACCOUNT_ID = b.NATURAL_ACCOUNT_ID and attr.value_set_id = b.value_set_id) LINE_ITEM ,( select adb.NA_EXPENSE_TYPE_CODE from FEM_NA_EXPENSE_TYPES_B adb ,FEM_NAT_ACCTS_ATTR attr ,fem_dim_attributes_b a ,fem_dim_attr_versions_b v where adb.NA_EXPENSE_TYPE_CODE = attr.DIM_ATTRIBUTE_VARCHAR_MEMBER and a.dimension_id = 2 and a.attribute_varchar_label = 'NAT_ACCT_EXPENSE_TYPE_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.NATURAL_ACCOUNT_ID = b.NATURAL_ACCOUNT_ID and attr.value_set_id = b.value_set_id) NAT_ACCT_EXPENSE_TYPE_CODE ,b.created_by ,b.creation_date ,b.last_updated_by ,b.last_update_date ,b.last_update_login from FEM_NAT_ACCTS_B b ,fem_dimension_grps_b dgb

View Text - HTML Formatted

SELECT B.NATURAL_ACCOUNT_ID
, B.VALUE_SET_ID
, B.NATURAL_ACCOUNT_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_NAT_ACCTS_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 = 2
AND A.ATTRIBUTE_VARCHAR_LABEL = 'BUDGET_ALLOWED_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.NATURAL_ACCOUNT_ID = B.NATURAL_ACCOUNT_ID
AND ATTR.VALUE_SET_ID = B.VALUE_SET_ID) BUDGET_ALLOWED_FLAG
, ( SELECT ADB.EXT_ACCOUNT_TYPE_CODE
FROM FEM_EXT_ACCOUNT_TYPES_B ADB
, FEM_NAT_ACCTS_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 = 2
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.NATURAL_ACCOUNT_ID = B.NATURAL_ACCOUNT_ID
AND ATTR.VALUE_SET_ID = B.VALUE_SET_ID) EXTENDED_ACCOUNT_TYPE
, ( SELECT EXT_ATTR.NUMBER_ASSIGN_VALUE
FROM FEM_NAT_ACCTS_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 = 2
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.NATURAL_ACCOUNT_ID = B.NATURAL_ACCOUNT_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_NAT_ACCTS_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 = 2
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.NATURAL_ACCOUNT_ID = B.NATURAL_ACCOUNT_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_NAT_ACCTS_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 = 2
AND A.ATTRIBUTE_VARCHAR_LABEL = 'INVENTORIABLE_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.NATURAL_ACCOUNT_ID = B.NATURAL_ACCOUNT_ID
AND ATTR.VALUE_SET_ID = B.VALUE_SET_ID) INVENTORIABLE_FLAG
, ( SELECT ADB.FLAG_CODE
FROM FEM_FLAGS_B ADB
, FEM_NAT_ACCTS_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 = 2
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.NATURAL_ACCOUNT_ID = B.NATURAL_ACCOUNT_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_NAT_ACCTS_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 = 2
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.NATURAL_ACCOUNT_ID = B.NATURAL_ACCOUNT_ID
AND ATTR.VALUE_SET_ID = B.VALUE_SET_ID) SOURCE_SYSTEM_CODE
, ( SELECT ADB.FINANCIAL_ELEM_DISPLAY_CODE
FROM FEM_FIN_ELEMS_B ADB
, FEM_NAT_ACCTS_ATTR ATTR
, FEM_DIM_ATTRIBUTES_B A
, FEM_DIM_ATTR_VERSIONS_B V
WHERE ADB.FINANCIAL_ELEM_ID = ATTR.DIM_ATTRIBUTE_NUMERIC_MEMBER
AND ADB.VALUE_SET_ID = ATTR.DIM_ATTRIBUTE_VALUE_SET_ID
AND A.DIMENSION_ID = 2
AND A.ATTRIBUTE_VARCHAR_LABEL = 'FINANCIAL_ELEMENT'
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.NATURAL_ACCOUNT_ID = B.NATURAL_ACCOUNT_ID
AND ATTR.VALUE_SET_ID = B.VALUE_SET_ID) FINANCIAL_ELEMENT
, ( SELECT ADB.LINE_ITEM_DISPLAY_CODE
FROM FEM_LN_ITEMS_B ADB
, FEM_NAT_ACCTS_ATTR ATTR
, FEM_DIM_ATTRIBUTES_B A
, FEM_DIM_ATTR_VERSIONS_B V
WHERE ADB.LINE_ITEM_ID = ATTR.DIM_ATTRIBUTE_NUMERIC_MEMBER
AND ADB.VALUE_SET_ID = ATTR.DIM_ATTRIBUTE_VALUE_SET_ID
AND A.DIMENSION_ID = 2
AND A.ATTRIBUTE_VARCHAR_LABEL = 'LINE_ITEM'
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.NATURAL_ACCOUNT_ID = B.NATURAL_ACCOUNT_ID
AND ATTR.VALUE_SET_ID = B.VALUE_SET_ID) LINE_ITEM
, ( SELECT ADB.NA_EXPENSE_TYPE_CODE
FROM FEM_NA_EXPENSE_TYPES_B ADB
, FEM_NAT_ACCTS_ATTR ATTR
, FEM_DIM_ATTRIBUTES_B A
, FEM_DIM_ATTR_VERSIONS_B V
WHERE ADB.NA_EXPENSE_TYPE_CODE = ATTR.DIM_ATTRIBUTE_VARCHAR_MEMBER
AND A.DIMENSION_ID = 2
AND A.ATTRIBUTE_VARCHAR_LABEL = 'NAT_ACCT_EXPENSE_TYPE_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.NATURAL_ACCOUNT_ID = B.NATURAL_ACCOUNT_ID
AND ATTR.VALUE_SET_ID = B.VALUE_SET_ID) NAT_ACCT_EXPENSE_TYPE_CODE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM FEM_NAT_ACCTS_B B
, FEM_DIMENSION_GRPS_B DGB