View: MRPFV_FORECAST_ENTRIES

Product:	MRP - Master Scheduling/MRP
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MRPFV_FORECAST_ENTRIES

View Text

SELECT PA.ORGANIZATION_CODE
, AL.NAME
, FO.FORECAST_DESIGNATOR
, '_KF:INV:MSTK:SY'
, '_LA:FO.BUCKET_TYPE:MFG_LOOKUPS:MRP_BUCKET_TYPE:MEANING'
, FO.FORECAST_DATE
, FO.RATE_END_DATE
, FO.CURRENT_FORECAST_QUANTITY
, FO.ORIGINAL_FORECAST_QUANTITY
, FO.CONFIDENCE_PERCENTAGE
, FO.COMMENTS
, '_LA:FO.ORIGINATION_TYPE:MFG_LOOKUPS:MRP_FORECAST_ORIG:MEANING'
, FO.DEMAND_CLASS
, '_KF:INV:MSTK:SY2'
, FO.END_PLANNING_BOM_PERCENT
, PA2.ORGANIZATION_CODE
, AL2.NAME
, FO.SOURCE_FORECAST_DESIGNATOR
, MRP_GET_PROJECT.PROJECT(FO.PROJECT_ID)
, MRP_GET_PROJECT.TASK(FO.TASK_ID)
, LI.LINE_CODE
, FORE.FORECAST_RULE_NAME
, '_DF:MRP:MRP_FORECAST_DATES:FO'
, FO.TRANSACTION_ID
, FO.ORGANIZATION_ID
, FO.INVENTORY_ITEM_ID
, FO.SOURCE_ORGANIZATION_ID
, FO.END_ITEM_ID
, FO.FORECAST_RULE_ID
, FO.PROJECT_ID
, FO.TASK_ID
, FO.LINE_ID
, FO.LAST_UPDATE_DATE
, FO.LAST_UPDATED_BY
, FO.CREATION_DATE
, FO.CREATED_BY
FROM MTL_FORECAST_RULES FORE
, WIP_LINES LI
, HR_ALL_ORGANIZATION_UNITS AL2
, MTL_PARAMETERS PA2
, MTL_SYSTEM_ITEMS SY2
, MTL_SYSTEM_ITEMS SY
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, MRP_FORECAST_DATES FO
WHERE FO.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND FO.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND FO.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND FO.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND FO.ORGANIZATION_ID = SY2.ORGANIZATION_ID(+)
AND FO.END_ITEM_ID = SY2.INVENTORY_ITEM_ID(+)
AND FO.SOURCE_ORGANIZATION_ID = PA2.ORGANIZATION_ID(+)
AND FO.SOURCE_ORGANIZATION_ID = AL2.ORGANIZATION_ID(+)
AND FO.ORGANIZATION_ID = LI.ORGANIZATION_ID(+)
AND FO.LINE_ID = LI.LINE_ID(+)
AND FO.FORECAST_RULE_ID = FORE.FORECAST_RULE_ID(+)
AND '_SEC:FO.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns