VIEW: BOM.BOM_RTG_OPERATION_TEMP#

Source

View Text - Preformatted

select ASSEMBLY_ITEM_NAME ASSEMBLY_ITEM_NAME, ORGANIZATION_CODE ORGANIZATION_CODE, ALTERNATE_ROUTING_CODE ALTERNATE_ROUTING_CODE, OPERATION_SEQUENCE_NUMBER OPERATION_SEQUENCE_NUMBER, OPERATION_TYPE OPERATION_TYPE, START_EFFECTIVE_DATE START_EFFECTIVE_DATE, NEW_OPERATION_SEQUENCE_NUMBER NEW_OPERATION_SEQUENCE_NUMBER, NEW_START_EFFECTIVE_DATE NEW_START_EFFECTIVE_DATE, STANDARD_OPERATION_CODE STANDARD_OPERATION_CODE, DEPARTMENT_CODE DEPARTMENT_CODE, OP_LEAD_TIME_PERCENT OP_LEAD_TIME_PERCENT, MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY, COUNT_POINT_TYPE COUNT_POINT_TYPE, OPERATION_DESCRIPTION OPERATION_DESCRIPTION, DISABLE_DATE DISABLE_DATE, BACKFLUSH_FLAG BACKFLUSH_FLAG, OPTION_DEPENDENT_FLAG OPTION_DEPENDENT_FLAG, REFERENCE_FLAG REFERENCE_FLAG, PROCESS_SEQ_NUMBER PROCESS_SEQ_NUMBER, PROCESS_CODE PROCESS_CODE, LINE_OP_SEQ_NUMBER LINE_OP_SEQ_NUMBER, LINE_OP_CODE LINE_OP_CODE, YIELD YIELD, CUMULATIVE_YIELD CUMULATIVE_YIELD, REVERSE_CUM_YIELD REVERSE_CUM_YIELD, USER_LABOR_TIME USER_LABOR_TIME, USER_MACHINE_TIME USER_MACHINE_TIME, NET_PLANNING_PERCENT NET_PLANNING_PERCENT, INCLUDE_IN_ROLLUP INCLUDE_IN_ROLLUP, OP_YIELD_ENABLED_FLAG OP_YIELD_ENABLED_FLAG, SHUTDOWN_TYPE SHUTDOWN_TYPE, 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, TRANSACTION_ID TRANSACTION_ID, TRANSACTION_GROUP_ID TRANSACTION_GROUP_ID from "BOM"."BOM_RTG_OPERATION_TEMP"

View Text - HTML Formatted

SELECT ASSEMBLY_ITEM_NAME ASSEMBLY_ITEM_NAME
, ORGANIZATION_CODE ORGANIZATION_CODE
, ALTERNATE_ROUTING_CODE ALTERNATE_ROUTING_CODE
, OPERATION_SEQUENCE_NUMBER OPERATION_SEQUENCE_NUMBER
, OPERATION_TYPE OPERATION_TYPE
, START_EFFECTIVE_DATE START_EFFECTIVE_DATE
, NEW_OPERATION_SEQUENCE_NUMBER NEW_OPERATION_SEQUENCE_NUMBER
, NEW_START_EFFECTIVE_DATE NEW_START_EFFECTIVE_DATE
, STANDARD_OPERATION_CODE STANDARD_OPERATION_CODE
, DEPARTMENT_CODE DEPARTMENT_CODE
, OP_LEAD_TIME_PERCENT OP_LEAD_TIME_PERCENT
, MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY
, COUNT_POINT_TYPE COUNT_POINT_TYPE
, OPERATION_DESCRIPTION OPERATION_DESCRIPTION
, DISABLE_DATE DISABLE_DATE
, BACKFLUSH_FLAG BACKFLUSH_FLAG
, OPTION_DEPENDENT_FLAG OPTION_DEPENDENT_FLAG
, REFERENCE_FLAG REFERENCE_FLAG
, PROCESS_SEQ_NUMBER PROCESS_SEQ_NUMBER
, PROCESS_CODE PROCESS_CODE
, LINE_OP_SEQ_NUMBER LINE_OP_SEQ_NUMBER
, LINE_OP_CODE LINE_OP_CODE
, YIELD YIELD
, CUMULATIVE_YIELD CUMULATIVE_YIELD
, REVERSE_CUM_YIELD REVERSE_CUM_YIELD
, USER_LABOR_TIME USER_LABOR_TIME
, USER_MACHINE_TIME USER_MACHINE_TIME
, NET_PLANNING_PERCENT NET_PLANNING_PERCENT
, INCLUDE_IN_ROLLUP INCLUDE_IN_ROLLUP
, OP_YIELD_ENABLED_FLAG OP_YIELD_ENABLED_FLAG
, SHUTDOWN_TYPE SHUTDOWN_TYPE
, 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
, TRANSACTION_ID TRANSACTION_ID
, TRANSACTION_GROUP_ID TRANSACTION_GROUP_ID
FROM "BOM"."BOM_RTG_OPERATION_TEMP"