VIEW: MSC.MSC_ST_RESERVATIONS#

Source

View Text - Preformatted

select INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, TRANSACTION_ID TRANSACTION_ID, PARENT_DEMAND_ID PARENT_DEMAND_ID, DISPOSITION_ID DISPOSITION_ID, REQUIREMENT_DATE REQUIREMENT_DATE, REVISION REVISION, RESERVED_QUANTITY RESERVED_QUANTITY, DISPOSITION_TYPE DISPOSITION_TYPE, SUBINVENTORY SUBINVENTORY, RESERVATION_TYPE RESERVATION_TYPE, DEMAND_CLASS DEMAND_CLASS, AVAILABLE_TO_MRP AVAILABLE_TO_MRP, RESERVATION_FLAG RESERVATION_FLAG, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, PLANNING_GROUP PLANNING_GROUP, DELETED_FLAG DELETED_FLAG, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SR_INSTANCE_ID SR_INSTANCE_ID, REFRESH_ID REFRESH_ID, ORGANIZATION_CODE ORGANIZATION_CODE, ITEM_NAME ITEM_NAME, SALES_ORDER_NUMBER SALES_ORDER_NUMBER, LINE_NUM LINE_NUM, SR_INSTANCE_CODE SR_INSTANCE_CODE, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, ERROR_TEXT ERROR_TEXT, BATCH_ID BATCH_ID, COMPANY_NAME COMPANY_NAME, PROJECT_NUMBER PROJECT_NUMBER, TASK_NUMBER TASK_NUMBER, SUPPLY_SOURCE_HEADER_ID SUPPLY_SOURCE_HEADER_ID, SUPPLY_SOURCE_TYPE_ID SUPPLY_SOURCE_TYPE_ID, TRANSACTION_TYPE TRANSACTION_TYPE, REPAIR_PO_HEADER_ID REPAIR_PO_HEADER_ID, ORDER2_ORGANIZATION_ID ORDER2_ORGANIZATION_ID, ORDER2_INVENTORY_ITEM_ID ORDER2_INVENTORY_ITEM_ID, DEMAND_ORDER_NUMBER DEMAND_ORDER_NUMBER, PURCH_LINE_NUM PURCH_LINE_NUM, SUPPLY_ORDER_NUMBER SUPPLY_ORDER_NUMBER, SUPPLY_ORG_CODE SUPPLY_ORG_CODE, SERIAL_NUMBER SERIAL_NUMBER, DEMAND_SOURCE_LINE_ID DEMAND_SOURCE_LINE_ID from "MSC"."MSC_ST_RESERVATIONS"

View Text - HTML Formatted

SELECT INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, TRANSACTION_ID TRANSACTION_ID
, PARENT_DEMAND_ID PARENT_DEMAND_ID
, DISPOSITION_ID DISPOSITION_ID
, REQUIREMENT_DATE REQUIREMENT_DATE
, REVISION REVISION
, RESERVED_QUANTITY RESERVED_QUANTITY
, DISPOSITION_TYPE DISPOSITION_TYPE
, SUBINVENTORY SUBINVENTORY
, RESERVATION_TYPE RESERVATION_TYPE
, DEMAND_CLASS DEMAND_CLASS
, AVAILABLE_TO_MRP AVAILABLE_TO_MRP
, RESERVATION_FLAG RESERVATION_FLAG
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, PLANNING_GROUP PLANNING_GROUP
, DELETED_FLAG DELETED_FLAG
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SR_INSTANCE_ID SR_INSTANCE_ID
, REFRESH_ID REFRESH_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, ITEM_NAME ITEM_NAME
, SALES_ORDER_NUMBER SALES_ORDER_NUMBER
, LINE_NUM LINE_NUM
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, ERROR_TEXT ERROR_TEXT
, BATCH_ID BATCH_ID
, COMPANY_NAME COMPANY_NAME
, PROJECT_NUMBER PROJECT_NUMBER
, TASK_NUMBER TASK_NUMBER
, SUPPLY_SOURCE_HEADER_ID SUPPLY_SOURCE_HEADER_ID
, SUPPLY_SOURCE_TYPE_ID SUPPLY_SOURCE_TYPE_ID
, TRANSACTION_TYPE TRANSACTION_TYPE
, REPAIR_PO_HEADER_ID REPAIR_PO_HEADER_ID
, ORDER2_ORGANIZATION_ID ORDER2_ORGANIZATION_ID
, ORDER2_INVENTORY_ITEM_ID ORDER2_INVENTORY_ITEM_ID
, DEMAND_ORDER_NUMBER DEMAND_ORDER_NUMBER
, PURCH_LINE_NUM PURCH_LINE_NUM
, SUPPLY_ORDER_NUMBER SUPPLY_ORDER_NUMBER
, SUPPLY_ORG_CODE SUPPLY_ORG_CODE
, SERIAL_NUMBER SERIAL_NUMBER
, DEMAND_SOURCE_LINE_ID DEMAND_SOURCE_LINE_ID
FROM "MSC"."MSC_ST_RESERVATIONS"