VIEW: BOM.BOM_RTGHEADER_TEMP#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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