VIEW: MRP.MRP_AGGREGATE_RATES#

Source

View Text - Preformatted

select INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, COMPILE_DESIGNATOR COMPILE_DESIGNATOR, FIRST_UNIT_COMPLETION_DATE FIRST_UNIT_COMPLETION_DATE, 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, LAST_UNIT_COMPLETION_DATE LAST_UNIT_COMPLETION_DATE, FIRST_UNIT_START_DATE FIRST_UNIT_START_DATE, LAST_UNIT_START_DATE LAST_UNIT_START_DATE, PROCESSING_DAYS PROCESSING_DAYS, DAILY_RATE DAILY_RATE, REVISION REVISION, MINIMUM_FIRM_RATE MINIMUM_FIRM_RATE, FIRM_PLAN_STATUS_TYPE FIRM_PLAN_STATUS_TYPE, 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 from "MRP"."MRP_AGGREGATE_RATES"

View Text - HTML Formatted

SELECT INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, COMPILE_DESIGNATOR COMPILE_DESIGNATOR
, FIRST_UNIT_COMPLETION_DATE FIRST_UNIT_COMPLETION_DATE
, 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
, LAST_UNIT_COMPLETION_DATE LAST_UNIT_COMPLETION_DATE
, FIRST_UNIT_START_DATE FIRST_UNIT_START_DATE
, LAST_UNIT_START_DATE LAST_UNIT_START_DATE
, PROCESSING_DAYS PROCESSING_DAYS
, DAILY_RATE DAILY_RATE
, REVISION REVISION
, MINIMUM_FIRM_RATE MINIMUM_FIRM_RATE
, FIRM_PLAN_STATUS_TYPE FIRM_PLAN_STATUS_TYPE
, 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
FROM "MRP"."MRP_AGGREGATE_RATES"