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

VIEW: BOM.BOM_RTGHEADER_TEMP#

Object Details
Object Name: BOM_RTGHEADER_TEMP#
Object Type: VIEW
Owner: BOM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSEMBLY_ITEM_NAME VARCHAR2 (81) Yes
ORGANIZATION_CODE VARCHAR2 (3) Yes
ALTERNATE_ROUTING_CODE VARCHAR2 (10)
ENG_ROUTING_FLAG NUMBER
Yes
COMMON_ASSEMBLY_ITEM_NAME VARCHAR2 (81)
ROUTING_COMMENT VARCHAR2 (240)
COMPLETION_SUBINVENTORY VARCHAR2 (10)
COMPLETION_LOCATION_NAME VARCHAR2 (81)
LINE_CODE VARCHAR2 (10)
CFM_ROUTING_FLAG NUMBER

MIXED_MODEL_MAP_FLAG NUMBER

PRIORITY NUMBER

TOTAL_CYCLE_TIME NUMBER

CTP_FLAG NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
RETURN_STATUS VARCHAR2 (1)
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
TRANSACTION_TYPE VARCHAR2 (30) Yes
DELETE_GROUP_NAME VARCHAR2 (10)
DG_DESCRIPTION VARCHAR2 (240)
REVISION_NAME VARCHAR2 (3)
REVISION_START_EFF_DATE DATE

REVISION_ATTRIBUTE_CATEGORY VARCHAR2 (30)
REVISION_ATTRIBUTE1 VARCHAR2 (150)
REVISION_ATTRIBUTE2 VARCHAR2 (150)
REVISION_ATTRIBUTE3 VARCHAR2 (150)
REVISION_ATTRIBUTE4 VARCHAR2 (150)
REVISION_ATTRIBUTE5 VARCHAR2 (150)
REVISION_ATTRIBUTE6 VARCHAR2 (150)
REVISION_ATTRIBUTE7 VARCHAR2 (150)
REVISION_ATTRIBUTE8 VARCHAR2 (150)
REVISION_ATTRIBUTE9 VARCHAR2 (150)
REVISION_ATTRIBUTE10 VARCHAR2 (150)
REVISION_ATTRIBUTE11 VARCHAR2 (150)
REVISION_ATTRIBUTE12 VARCHAR2 (150)
REVISION_ATTRIBUTE13 VARCHAR2 (150)
REVISION_ATTRIBUTE14 VARCHAR2 (150)
REVISION_ATTRIBUTE15 VARCHAR2 (150)
REVISION_RETURN_STATUS VARCHAR2 (1)
REVISION_TRANSACTION_TYPE VARCHAR2 (30)
REVISION_ORIG_SYS_REFERENCE VARCHAR2 (50)
TRANSACTION_ID NUMBER
Yes
TRANSACTION_GROUP_ID NUMBER
Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ASSEMBLY_ITEM_NAME
,      ORGANIZATION_CODE
,      ALTERNATE_ROUTING_CODE
,      ENG_ROUTING_FLAG
,      COMMON_ASSEMBLY_ITEM_NAME
,      ROUTING_COMMENT
,      COMPLETION_SUBINVENTORY
,      COMPLETION_LOCATION_NAME
,      LINE_CODE
,      CFM_ROUTING_FLAG
,      MIXED_MODEL_MAP_FLAG
,      PRIORITY
,      TOTAL_CYCLE_TIME
,      CTP_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RETURN_STATUS
,      ORIGINAL_SYSTEM_REFERENCE
,      TRANSACTION_TYPE
,      DELETE_GROUP_NAME
,      DG_DESCRIPTION
,      REVISION_NAME
,      REVISION_START_EFF_DATE
,      REVISION_ATTRIBUTE_CATEGORY
,      REVISION_ATTRIBUTE1
,      REVISION_ATTRIBUTE2
,      REVISION_ATTRIBUTE3
,      REVISION_ATTRIBUTE4
,      REVISION_ATTRIBUTE5
,      REVISION_ATTRIBUTE6
,      REVISION_ATTRIBUTE7
,      REVISION_ATTRIBUTE8
,      REVISION_ATTRIBUTE9
,      REVISION_ATTRIBUTE10
,      REVISION_ATTRIBUTE11
,      REVISION_ATTRIBUTE12
,      REVISION_ATTRIBUTE13
,      REVISION_ATTRIBUTE14
,      REVISION_ATTRIBUTE15
,      REVISION_RETURN_STATUS
,      REVISION_TRANSACTION_TYPE
,      REVISION_ORIG_SYS_REFERENCE
,      TRANSACTION_ID
,      TRANSACTION_GROUP_ID
FROM BOM.BOM_RTGHEADER_TEMP#;

Dependencies

[top of page]

BOM.BOM_RTGHEADER_TEMP# references the following:

SchemaBOM
TableBOM_RTGHEADER_TEMP
BOM.BOM_RTGHEADER_TEMP# is referenced by following:

SchemaAPPS
SynonymBOM_RTGHEADER_TEMP