VIEW: APPS.MRPFV_FORECAST_ENTRIES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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