View: WIP_FLOW_OPEN_ALLOCATIONS_V

Product:	WIP - Work in Process
Description:	Open allocations for flow schedules
Implementation/DBA Data:	APPS.WIP_FLOW_OPEN_ALLOCATIONS_V

View Text

SELECT WL.LINE_CODE
, WL.DESCRIPTION LINE_DESCRIPTION
, WL.LINE_ID
, ((WL.STOP_TIME - WL.START_TIME)/3600) * WL.MAXIMUM_RATE LINE_RATE
, WFS.SCHEDULE_NUMBER
, WFS.ORGANIZATION_ID
, MSIK.CONCATENATED_SEGMENTS PRIMARY_ITEM
, MSIK.INVENTORY_ITEM_ID PRIMARY_ITEM_ID
, MSIK.DESCRIPTION PRIMARY_ITEM_DESCRIPTION
, MSIK.PRIMARY_UOM_CODE
, WFS.SCHEDULED_START_DATE
, WFS.SCHEDULED_COMPLETION_DATE
, WFS.PLANNED_QUANTITY SCHEDULE_QUANTITY
, WFS.BUILD_SEQUENCE
, WFS.PROJECT_ID
, WFS.TASK_ID
, WSG.SCHEDULE_GROUP_NAME
, WFS.ALTERNATE_BOM_DESIGNATOR
, WFS.ALTERNATE_ROUTING_DESIGNATOR
, WFS.WIP_ENTITY_ID
, WFS.DEMAND_SOURCE_HEADER_ID
FROM WIP_FLOW_SCHEDULES WFS
, WIP_SCHEDULE_GROUPS WSG
, WIP_LINES WL
, MTL_SYSTEM_ITEMS_KFV MSIK
WHERE WFS.STATUS = 1
AND WFS.LINE_ID = WL.LINE_ID
AND WFS.SCHEDULE_GROUP_ID = WSG.SCHEDULE_GROUP_ID (+)
AND WFS.ORGANIZATION_ID = WSG.ORGANIZATION_ID (+)
AND WFS.STATUS = 1
AND MSIK.INVENTORY_ITEM_ID = WFS.PRIMARY_ITEM_ID
AND MSIK.ORGANIZATION_ID = WFS.ORGANIZATION_ID
AND ( WFS.ALLOCATED_FLAG IS NULL OR WFS.ALLOCATED_FLAG = 'N')

Columns