VIEW: MRP.MRP_GROSS_REQUIREMENTS#

Source

View Text - Preformatted

select DEMAND_ID DEMAND_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, ORGANIZATION_ID ORGANIZATION_ID, COMPILE_DESIGNATOR COMPILE_DESIGNATOR, USING_ASSEMBLY_ITEM_ID USING_ASSEMBLY_ITEM_ID, USING_ASSEMBLY_DEMAND_DATE USING_ASSEMBLY_DEMAND_DATE, USING_REQUIREMENTS_QUANTITY USING_REQUIREMENTS_QUANTITY, ASSEMBLY_DEMAND_COMP_DATE ASSEMBLY_DEMAND_COMP_DATE, DEMAND_TYPE DEMAND_TYPE, ORIGINATION_TYPE ORIGINATION_TYPE, DISPOSITION_ID DISPOSITION_ID, DAILY_DEMAND_RATE DAILY_DEMAND_RATE, REQUEST_ID REQUEST_ID, RESERVE_QUANTITY RESERVE_QUANTITY, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, RESERVATION_ID RESERVATION_ID, UPDATED UPDATED, STATUS STATUS, APPLIED APPLIED, DEMAND_CLASS DEMAND_CLASS, FIRM_QUANTITY FIRM_QUANTITY, FIRM_DATE FIRM_DATE, OLD_DEMAND_QUANTITY OLD_DEMAND_QUANTITY, DEMAND_SCHEDULE_NAME DEMAND_SCHEDULE_NAME, OLD_DEMAND_DATE OLD_DEMAND_DATE, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, PLANNING_GROUP PLANNING_GROUP, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER, LENDING_PROJECT_ID LENDING_PROJECT_ID, LENDING_TASK_ID LENDING_TASK_ID from "MRP"."MRP_GROSS_REQUIREMENTS"

View Text - HTML Formatted

SELECT DEMAND_ID DEMAND_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
, ORGANIZATION_ID ORGANIZATION_ID
, COMPILE_DESIGNATOR COMPILE_DESIGNATOR
, USING_ASSEMBLY_ITEM_ID USING_ASSEMBLY_ITEM_ID
, USING_ASSEMBLY_DEMAND_DATE USING_ASSEMBLY_DEMAND_DATE
, USING_REQUIREMENTS_QUANTITY USING_REQUIREMENTS_QUANTITY
, ASSEMBLY_DEMAND_COMP_DATE ASSEMBLY_DEMAND_COMP_DATE
, DEMAND_TYPE DEMAND_TYPE
, ORIGINATION_TYPE ORIGINATION_TYPE
, DISPOSITION_ID DISPOSITION_ID
, DAILY_DEMAND_RATE DAILY_DEMAND_RATE
, REQUEST_ID REQUEST_ID
, RESERVE_QUANTITY RESERVE_QUANTITY
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, RESERVATION_ID RESERVATION_ID
, UPDATED UPDATED
, STATUS STATUS
, APPLIED APPLIED
, DEMAND_CLASS DEMAND_CLASS
, FIRM_QUANTITY FIRM_QUANTITY
, FIRM_DATE FIRM_DATE
, OLD_DEMAND_QUANTITY OLD_DEMAND_QUANTITY
, DEMAND_SCHEDULE_NAME DEMAND_SCHEDULE_NAME
, OLD_DEMAND_DATE OLD_DEMAND_DATE
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, PLANNING_GROUP PLANNING_GROUP
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
, LENDING_PROJECT_ID LENDING_PROJECT_ID
, LENDING_TASK_ID LENDING_TASK_ID
FROM "MRP"."MRP_GROSS_REQUIREMENTS"