VIEW: GMP.GMP_APS_OUTPUT_DTL#

Source

View Text - Preformatted

select GROUP_ID GROUP_ID, WIP_ENTITY_ID WIP_ENTITY_ID, ORGANIZATION_ID ORGANIZATION_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM, RESOURCE_ID_OLD RESOURCE_ID_OLD, RESOURCE_ID_NEW RESOURCE_ID_NEW, USAGE_RATE_OR_AMOUNT USAGE_RATE_OR_AMOUNT, SCHEDULED_FLAG SCHEDULED_FLAG, ASSIGNED_UNITS ASSIGNED_UNITS, UOM_CODE UOM_CODE, START_DATE START_DATE, COMPLETION_DATE COMPLETION_DATE, INVENTORY_ITEM_ID_OLD INVENTORY_ITEM_ID_OLD, INVENTORY_ITEM_ID_NEW INVENTORY_ITEM_ID_NEW, QUANTITY_PER_ASSEMBLY QUANTITY_PER_ASSEMBLY, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, DATE_REQUIRED DATE_REQUIRED, REQUIRED_QUANTITY REQUIRED_QUANTITY, QUANTITY_ISSUED QUANTITY_ISSUED, LOAD_TYPE LOAD_TYPE, SUBSTITUTION_TYPE SUBSTITUTION_TYPE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PARENT_HEADER_ID PARENT_HEADER_ID, FIRST_UNIT_START_DATE FIRST_UNIT_START_DATE, LAST_UNIT_COMPLETION_DATE LAST_UNIT_COMPLETION_DATE, MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, SCHEDULE_SEQ_NUM SCHEDULE_SEQ_NUM, SUBSTITUTE_GROUP_NUM SUBSTITUTE_GROUP_NUM, REPLACEMENT_GROUP_NUM REPLACEMENT_GROUP_NUM, CHARGE_NUMBER CHARGE_NUMBER, FIRM_FLAG FIRM_FLAG, GROUP_SEQUENCE_ID GROUP_SEQUENCE_ID, PARENT_SEQ_NUM PARENT_SEQ_NUM, RESOURCE_INSTANCE_ID RESOURCE_INSTANCE_ID, RESOURCE_INSTANCE_NUMBER RESOURCE_INSTANCE_NUMBER, SETUP_ID SETUP_ID, GROUP_SEQUENCE_NUMBER GROUP_SEQUENCE_NUMBER from "GMP"."GMP_APS_OUTPUT_DTL"

View Text - HTML Formatted

SELECT GROUP_ID GROUP_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
, ORGANIZATION_ID ORGANIZATION_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM
, RESOURCE_ID_OLD RESOURCE_ID_OLD
, RESOURCE_ID_NEW RESOURCE_ID_NEW
, USAGE_RATE_OR_AMOUNT USAGE_RATE_OR_AMOUNT
, SCHEDULED_FLAG SCHEDULED_FLAG
, ASSIGNED_UNITS ASSIGNED_UNITS
, UOM_CODE UOM_CODE
, START_DATE START_DATE
, COMPLETION_DATE COMPLETION_DATE
, INVENTORY_ITEM_ID_OLD INVENTORY_ITEM_ID_OLD
, INVENTORY_ITEM_ID_NEW INVENTORY_ITEM_ID_NEW
, QUANTITY_PER_ASSEMBLY QUANTITY_PER_ASSEMBLY
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, DATE_REQUIRED DATE_REQUIRED
, REQUIRED_QUANTITY REQUIRED_QUANTITY
, QUANTITY_ISSUED QUANTITY_ISSUED
, LOAD_TYPE LOAD_TYPE
, SUBSTITUTION_TYPE SUBSTITUTION_TYPE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PARENT_HEADER_ID PARENT_HEADER_ID
, FIRST_UNIT_START_DATE FIRST_UNIT_START_DATE
, LAST_UNIT_COMPLETION_DATE LAST_UNIT_COMPLETION_DATE
, MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, SCHEDULE_SEQ_NUM SCHEDULE_SEQ_NUM
, SUBSTITUTE_GROUP_NUM SUBSTITUTE_GROUP_NUM
, REPLACEMENT_GROUP_NUM REPLACEMENT_GROUP_NUM
, CHARGE_NUMBER CHARGE_NUMBER
, FIRM_FLAG FIRM_FLAG
, GROUP_SEQUENCE_ID GROUP_SEQUENCE_ID
, PARENT_SEQ_NUM PARENT_SEQ_NUM
, RESOURCE_INSTANCE_ID RESOURCE_INSTANCE_ID
, RESOURCE_INSTANCE_NUMBER RESOURCE_INSTANCE_NUMBER
, SETUP_ID SETUP_ID
, GROUP_SEQUENCE_NUMBER GROUP_SEQUENCE_NUMBER
FROM "GMP"."GMP_APS_OUTPUT_DTL"