VIEW: BOM.BOM_RTG_RESOURCE_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, OP_START_EFFECTIVE_DATE OP_START_EFFECTIVE_DATE, RESOURCE_SEQUENCE_NUMBER RESOURCE_SEQUENCE_NUMBER, RESOURCE_CODE RESOURCE_CODE, ACTIVITY ACTIVITY, STANDARD_RATE_FLAG STANDARD_RATE_FLAG, ASSIGNED_UNITS ASSIGNED_UNITS, USAGE_RATE_OR_AMOUNT USAGE_RATE_OR_AMOUNT, USAGE_RATE_OR_AMOUNT_INVERSE USAGE_RATE_OR_AMOUNT_INVERSE, BASIS_TYPE BASIS_TYPE, SCHEDULE_FLAG SCHEDULE_FLAG, RESOURCE_OFFSET_PERCENT RESOURCE_OFFSET_PERCENT, AUTOCHARGE_TYPE AUTOCHARGE_TYPE, SCHEDULE_SEQUENCE_NUMBER SCHEDULE_SEQUENCE_NUMBER, PRINCIPLE_FLAG PRINCIPLE_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, SETUP_TYPE SETUP_TYPE, TRANSACTION_ID TRANSACTION_ID, TRANSACTION_GROUP_ID TRANSACTION_GROUP_ID from "BOM"."BOM_RTG_RESOURCE_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
, OP_START_EFFECTIVE_DATE OP_START_EFFECTIVE_DATE
, RESOURCE_SEQUENCE_NUMBER RESOURCE_SEQUENCE_NUMBER
, RESOURCE_CODE RESOURCE_CODE
, ACTIVITY ACTIVITY
, STANDARD_RATE_FLAG STANDARD_RATE_FLAG
, ASSIGNED_UNITS ASSIGNED_UNITS
, USAGE_RATE_OR_AMOUNT USAGE_RATE_OR_AMOUNT
, USAGE_RATE_OR_AMOUNT_INVERSE USAGE_RATE_OR_AMOUNT_INVERSE
, BASIS_TYPE BASIS_TYPE
, SCHEDULE_FLAG SCHEDULE_FLAG
, RESOURCE_OFFSET_PERCENT RESOURCE_OFFSET_PERCENT
, AUTOCHARGE_TYPE AUTOCHARGE_TYPE
, SCHEDULE_SEQUENCE_NUMBER SCHEDULE_SEQUENCE_NUMBER
, PRINCIPLE_FLAG PRINCIPLE_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
, SETUP_TYPE SETUP_TYPE
, TRANSACTION_ID TRANSACTION_ID
, TRANSACTION_GROUP_ID TRANSACTION_GROUP_ID
FROM "BOM"."BOM_RTG_RESOURCE_TEMP"