View: ICX_MRP_FORECAST_ITEMS_V

View Text

SELECT MFI.ROWID ROW_ID
, MFD.FORECAST_SET
, MFI.FORECAST_DESIGNATOR
, MFD.CUSTOMER_ID
, CUST.CUSTOMER_NAME
, MFD.BILL_ID
, BILL.CITY || '
, ' || BILL.STATE BILL_ADDRESS
, MFD.SHIP_ID
, SHIP.CITY || '
, ' || SHIP.STATE SHIP_ADDRESS
, MFI.INVENTORY_ITEM_ID
, KFV.ITEM_NUMBER
, KFV.DESCRIPTION
, KFV.PRIMARY_UOM_CODE
, KFV.BOM_ITEM_TYPE
, L1.MEANING BOM_ITEM_TYPE_DESC
, MFI.ORGANIZATION_ID
, MFI.LAST_UPDATE_DATE
, MFI.LAST_UPDATED_BY
, MFI.CREATION_DATE
, MFI.CREATED_BY
, KFV.ATTRIBUTE14 ITEM_URL
, MTL.PRODUCT_FAMILY_ITEM_ID
FROM MFG_LOOKUPS L1
, RA_ADDRESSES_ALL BILL
, RA_SITE_USES_ALL BILLSU
, RA_ADDRESSES_ALL SHIP
, RA_SITE_USES_ALL SHIPSU
, RA_CUSTOMERS_VIEW CUST
, MTL_ITEM_FLEXFIELDS KFV
, MTL_SYSTEM_ITEMS MTL
, MRP_FORECAST_ITEMS MFI
, MRP_FORECAST_DESIGNATORS MFD
WHERE MFI.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID
AND MFI.ORGANIZATION_ID = KFV.ORGANIZATION_ID
AND KFV.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID
AND KFV.ORGANIZATION_ID = MTL.ORGANIZATION_ID
AND MFD.FORECAST_DESIGNATOR = MFI.FORECAST_DESIGNATOR
AND MFD.ORGANIZATION_ID = MFI.ORGANIZATION_ID
AND MFD.CUSTOMER_ID = CUST.CUSTOMER_ID(+)
AND MFD.BILL_ID = BILLSU.SITE_USE_ID(+)
AND BILLSU.SITE_USE_CODE(+) = 'BILL_TO'
AND BILLSU.ADDRESS_ID = BILL.ADDRESS_ID(+)
AND MFD.SHIP_ID = SHIPSU.SITE_USE_ID(+)
AND SHIPSU.SITE_USE_CODE(+) = 'SHIP_TO'
AND SHIPSU.ADDRESS_ID = SHIP.ADDRESS_ID(+)
AND L1.LOOKUP_CODE = KFV.BOM_ITEM_TYPE
AND L1.LOOKUP_TYPE = 'BOM_ITEM_TYPE'

Columns