VIEW: APPS.MRP_FORECAST_DESIGNATORS_V

Source

View Text - Preformatted

SELECT M.ROWID ROW_ID , M.FORECAST_DESIGNATOR , M.ORGANIZATION_ID , M.LAST_UPDATE_DATE , M.LAST_UPDATED_BY , M.CREATION_DATE , M.CREATED_BY , M.LAST_UPDATE_LOGIN , M.DESCRIPTION , M.CONSUME_FORECAST , M.UPDATE_TYPE , M.DISABLE_DATE , M.FOREWARD_UPDATE_TIME_FENCE , M.BACKWARD_UPDATE_TIME_FENCE , M.OUTLIER_UPDATE_PERCENTAGE , M.FORECAST_SET , M.CUSTOMER_ID , MRP_MANAGER_PK.GET_CUSTOMER_NAME(M.CUSTOMER_ID) , M.SHIP_ID , MRP_MANAGER_PK.GET_SHIP_ADDRESS(M.SHIP_ID) , M.BILL_ID , MRP_MANAGER_PK.GET_BILL_ADDRESS(M.BILL_ID) , M.DDF_CONTEXT , M.DEMAND_CLASS , M.BUCKET_TYPE , M.REQUEST_ID , M.PROGRAM_APPLICATION_ID , M.PROGRAM_ID , M.PROGRAM_UPDATE_DATE , M.ATTRIBUTE_CATEGORY , M.ATTRIBUTE1 , M.ATTRIBUTE2 , M.ATTRIBUTE3 , M.ATTRIBUTE4 , M.ATTRIBUTE5 , M.ATTRIBUTE6 , M.ATTRIBUTE7 , M.ATTRIBUTE8 , M.ATTRIBUTE9 , M.ATTRIBUTE10 , M.ATTRIBUTE11 , M.ATTRIBUTE12 , M.ATTRIBUTE13 , M.ATTRIBUTE14 , M.ATTRIBUTE15 ,M.APS_COLLECTION_FLAG FROM MRP_FORECAST_DESIGNATORS M

View Text - HTML Formatted

SELECT M.ROWID ROW_ID
, M.FORECAST_DESIGNATOR
, M.ORGANIZATION_ID
, M.LAST_UPDATE_DATE
, M.LAST_UPDATED_BY
, M.CREATION_DATE
, M.CREATED_BY
, M.LAST_UPDATE_LOGIN
, M.DESCRIPTION
, M.CONSUME_FORECAST
, M.UPDATE_TYPE
, M.DISABLE_DATE
, M.FOREWARD_UPDATE_TIME_FENCE
, M.BACKWARD_UPDATE_TIME_FENCE
, M.OUTLIER_UPDATE_PERCENTAGE
, M.FORECAST_SET
, M.CUSTOMER_ID
, MRP_MANAGER_PK.GET_CUSTOMER_NAME(M.CUSTOMER_ID)
, M.SHIP_ID
, MRP_MANAGER_PK.GET_SHIP_ADDRESS(M.SHIP_ID)
, M.BILL_ID
, MRP_MANAGER_PK.GET_BILL_ADDRESS(M.BILL_ID)
, M.DDF_CONTEXT
, M.DEMAND_CLASS
, M.BUCKET_TYPE
, M.REQUEST_ID
, M.PROGRAM_APPLICATION_ID
, M.PROGRAM_ID
, M.PROGRAM_UPDATE_DATE
, M.ATTRIBUTE_CATEGORY
, M.ATTRIBUTE1
, M.ATTRIBUTE2
, M.ATTRIBUTE3
, M.ATTRIBUTE4
, M.ATTRIBUTE5
, M.ATTRIBUTE6
, M.ATTRIBUTE7
, M.ATTRIBUTE8
, M.ATTRIBUTE9
, M.ATTRIBUTE10
, M.ATTRIBUTE11
, M.ATTRIBUTE12
, M.ATTRIBUTE13
, M.ATTRIBUTE14
, M.ATTRIBUTE15
, M.APS_COLLECTION_FLAG
FROM MRP_FORECAST_DESIGNATORS M