VIEW: MRP.MRP_SCHEDULE_DATES#

Source

View Text - Preformatted

select MPS_TRANSACTION_ID MPS_TRANSACTION_ID, SCHEDULE_LEVEL SCHEDULE_LEVEL, SUPPLY_DEMAND_TYPE SUPPLY_DEMAND_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, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, SCHEDULE_DESIGNATOR SCHEDULE_DESIGNATOR, SCHEDULE_DATE SCHEDULE_DATE, SCHEDULE_WORKDATE SCHEDULE_WORKDATE, RATE_END_DATE RATE_END_DATE, SCHEDULE_QUANTITY SCHEDULE_QUANTITY, ORIGINAL_SCHEDULE_QUANTITY ORIGINAL_SCHEDULE_QUANTITY, REPETITIVE_DAILY_RATE REPETITIVE_DAILY_RATE, SCHEDULE_ORIGINATION_TYPE SCHEDULE_ORIGINATION_TYPE, SOURCE_FORECAST_DESIGNATOR SOURCE_FORECAST_DESIGNATOR, REFERENCE_SCHEDULE_ID REFERENCE_SCHEDULE_ID, SCHEDULE_COMMENTS SCHEDULE_COMMENTS, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_SCHEDULE_DESIGNATOR SOURCE_SCHEDULE_DESIGNATOR, SOURCE_SALES_ORDER_ID SOURCE_SALES_ORDER_ID, SOURCE_CODE SOURCE_CODE, SOURCE_LINE_ID SOURCE_LINE_ID, RESERVATION_ID RESERVATION_ID, FORECAST_ID FORECAST_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, OLD_TRANSACTION_ID OLD_TRANSACTION_ID, TO_UPDATE TO_UPDATE, DDF_CONTEXT DDF_CONTEXT, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, LINE_ID LINE_ID, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER from "MRP"."MRP_SCHEDULE_DATES"

View Text - HTML Formatted

SELECT MPS_TRANSACTION_ID MPS_TRANSACTION_ID
, SCHEDULE_LEVEL SCHEDULE_LEVEL
, SUPPLY_DEMAND_TYPE SUPPLY_DEMAND_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
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SCHEDULE_DESIGNATOR SCHEDULE_DESIGNATOR
, SCHEDULE_DATE SCHEDULE_DATE
, SCHEDULE_WORKDATE SCHEDULE_WORKDATE
, RATE_END_DATE RATE_END_DATE
, SCHEDULE_QUANTITY SCHEDULE_QUANTITY
, ORIGINAL_SCHEDULE_QUANTITY ORIGINAL_SCHEDULE_QUANTITY
, REPETITIVE_DAILY_RATE REPETITIVE_DAILY_RATE
, SCHEDULE_ORIGINATION_TYPE SCHEDULE_ORIGINATION_TYPE
, SOURCE_FORECAST_DESIGNATOR SOURCE_FORECAST_DESIGNATOR
, REFERENCE_SCHEDULE_ID REFERENCE_SCHEDULE_ID
, SCHEDULE_COMMENTS SCHEDULE_COMMENTS
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SOURCE_SCHEDULE_DESIGNATOR SOURCE_SCHEDULE_DESIGNATOR
, SOURCE_SALES_ORDER_ID SOURCE_SALES_ORDER_ID
, SOURCE_CODE SOURCE_CODE
, SOURCE_LINE_ID SOURCE_LINE_ID
, RESERVATION_ID RESERVATION_ID
, FORECAST_ID FORECAST_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, OLD_TRANSACTION_ID OLD_TRANSACTION_ID
, TO_UPDATE TO_UPDATE
, DDF_CONTEXT DDF_CONTEXT
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, LINE_ID LINE_ID
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
FROM "MRP"."MRP_SCHEDULE_DATES"