DBA Data[Home] [Help] [Dependency Information]

TABLE: BOM.BOM_RTG_NETWORK_TEMP

Object Details
Object Name: BOM_RTG_NETWORK_TEMP
Object Type: TABLE
Owner: BOM
FND Design Data: TableBOM.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.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
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
Query Text

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;

Dependencies

[top of page]

BOM.BOM_RTG_NETWORK_TEMP does not reference any database object

BOM.BOM_RTG_NETWORK_TEMP is referenced by following:

SchemaBOM
ViewBOM_RTG_NETWORK_TEMP#