Product: | WIP - Work in Process |
---|---|
Description: | |
Implementation/DBA Data: |
![]() |
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