Product: | ICX - Oracle iProcurement |
---|---|
Description: | Forecast Dates View |
Implementation/DBA Data: | APPS.ICX_MRP_FORECAST_DATES_V |
SELECT FDATE.ROWID ROW_ID
, FDATE.TRANSACTION_ID
, FDATE.INVENTORY_ITEM_ID
, FDATE.ORGANIZATION_ID
, FDATE.FORECAST_DESIGNATOR
, FDATE.BUCKET_TYPE
, L2.MEANING BUCKET_TYPE_DESC
, FDATE.FORECAST_DATE
, FDATE.RATE_END_DATE
, FDATE.CURRENT_FORECAST_QUANTITY
, FDATE.ORIGINAL_FORECAST_QUANTITY
, FDATE.CONFIDENCE_PERCENTAGE
, FDATE.ORIGINATION_TYPE
, L1.MEANING ORIGINATION_TYPE_DESC
, 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
, KFV.ITEM_NUMBER END_ITEM_SEGMENT
, FDATE.END_PLANNING_BOM_PERCENT
, FDATE.DEMAND_CLASS
, FDATE.LAST_UPDATE_DATE
, FDATE.LAST_UPDATED_BY
, FDATE.CREATION_DATE
, FDATE.CREATED_BY
, KFV.ITEM_NUMBER ITEM_SEGMENTS
FROM MTL_PARAMETERS PARAM
, MTL_ITEM_FLEXFIELDS KFV
, MFG_LOOKUPS L2
, MFG_LOOKUPS L1
, MRP_FORECAST_DATES FDATE
WHERE FDATE.ORIGINATION_TYPE = L1.LOOKUP_CODE
AND L1.LOOKUP_TYPE = 'MRP_FORECAST_ORIG'
AND FDATE.BUCKET_TYPE = L2.LOOKUP_CODE
AND L2.LOOKUP_TYPE = 'MRP_BUCKET_TYPE'
AND FDATE.ORGANIZATION_ID = KFV.ORGANIZATION_ID(+)
AND FDATE.END_ITEM_ID = KFV.INVENTORY_ITEM_ID(+)
AND FDATE.SOURCE_ORGANIZATION_ID = PARAM.ORGANIZATION_ID(+)