VIEW: APPS.WIPBV_FLOW_SCHEDULES

Source

View Text - Preformatted

SELECT EN.WIP_ENTITY_NAME , '_LA:en.entity_type:MFG_LOOKUPS:WIP_ENTITY:MEANING' , '_LA:fl.status:MFG_LOOKUPS:WIP_FLOW_SCHEDULE_STATUS:MEANING' , FL.SCHEDULED_FLAG , FL.PLANNED_QUANTITY , FL.QUANTITY_COMPLETED , FL.MPS_NET_QUANTITY , FL.BUILD_SEQUENCE , FL.SCHEDULE_NUMBER , FL.SCHEDULED_START_DATE , FL.MPS_SCHEDULED_COMPLETION_DATE , FL.DATE_CLOSED , FL.BOM_REVISION_DATE , FL.ROUTING_REVISION_DATE , FL.ALTERNATE_BOM_DESIGNATOR , FL.ALTERNATE_ROUTING_DESIGNATOR , FL.DEMAND_CLASS , FL.QUANTITY_SCRAPPED , FL.END_ITEM_UNIT_NUMBER , FL.WIP_ENTITY_ID , FL.ORGANIZATION_ID , FL.PRIMARY_ITEM_ID , FL.CLASS_CODE , FL.BOM_REVISION , FL.ROUTING_REVISION , FL.COMPLETION_SUBINVENTORY , FL.COMPLETION_LOCATOR_ID , FL.SCHEDULE_GROUP_ID , FL.LINE_ID , FL.PROJECT_ID , FL.TASK_ID , FL.KANBAN_CARD_ID , FL.MATERIAL_ACCOUNT , FL.MATERIAL_OVERHEAD_ACCOUNT , FL.RESOURCE_ACCOUNT , FL.OUTSIDE_PROCESSING_ACCOUNT , FL.MATERIAL_VARIANCE_ACCOUNT , FL.RESOURCE_VARIANCE_ACCOUNT , FL.OUTSIDE_PROC_VARIANCE_ACCOUNT , FL.STD_COST_ADJUSTMENT_ACCOUNT , FL.OVERHEAD_ACCOUNT , FL.OVERHEAD_VARIANCE_ACCOUNT , FL.CREATION_DATE , FL.CREATED_BY , FL.LAST_UPDATE_DATE , FL.LAST_UPDATED_BY FROM WIP_ENTITIES EN , WIP_FLOW_SCHEDULES FL WHERE FL.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND '_SEC:fl.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT EN.WIP_ENTITY_NAME
, '_LA:EN.ENTITY_TYPE:MFG_LOOKUPS:WIP_ENTITY:MEANING'
, '_LA:FL.STATUS:MFG_LOOKUPS:WIP_FLOW_SCHEDULE_STATUS:MEANING'
, FL.SCHEDULED_FLAG
, FL.PLANNED_QUANTITY
, FL.QUANTITY_COMPLETED
, FL.MPS_NET_QUANTITY
, FL.BUILD_SEQUENCE
, FL.SCHEDULE_NUMBER
, FL.SCHEDULED_START_DATE
, FL.MPS_SCHEDULED_COMPLETION_DATE
, FL.DATE_CLOSED
, FL.BOM_REVISION_DATE
, FL.ROUTING_REVISION_DATE
, FL.ALTERNATE_BOM_DESIGNATOR
, FL.ALTERNATE_ROUTING_DESIGNATOR
, FL.DEMAND_CLASS
, FL.QUANTITY_SCRAPPED
, FL.END_ITEM_UNIT_NUMBER
, FL.WIP_ENTITY_ID
, FL.ORGANIZATION_ID
, FL.PRIMARY_ITEM_ID
, FL.CLASS_CODE
, FL.BOM_REVISION
, FL.ROUTING_REVISION
, FL.COMPLETION_SUBINVENTORY
, FL.COMPLETION_LOCATOR_ID
, FL.SCHEDULE_GROUP_ID
, FL.LINE_ID
, FL.PROJECT_ID
, FL.TASK_ID
, FL.KANBAN_CARD_ID
, FL.MATERIAL_ACCOUNT
, FL.MATERIAL_OVERHEAD_ACCOUNT
, FL.RESOURCE_ACCOUNT
, FL.OUTSIDE_PROCESSING_ACCOUNT
, FL.MATERIAL_VARIANCE_ACCOUNT
, FL.RESOURCE_VARIANCE_ACCOUNT
, FL.OUTSIDE_PROC_VARIANCE_ACCOUNT
, FL.STD_COST_ADJUSTMENT_ACCOUNT
, FL.OVERHEAD_ACCOUNT
, FL.OVERHEAD_VARIANCE_ACCOUNT
, FL.CREATION_DATE
, FL.CREATED_BY
, FL.LAST_UPDATE_DATE
, FL.LAST_UPDATED_BY
FROM WIP_ENTITIES EN
, WIP_FLOW_SCHEDULES FL
WHERE FL.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND '_SEC:FL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY