VIEW: APPS.ICX_MRP_FORECAST_DATES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)