VIEW: APPS.WIPFV_WIP_RESERVATIONS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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