VIEW: APPS.MRP_FORECAST_DATES_V

Source

View Text - Preformatted

SELECT FDATE.ROWID , FDATE.TRANSACTION_ID , FDATE.LAST_UPDATE_DATE , FDATE.LAST_UPDATED_BY , FDATE.CREATION_DATE , FDATE.CREATED_BY , FDATE.LAST_UPDATE_LOGIN , FDATE.INVENTORY_ITEM_ID , FDATE.ORGANIZATION_ID , FDATE.FORECAST_DESIGNATOR , FDATE.FORECAST_DATE , FDATE.ORIGINAL_FORECAST_QUANTITY , FDATE.CURRENT_FORECAST_QUANTITY , FDATE.CONFIDENCE_PERCENTAGE , FDATE.BUCKET_TYPE , FDATE.RATE_END_DATE , FDATE.ORIGINATION_TYPE , L1.MEANING , FDATE.CUSTOMER_ID , FDATE.SHIP_ID , FDATE.BILL_ID , FDATE.COMMENTS , FDATE.SOURCE_ORGANIZATION_ID , PARAM.ORGANIZATION_CODE , FDATE.SOURCE_FORECAST_DESIGNATOR , FDATE.SOURCE_CODE , FDATE.SOURCE_LINE_ID , FDATE.END_ITEM_ID , FDATE.END_PLANNING_BOM_PERCENT , FDATE.FORECAST_RULE_ID , FDATE.DEMAND_USAGE_START_DATE , FDATE.FORECAST_TREND , FDATE.FOCUS_TYPE , FDATE.FORECAST_MAD , FDATE.DEMAND_CLASS , FDATE.REQUEST_ID , FDATE.PROGRAM_APPLICATION_ID , FDATE.PROGRAM_ID , FDATE.PROGRAM_UPDATE_DATE , FDATE.DDF_CONTEXT , FDATE.ATTRIBUTE_CATEGORY , FDATE.ATTRIBUTE1 , FDATE.ATTRIBUTE2 , FDATE.ATTRIBUTE3 , FDATE.ATTRIBUTE4 , FDATE.ATTRIBUTE5 , FDATE.ATTRIBUTE6 , FDATE.ATTRIBUTE7 , FDATE.ATTRIBUTE8 , FDATE.ATTRIBUTE9 , FDATE.ATTRIBUTE10 , FDATE.ATTRIBUTE11 , FDATE.ATTRIBUTE12 , FDATE.ATTRIBUTE13 , FDATE.ATTRIBUTE14 , FDATE.ATTRIBUTE15 , FDATE.PROJECT_ID , MRP_GET_PROJECT.PROJECT(FDATE.PROJECT_ID) , FDATE.TASK_ID , MRP_GET_PROJECT.TASK(FDATE.TASK_ID) ,WIP.LINE_ID ,WIP.LINE_CODE , KFV.ITEM_NUMBER FROM WIP_LINES WIP, MTL_ITEM_FLEXFIELDS KFV, MTL_PARAMETERS PARAM, MFG_LOOKUPS L1, MRP_FORECAST_DATES FDATE WHERE FDATE.ORGANIZATION_ID = KFV.ORGANIZATION_ID AND FDATE.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID AND FDATE.ORIGINATION_TYPE = L1.LOOKUP_CODE AND L1.LOOKUP_TYPE = 'MRP_FORECAST_ORIG' AND FDATE.SOURCE_ORGANIZATION_ID = PARAM.ORGANIZATION_ID(+) AND FDATE.LINE_ID = WIP.LINE_ID(+) AND FDATE.ORGANIZATION_ID = WIP.ORGANIZATION_ID(+)

View Text - HTML Formatted

SELECT FDATE.ROWID
, FDATE.TRANSACTION_ID
, FDATE.LAST_UPDATE_DATE
, FDATE.LAST_UPDATED_BY
, FDATE.CREATION_DATE
, FDATE.CREATED_BY
, FDATE.LAST_UPDATE_LOGIN
, FDATE.INVENTORY_ITEM_ID
, FDATE.ORGANIZATION_ID
, FDATE.FORECAST_DESIGNATOR
, FDATE.FORECAST_DATE
, FDATE.ORIGINAL_FORECAST_QUANTITY
, FDATE.CURRENT_FORECAST_QUANTITY
, FDATE.CONFIDENCE_PERCENTAGE
, FDATE.BUCKET_TYPE
, FDATE.RATE_END_DATE
, FDATE.ORIGINATION_TYPE
, L1.MEANING
, FDATE.CUSTOMER_ID
, FDATE.SHIP_ID
, FDATE.BILL_ID
, FDATE.COMMENTS
, FDATE.SOURCE_ORGANIZATION_ID
, PARAM.ORGANIZATION_CODE
, FDATE.SOURCE_FORECAST_DESIGNATOR
, FDATE.SOURCE_CODE
, FDATE.SOURCE_LINE_ID
, FDATE.END_ITEM_ID
, FDATE.END_PLANNING_BOM_PERCENT
, FDATE.FORECAST_RULE_ID
, FDATE.DEMAND_USAGE_START_DATE
, FDATE.FORECAST_TREND
, FDATE.FOCUS_TYPE
, FDATE.FORECAST_MAD
, FDATE.DEMAND_CLASS
, FDATE.REQUEST_ID
, FDATE.PROGRAM_APPLICATION_ID
, FDATE.PROGRAM_ID
, FDATE.PROGRAM_UPDATE_DATE
, FDATE.DDF_CONTEXT
, FDATE.ATTRIBUTE_CATEGORY
, FDATE.ATTRIBUTE1
, FDATE.ATTRIBUTE2
, FDATE.ATTRIBUTE3
, FDATE.ATTRIBUTE4
, FDATE.ATTRIBUTE5
, FDATE.ATTRIBUTE6
, FDATE.ATTRIBUTE7
, FDATE.ATTRIBUTE8
, FDATE.ATTRIBUTE9
, FDATE.ATTRIBUTE10
, FDATE.ATTRIBUTE11
, FDATE.ATTRIBUTE12
, FDATE.ATTRIBUTE13
, FDATE.ATTRIBUTE14
, FDATE.ATTRIBUTE15
, FDATE.PROJECT_ID
, MRP_GET_PROJECT.PROJECT(FDATE.PROJECT_ID)
, FDATE.TASK_ID
, MRP_GET_PROJECT.TASK(FDATE.TASK_ID)
, WIP.LINE_ID
, WIP.LINE_CODE
, KFV.ITEM_NUMBER
FROM WIP_LINES WIP
, MTL_ITEM_FLEXFIELDS KFV
, MTL_PARAMETERS PARAM
, MFG_LOOKUPS L1
, MRP_FORECAST_DATES FDATE
WHERE FDATE.ORGANIZATION_ID = KFV.ORGANIZATION_ID
AND FDATE.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID
AND FDATE.ORIGINATION_TYPE = L1.LOOKUP_CODE
AND L1.LOOKUP_TYPE = 'MRP_FORECAST_ORIG'
AND FDATE.SOURCE_ORGANIZATION_ID = PARAM.ORGANIZATION_ID(+)
AND FDATE.LINE_ID = WIP.LINE_ID(+)
AND FDATE.ORGANIZATION_ID = WIP.ORGANIZATION_ID(+)