FND Design Data [Home] [Help]

View: WIPBV_FLOW_SCHEDULES

Product: WIP - Work in Process
Description:
Implementation/DBA Data: ViewAPPS.WIPBV_FLOW_SCHEDULES
View Text

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

Columns

Name
MFG_ORDER_NAME
"_LA:MFG_ORDER_TYPE"
"_LA:MFG_ORDER_STATUS"
SCHEDULED_FLAG
PLANNED_QUANTITY
COMPLETED_QUANTITY
MPS_NET_QUANTITY
BUILD_SEQUENCE
SCHEDULE_NUMBER
SCHEDULED_START_DATE
SCHEDULED_COMPLETION_DATE
CLOSED_DATE
BOM_REVISION_DATE
ROUTING_REVISION_DATE
ALTERNATE_BOM_DESIGNATOR
ALTERNATE_ROUTING_DESIGNATOR
DEMAND_CLASS
SCRAPPED_QUANTITY
END_ITEM_UNIT_NUMBER
WIP_ENTITY_ID
ORGANIZATION_ID
PRIMARY_ITEM_ID
CLASS_CODE
BOM_REVISION
ROUTING_REVISION
COMPLETION_SUBINVENTORY
COMPLETION_LOCATOR_ID
SCHEDULE_GROUP_ID
LINE_ID
PROJECT_ID
TASK_ID
KANBAN_CARD_ID
MATERIAL_ACCOUNT
MATERIAL_OVERHEAD_ACCOUNT
RESOURCE_ACCOUNT
OUTSIDE_PROCESSING_ACCOUNT
MATERIAL_VARIANCE_ACCOUNT
RESOURCE_VARIANCE_ACCOUNT
OUTSIDE_PROC_VARIANCE_ACCOUNT
STD_COST_ADJUSTMENT_ACCOUNT
OVERHEAD_ACCOUNT
OVERHEAD_VARIANCE_ACCOUNT
CREATED_DATE
CREATED_BY
UPDATED_DATE
UPDATED_BY