VIEW: MRP.MRP_RESERVATIONS#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, 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, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, COMPILE_DESIGNATOR COMPILE_DESIGNATOR, ORGANIZATION_ID ORGANIZATION_ID, RESERVATION_DATE RESERVATION_DATE, REQUIREMENT_DATE REQUIREMENT_DATE, RESERVED_QUANTITY RESERVED_QUANTITY, NONNET_QUANTITY_RESERVED NONNET_QUANTITY_RESERVED, DISPOSITION_TYPE DISPOSITION_TYPE, DISPOSITION_ID DISPOSITION_ID, PARENT_DEMAND_ID PARENT_DEMAND_ID, SUBINVENTORY SUBINVENTORY, DEMAND_CLASS DEMAND_CLASS, REVISION REVISION, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, PLANNING_GROUP PLANNING_GROUP from "MRP"."MRP_RESERVATIONS"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, 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
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, COMPILE_DESIGNATOR COMPILE_DESIGNATOR
, ORGANIZATION_ID ORGANIZATION_ID
, RESERVATION_DATE RESERVATION_DATE
, REQUIREMENT_DATE REQUIREMENT_DATE
, RESERVED_QUANTITY RESERVED_QUANTITY
, NONNET_QUANTITY_RESERVED NONNET_QUANTITY_RESERVED
, DISPOSITION_TYPE DISPOSITION_TYPE
, DISPOSITION_ID DISPOSITION_ID
, PARENT_DEMAND_ID PARENT_DEMAND_ID
, SUBINVENTORY SUBINVENTORY
, DEMAND_CLASS DEMAND_CLASS
, REVISION REVISION
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, PLANNING_GROUP PLANNING_GROUP
FROM "MRP"."MRP_RESERVATIONS"