View: WIPFV_WIP_RESERVATIONS

Product:	WIP - Work in Process
Description:
Implementation/DBA Data:	APPS.WIPFV_WIP_RESERVATIONS

View Text

SELECT SO.QUANTITY_ALLOCATED
, SO.QUANTITY_COMPLETED
, SO.DEMAND_CLASS
, SO.USER_DELIVERY
, SO.DEMAND_SOURCE_DELIVERY
, SO.USER_LINE_NUM
, SO.DEMAND_SOURCE_LINE
, '_KF:INV:MKTS:SA'
, EN.WIP_ENTITY_NAME
, PA.ORGANIZATION_CODE
, AL.NAME
, SO.ALLOCATION_ID
, SO.WIP_ENTITY_ID
, SO.ORGANIZATION_ID
, SO.DEMAND_SOURCE_HEADER_ID
, SO.CREATION_DATE
, SO.CREATED_BY
, SO.LAST_UPDATE_DATE
, SO.LAST_UPDATED_BY
FROM MTL_SALES_ORDERS SA
, WIP_DISCRETE_JOBS DI
, WIP_ENTITIES EN
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, WIP_SO_ALLOCATIONS SO
WHERE SO.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND SO.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND SO.WIP_ENTITY_ID = DI.WIP_ENTITY_ID
AND SO.ORGANIZATION_ID = DI.ORGANIZATION_ID
AND SO.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND SO.DEMAND_SOURCE_HEADER_ID= SA.SALES_ORDER_ID
AND '_SEC:SO.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns