[Home] [Help] [Dependency Information]
Object Name: | BOM_RTG_NETWORK_TEMP |
---|---|
Object Type: | TABLE |
Owner: | BOM |
FND Design Data: | BOM.BOM_RTG_NETWORK_TEMP |
Subobject Name: | |
Status: | VALID |
BOM_RTG_NETWORK_TEMP stores OAG routing network which is converted to Oracle routing network during xml routing import process.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSEMBLY_ITEM_NAME | VARCHAR2 | (81) | Yes | Inventory item name of manufactured assembly |
ORGANIZATION_CODE | VARCHAR2 | (3) | Yes | Organization code |
ALTERNATE_ROUTING_CODE | VARCHAR2 | (10) | Alternate routing code | |
OPERATION_TYPE | NUMBER | Yes | Operation type | |
FROM_OP_SEQ_NUMBER | NUMBER | Yes | From routing operation sequence number | |
NEW_FROM_OP_SEQ_NUMBER | NUMBER | New from routing operation sequence number | ||
FROM_START_EFFECTIVE_DATE | DATE | From routing operation sequence effective start date | ||
NEW_FROM_START_EFFECTIVE_DATE | DATE | New from routing operation sequence effective start date | ||
TO_OP_SEQ_NUMBER | NUMBER | Yes | To routing operation sequence number | |
NEW_TO_OP_SEQ_NUMBER | NUMBER | New to routing operation sequence number | ||
TO_START_EFFECTIVE_DATE | DATE | To routing operation sequence effective start date | ||
NEW_TO_START_EFFECTIVE_DATE | DATE | New to routing operation sequence effective start date | ||
CONNECTION_TYPE | NUMBER | Connection type | ||
PLANNING_PERCENT | NUMBER | Planning percentage | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
RETURN_STATUS | VARCHAR2 | (1) | Return status | |
ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | (50) | Original system reference | |
TRANSACTION_TYPE | VARCHAR2 | (30) | Transaction type | |
TRANSACTION_ID | NUMBER | Yes | Transaction identifier | |
TRANSACTION_GROUP_ID | NUMBER | Yes | Transaction group identifier | |
FROM_X_COORDINATE | NUMBER | X-coordinate of from operation | ||
FROM_Y_COORDINATE | NUMBER | Y-coordinate of from operation | ||
TO_X_COORDINATE | NUMBER | X-coordinate of to operation | ||
TO_Y_COORDINATE | NUMBER | Y-coordinate of to operation |
Cut, paste (and edit) the following text to query this object:
SELECT ASSEMBLY_ITEM_NAME
, ORGANIZATION_CODE
, ALTERNATE_ROUTING_CODE
, OPERATION_TYPE
, FROM_OP_SEQ_NUMBER
, NEW_FROM_OP_SEQ_NUMBER
, FROM_START_EFFECTIVE_DATE
, NEW_FROM_START_EFFECTIVE_DATE
, TO_OP_SEQ_NUMBER
, NEW_TO_OP_SEQ_NUMBER
, TO_START_EFFECTIVE_DATE
, NEW_TO_START_EFFECTIVE_DATE
, CONNECTION_TYPE
, PLANNING_PERCENT
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, RETURN_STATUS
, ORIGINAL_SYSTEM_REFERENCE
, TRANSACTION_TYPE
, TRANSACTION_ID
, TRANSACTION_GROUP_ID
, FROM_X_COORDINATE
, FROM_Y_COORDINATE
, TO_X_COORDINATE
, TO_Y_COORDINATE
FROM BOM.BOM_RTG_NETWORK_TEMP;
BOM.BOM_RTG_NETWORK_TEMP does not reference any database object
BOM.BOM_RTG_NETWORK_TEMP is referenced by following:
|
|
|