[Home] [Help] [Dependency Information]
Object Name: | CZ_REPOSITORY_MAIN_HGRID_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CZ.CZ_REPOSITORY_MAIN_HGRID_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECT_TYPE | VARCHAR2 | (3) | Specifies the type of the associated object: 'FLD' for repository Folder, 'PRJ' for Model/Project, 'EFF' for Effectivity Set, 'USG' for Usage | |
OBJECT_ID | NUMBER | (15) | Holds the identifier of this object as recorded in the source table, e.g., a devl_project_id | |
ENCLOSING_FOLDER | NUMBER | (9) | Identifies the Configurator repository Folder in which this object resides | |
NAME | VARCHAR2 | (4000) | The name of this object | |
DESCRIPTION | VARCHAR2 | (4000) | ||
NOTES | VARCHAR2 | (2000) | Note text | |
DELETED_FLAG | VARCHAR2 | (1) | Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved | |
CREATED_BY | NUMBER | (9) | Standard field recording the ID of the user that created this record | |
CREATION_DATE | DATE | Standard field recording the date this record was created | ||
LAST_UPDATED_BY | NUMBER | (9) | Standard field recording the ID of the user that last updated this record | |
LAST_UPDATE_DATE | DATE | Standard field recording the date/time this record was last updated | ||
SEEDED_FLAG | VARCHAR2 | (1) | '1' indicates this is a seeded expr node | |
HAS_ENTITY_PRIV | CHAR | (1) | ||
USER_LOCK_STATUS | VARCHAR2 | (1) | ||
IS_MODEL_EDITABLE | CHAR | (1) | ||
CHECKOUT_USER | VARCHAR2 | (100) | ||
PRODUCT_KEY | VARCHAR2 | (255) | ||
ORGANIZATION_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
MODEL_TYPE | VARCHAR2 | (1) | ||
PATH | VARCHAR2 | (4000) | ||
ORIG_SYS_REF | VARCHAR2 | (255) | ||
MODEL_LAST_UPDATE_DATE | DATE | |||
MODEL_LAST_UPDATED_BY | NUMBER | |||
OBJECT_TYPE_DESC | VARCHAR2 | (4000) | ||
IMAGE_FILE | VARCHAR2 | (4000) | ||
FULL_IMAGE_PATH | VARCHAR2 | (4000) | ||
ALT_TEXT | VARCHAR2 | (4000) | ||
DETAILED_OBJECT_TYPE | VARCHAR2 | (255) | ||
PROPERTY_DATA_TYPE | NUMBER | |||
PROPERTY_DEF_VALUE | VARCHAR2 | (4000) | ||
PROPERTY_DEF_NUM_VALUE | NUMBER | |||
PROPERTY_DEF_LOCAL_TEXT | VARCHAR2 | (2000) | ||
LOCK_STATUS | VARCHAR2 | (80) | ||
CHECKOUT_TIME | DATE | |||
REF_PART_NBR | VARCHAR2 | (1000) | ||
EFFECTIVE_FROM | DATE | Effectivity Set Valid From | ||
EFFECTIVE_UNTIL | DATE | Effectivity Set Valid Until | ||
CONFIG_ENGINE_TYPE | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT OBJECT_TYPE
, OBJECT_ID
, ENCLOSING_FOLDER
, NAME
, DESCRIPTION
, NOTES
, DELETED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, SEEDED_FLAG
, HAS_ENTITY_PRIV
, USER_LOCK_STATUS
, IS_MODEL_EDITABLE
, CHECKOUT_USER
, PRODUCT_KEY
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, MODEL_TYPE
, PATH
, ORIG_SYS_REF
, MODEL_LAST_UPDATE_DATE
, MODEL_LAST_UPDATED_BY
, OBJECT_TYPE_DESC
, IMAGE_FILE
, FULL_IMAGE_PATH
, ALT_TEXT
, DETAILED_OBJECT_TYPE
, PROPERTY_DATA_TYPE
, PROPERTY_DEF_VALUE
, PROPERTY_DEF_NUM_VALUE
, PROPERTY_DEF_LOCAL_TEXT
, LOCK_STATUS
, CHECKOUT_TIME
, REF_PART_NBR
, EFFECTIVE_FROM
, EFFECTIVE_UNTIL
, CONFIG_ENGINE_TYPE
FROM APPS.CZ_REPOSITORY_MAIN_HGRID_V;
APPS.CZ_REPOSITORY_MAIN_HGRID_V is not referenced by any database object
|
|
|