[Home] [Help] [Dependency Information]
Object Name: | ENG_CHANGE_LINES_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | ENG |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ECO_NAME | VARCHAR2 | (10) | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | ||
CHANGE_TYPE_CODE | VARCHAR2 | (80) | ||
NAME | VARCHAR2 | (240) | ||
DESCRIPTION | VARCHAR2 | (2000) | ||
SEQUENCE_NUMBER | NUMBER | |||
OBJECT_DISPLAY_NAME | VARCHAR2 | (240) | ||
PK1_NAME | VARCHAR2 | (240) | ||
PK2_NAME | VARCHAR2 | (240) | ||
PK3_NAME | VARCHAR2 | (240) | ||
PK4_NAME | VARCHAR2 | (240) | ||
PK5_NAME | VARCHAR2 | (240) | ||
RETURN_STATUS | VARCHAR2 | (1) | ||
TRANSACTION_TYPE | VARCHAR2 | (30) | ||
TRANSACTION_ID | NUMBER | |||
CHANGE_MGMT_TYPE_NAME | VARCHAR2 | (45) | ||
ORGANIZATION_ID | NUMBER | |||
ENG_CHANGES_IFCE_KEY | VARCHAR2 | (30) | ||
PROCESS_FLAG | NUMBER | |||
STATUS_NAME | VARCHAR2 | (80) | ||
ASSIGNEE_NAME | VARCHAR2 | (360) | ||
NEED_BY_DATE | DATE | |||
SCHEDULED_DATE | DATE | |||
IMPLEMENTATION_DATE | DATE | |||
CANCELATION_DATE | VARCHAR2 | (240) | ||
ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | (50) | ||
COMPLETE_BEFORE_STATUS_CODE | NUMBER | |||
START_AFTER_STATUS_CODE | NUMBER | |||
TYPE_CLASSIFICATION | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT ECO_NAME
, ORGANIZATION_CODE
, CHANGE_TYPE_CODE
, NAME
, DESCRIPTION
, SEQUENCE_NUMBER
, OBJECT_DISPLAY_NAME
, PK1_NAME
, PK2_NAME
, PK3_NAME
, PK4_NAME
, PK5_NAME
, RETURN_STATUS
, TRANSACTION_TYPE
, TRANSACTION_ID
, CHANGE_MGMT_TYPE_NAME
, ORGANIZATION_ID
, ENG_CHANGES_IFCE_KEY
, PROCESS_FLAG
, STATUS_NAME
, ASSIGNEE_NAME
, NEED_BY_DATE
, SCHEDULED_DATE
, IMPLEMENTATION_DATE
, CANCELATION_DATE
, ORIGINAL_SYSTEM_REFERENCE
, COMPLETE_BEFORE_STATUS_CODE
, START_AFTER_STATUS_CODE
, TYPE_CLASSIFICATION
FROM ENG.ENG_CHANGE_LINES_INTERFACE#;
|
|
|