[Home] [Help] [Dependency Information]
Object Name: | ENG_CHANGE_LINES_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | ENG |
FND Design Data: | ENG.ENG_CHANGE_LINES_INTERFACE |
Subobject Name: | |
Status: | VALID |
Engineering Change Lines Import
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ENG_CHANGE_LINES_INTERFACE_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
ENG_CHANGES_IFCE_KEY
ORGANIZATION_ID |
ENG_CHANGE_LINES_INTERFACE_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
ENG_CHANGES_IFCE_KEY
PROCESS_FLAG |
ENG_CHANGE_LINES_INTERFACE_N3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | TRANSACTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ECO_NAME | VARCHAR2 | (10) | Eco Name | |
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization Code | |
CHANGE_TYPE_CODE | VARCHAR2 | (80) | Change Type Code | |
NAME | VARCHAR2 | (240) | Name | |
DESCRIPTION | VARCHAR2 | (2000) | Description | |
SEQUENCE_NUMBER | NUMBER | Sequence Number | ||
OBJECT_DISPLAY_NAME | VARCHAR2 | (240) | Item Name | |
PK1_NAME | VARCHAR2 | (240) | PK1 Name | |
PK2_NAME | VARCHAR2 | (240) | PK2 Name | |
PK3_NAME | VARCHAR2 | (240) | PK3 Name | |
PK4_NAME | VARCHAR2 | (240) | PK4 Name | |
PK5_NAME | VARCHAR2 | (240) | PK5 Name | |
RETURN_STATUS | VARCHAR2 | (1) | Return Status | |
TRANSACTION_TYPE | VARCHAR2 | (30) | Transaction Type | |
TRANSACTION_ID | NUMBER | Transaction Id | ||
CHANGE_MGMT_TYPE_NAME | VARCHAR2 | (45) | Change Mgmt Type Name | |
ORGANIZATION_ID | NUMBER | Organization Id | ||
ENG_CHANGES_IFCE_KEY | VARCHAR2 | (30) | Eng Changes Ifce Key | |
PROCESS_FLAG | NUMBER | Process flag | ||
STATUS_NAME | VARCHAR2 | (80) | Status Name | |
ASSIGNEE_NAME | VARCHAR2 | (360) | Assignee Name | |
NEED_BY_DATE | DATE | Need By date | ||
SCHEDULED_DATE | DATE | Scheduled Date | ||
IMPLEMENTATION_DATE | DATE | Implementation date | ||
CANCELATION_DATE | VARCHAR2 | (240) | Cancelation date | |
ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | (50) | Original System Reference | |
COMPLETE_BEFORE_STATUS_CODE | NUMBER | Complete before status code | ||
START_AFTER_STATUS_CODE | NUMBER | Start after status code | ||
TYPE_CLASSIFICATION | VARCHAR2 | (30) | Classification type |
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;
ENG.ENG_CHANGE_LINES_INTERFACE does not reference any database object
ENG.ENG_CHANGE_LINES_INTERFACE is referenced by following:
|
|
|