eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: BOM.BOM_RTG_NETWORK_TEMP#

Source

View Text - Preformatted


select ASSEMBLY_ITEM_NAME ASSEMBLY_ITEM_NAME, ORGANIZATION_CODE ORGANIZATION_CODE, ALTERNATE_ROUTING_CODE ALTERNATE_ROUTING_CODE, OPERATION_TYPE OPERATION_TYPE, FROM_OP_SEQ_NUMBER FROM_OP_SEQ_NUMBER, NEW_FROM_OP_SEQ_NUMBER NEW_FROM_OP_SEQ_NUMBER, FROM_START_EFFECTIVE_DATE FROM_START_EFFECTIVE_DATE, NEW_FROM_START_EFFECTIVE_DATE NEW_FROM_START_EFFECTIVE_DATE, TO_OP_SEQ_NUMBER TO_OP_SEQ_NUMBER, NEW_TO_OP_SEQ_NUMBER NEW_TO_OP_SEQ_NUMBER, TO_START_EFFECTIVE_DATE TO_START_EFFECTIVE_DATE, NEW_TO_START_EFFECTIVE_DATE NEW_TO_START_EFFECTIVE_DATE, CONNECTION_TYPE CONNECTION_TYPE, PLANNING_PERCENT PLANNING_PERCENT, 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, TRANSACTION_ID TRANSACTION_ID, TRANSACTION_GROUP_ID TRANSACTION_GROUP_ID, FROM_X_COORDINATE FROM_X_COORDINATE, FROM_Y_COORDINATE FROM_Y_COORDINATE, TO_X_COORDINATE TO_X_COORDINATE, TO_Y_COORDINATE TO_Y_COORDINATE from "BOM"."BOM_RTG_NETWORK_TEMP"

View Text - HTML Formatted

SELECT ASSEMBLY_ITEM_NAME ASSEMBLY_ITEM_NAME
, ORGANIZATION_CODE ORGANIZATION_CODE
, ALTERNATE_ROUTING_CODE ALTERNATE_ROUTING_CODE
, OPERATION_TYPE OPERATION_TYPE
, FROM_OP_SEQ_NUMBER FROM_OP_SEQ_NUMBER
, NEW_FROM_OP_SEQ_NUMBER NEW_FROM_OP_SEQ_NUMBER
, FROM_START_EFFECTIVE_DATE FROM_START_EFFECTIVE_DATE
, NEW_FROM_START_EFFECTIVE_DATE NEW_FROM_START_EFFECTIVE_DATE
, TO_OP_SEQ_NUMBER TO_OP_SEQ_NUMBER
, NEW_TO_OP_SEQ_NUMBER NEW_TO_OP_SEQ_NUMBER
, TO_START_EFFECTIVE_DATE TO_START_EFFECTIVE_DATE
, NEW_TO_START_EFFECTIVE_DATE NEW_TO_START_EFFECTIVE_DATE
, CONNECTION_TYPE CONNECTION_TYPE
, PLANNING_PERCENT PLANNING_PERCENT
, 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
, TRANSACTION_ID TRANSACTION_ID
, TRANSACTION_GROUP_ID TRANSACTION_GROUP_ID
, FROM_X_COORDINATE FROM_X_COORDINATE
, FROM_Y_COORDINATE FROM_Y_COORDINATE
, TO_X_COORDINATE TO_X_COORDINATE
, TO_Y_COORDINATE TO_Y_COORDINATE
FROM "BOM"."BOM_RTG_NETWORK_TEMP"