VIEW: APPS.WIP_FLOW_SCHEDULES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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