View: WIP_FLOW_SCHEDULES_V

Product:	WIP - Work in Process
Description:	Foreign-key data for WIP_FLOW_SCHEDULES
Implementation/DBA Data:	APPS.WIP_FLOW_SCHEDULES_V

View Text

SELECT WFS.WIP_ENTITY_ID
, WFS.ORGANIZATION_ID
, WFS.LAST_UPDATE_DATE
, WFS.LAST_UPDATED_BY
, WFS.CREATION_DATE
, WFS.CREATED_BY
, WFS.LAST_UPDATE_LOGIN
, WFS.REQUEST_ID
, WFS.PROGRAM_APPLICATION_ID
, WFS.PROGRAM_ID
, WFS.PROGRAM_UPDATE_DATE
, WFS.PRIMARY_ITEM_ID
, WFS.CLASS_CODE
, WFS.SCHEDULED_START_DATE
, WFS.DATE_CLOSED
, WFS.PLANNED_QUANTITY
, WFS.QUANTITY_COMPLETED
, WFS.MPS_SCHEDULED_COMPLETION_DATE
, WFS.MPS_NET_QUANTITY
, WFS.BOM_REVISION
, WFS.ROUTING_REVISION
, WFS.BOM_REVISION_DATE
, WFS.ROUTING_REVISION_DATE
, WFS.ALTERNATE_BOM_DESIGNATOR
, WFS.ALTERNATE_ROUTING_DESIGNATOR
, WFS.COMPLETION_SUBINVENTORY
, WFS.COMPLETION_LOCATOR_ID
, WFS.MATERIAL_ACCOUNT
, WFS.MATERIAL_OVERHEAD_ACCOUNT
, WFS.RESOURCE_ACCOUNT
, WFS.OUTSIDE_PROCESSING_ACCOUNT
, WFS.MATERIAL_VARIANCE_ACCOUNT
, WFS.RESOURCE_VARIANCE_ACCOUNT
, WFS.OUTSIDE_PROC_VARIANCE_ACCOUNT
, WFS.STD_COST_ADJUSTMENT_ACCOUNT
, WFS.OVERHEAD_ACCOUNT
, WFS.OVERHEAD_VARIANCE_ACCOUNT
, WFS.DEMAND_CLASS
, WSG.SCHEDULE_GROUP_NAME
, WFS.SCHEDULE_GROUP_ID
, WFS.BUILD_SEQUENCE
, WL.LINE_CODE
, WFS.LINE_ID
, PPA.NAME
, PPA.SEGMENT1
, WFS.PROJECT_ID
, PT.TASK_NAME
, PT.TASK_NUMBER
, WFS.TASK_ID
, WFS.END_ITEM_UNIT_NUMBER
, WFS.SCHEDULE_NUMBER
, WFS.ATTRIBUTE_CATEGORY
, WFS.ATTRIBUTE1
, WFS.ATTRIBUTE2
, WFS.ATTRIBUTE3
, WFS.ATTRIBUTE4
, WFS.ATTRIBUTE5
, WFS.ATTRIBUTE6
, WFS.ATTRIBUTE7
, WFS.ATTRIBUTE8
, WFS.ATTRIBUTE9
, WFS.ATTRIBUTE10
, WFS.ATTRIBUTE11
, WFS.ATTRIBUTE12
, WFS.ATTRIBUTE13
, WFS.ATTRIBUTE14
, WFS.ATTRIBUTE15
, WFS.DEMAND_SOURCE_HEADER_ID
, WFS.DEMAND_SOURCE_LINE
, WFS.DEMAND_SOURCE_DELIVERY
, NULL
, NULL
, WFS.DEMAND_SOURCE_TYPE
, MSIK.CONCATENATED_SEGMENTS
, MSIN.LOCATOR_TYPE
, WFS.SCHEDULED_COMPLETION_DATE
, OOLA.LINE_NUMBER
, WFS.KANBAN_CARD_ID
, WFS.STATUS
FROM WIP_FLOW_SCHEDULES WFS
, OE_ORDER_LINES_ALL OOLA
, WIP_SCHEDULE_GROUPS WSG
, WIP_LINES WL
, PA_PROJECTS_ALL PPA
, PA_TASKS PT
, MTL_SYSTEM_ITEMS_KFV MSIK
, MTL_SECONDARY_INVENTORIES MSIN
WHERE WFS.DEMAND_SOURCE_LINE = OOLA.LINE_ID (+)
AND WSG.SCHEDULE_GROUP_ID (+) = WFS.SCHEDULE_GROUP_ID
AND WL.LINE_ID (+) = WFS.LINE_ID
AND PPA.PROJECT_ID (+) = WFS.PROJECT_ID
AND PT.TASK_ID (+) = WFS.TASK_ID
AND PT.PROJECT_ID (+) = WFS.PROJECT_ID
AND WFS.SCHEDULED_FLAG = 1
AND MSIK.INVENTORY_ITEM_ID = WFS.PRIMARY_ITEM_ID
AND MSIK.ORGANIZATION_ID = WFS.ORGANIZATION_ID
AND MSIN.SECONDARY_INVENTORY_NAME (+) = WFS.COMPLETION_SUBINVENTORY
AND MSIN.ORGANIZATION_ID (+) = WFS.ORGANIZATION_ID

Columns