1. Tables and Views for SCM
  2. ACA_ITEM_CLASSES_V

ACA_ITEM_CLASSES_V

Details

  • Schema: FUSION

  • Object owner: ACA

  • Object type: VIEW

Columns

Name

ITEM_CLASS_ID

ITEM_CLASS_CODE

DOCUMENT_CLASS_FLAG

ROOT_CLASS_FLAG

DEFAULT_ITEM_CLASS_FLAG

ENABLED_FLAG

NIR_REQD

NIR_CHANGE_TYPE_ID

VERSION_ENABLED_FLAG

ITEM_CREATION_ALLOWED_FLAG

PARENT_ITEM_CLASS_ID

ITEM_NUM_GEN_METHOD

ITEM_DESC_GEN_METHOD

CFG_ITEM_NUM_GEN_METHOD

CHANGE_ORDER_TYPE_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ITEM_CLASS_NAME

DESCRIPTION

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_TIMESTAMP1

ATTRIBUTE_TIMESTAMP2

ATTRIBUTE_TIMESTAMP3

ATTRIBUTE_TIMESTAMP4

ATTRIBUTE_TIMESTAMP5

Query

SQL_Statement

SELECT item_class.item_class_id,

item_class.item_class_code,

DECODE(document_class.item_class_id, null, 0, 1) document_class_flag,

DECODE(document_class.item_class_id,

null, DECODE(item_class.parent_item_class_id, -1, 1, 0),

DECODE(document_class.parent_item_class_id, -1, 1, 0)) root_class_flag,

item_class.default_item_class_flag,

item_class.enabled_flag,

item_class.nir_reqd,

item_class.nir_change_type_id,

item_class.version_enabled_flag,

item_class.item_creation_allowed_flag,

item_class.parent_item_class_id,

item_class.item_num_gen_method,

item_class.item_desc_gen_method,

item_class.cfg_item_num_gen_method,

item_class.change_order_type_id,

item_class.object_version_number,

item_class.created_by,

item_class.creation_date,

item_class.last_updated_by,

item_class.last_update_date,

item_class.last_update_login,

item_class.item_class_name,

item_class.description,

item_class.request_id,

item_class.job_definition_name,

item_class.job_definition_package,

item_class.attribute_category,

item_class.attribute1,

item_class.attribute2,

item_class.attribute3,

item_class.attribute4,

item_class.attribute5,

item_class.attribute6,

item_class.attribute7,

item_class.attribute8,

item_class.attribute9,

item_class.attribute10,

item_class.attribute11,

item_class.attribute12,

item_class.attribute13,

item_class.attribute14,

item_class.attribute15,

item_class.attribute16,

item_class.attribute17,

item_class.attribute18,

item_class.attribute19,

item_class.attribute20,

item_class.attribute_number1,

item_class.attribute_number2,

item_class.attribute_number3,

item_class.attribute_number4,

item_class.attribute_number5,

item_class.attribute_number6,

item_class.attribute_number7,

item_class.attribute_number8,

item_class.attribute_number9,

item_class.attribute_number10,

item_class.attribute_date1,

item_class.attribute_date2,

item_class.attribute_date3,

item_class.attribute_date4,

item_class.attribute_date5,

item_class.attribute_timestamp1,

item_class.attribute_timestamp2,

item_class.attribute_timestamp3,

item_class.attribute_timestamp4,

item_class.attribute_timestamp5

FROM egp_item_classes_vl item_class,

aca_document_classes_v document_class

WHERE item_class.item_class_id = document_class.item_class_id(+)