ACA_NON_DOCUMENT_CLASSES_V

Details

• Schema: FUSION

• Object owner: ACA

• Object type: VIEW

Columns

Name

ITEM_CLASS_ID ITEM_CLASS_CODE DOCUMENT_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_id, item_class_code, 0 document_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 FROM egp_item_classes_vl item_class WHERE NOT EXISTS (SELECT 1 FROM ACA_DOCUMENT_CLASSES_V WHERE ITEM_CLASS_CODE = item_class.ITEM_CLASS_CODE)