View: WIPBV_MFG_ORDERS

Product:	WIP - Work in Process
Description:
Implementation/DBA Data:	APPS.WIPBV_MFG_ORDERS

View Text

SELECT EN.WIP_ENTITY_NAME
, '_LA:EN.ENTITY_TYPE:MFG_LOOKUPS:WIP_ENTITY:MEANING'
, EN.DESCRIPTION
, DI.QUANTITY_COMPLETED
, DI.SCHEDULED_START_DATE
, DI.SCHEDULED_COMPLETION_DATE
, DI.DATE_CLOSED
, '_LA:DI.STATUS_TYPE:MFG_LOOKUPS:WIP_JOB_STATUS:MEANING'
, DI.BOM_REVISION_DATE
, DI.ROUTING_REVISION_DATE
, DI.ALTERNATE_BOM_DESIGNATOR
, DI.ALTERNATE_ROUTING_DESIGNATOR
, DI.DEMAND_CLASS
, EN.WIP_ENTITY_ID
, EN.ORGANIZATION_ID
, EN.PRIMARY_ITEM_ID
, EN.CREATION_DATE
, EN.CREATED_BY
, EN.LAST_UPDATE_DATE
, EN.LAST_UPDATED_BY
FROM WIP_ENTITIES EN
, WIP_DISCRETE_JOBS DI
WHERE DI.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND DI.ORGANIZATION_ID = EN.ORGANIZATION_ID
AND '_SEC:DI.ORGANIZATION_ID' IS NOT NULL UNION SELECT EN.WIP_ENTITY_NAME
, '_LA:EN.ENTITY_TYPE:MFG_LOOKUPS:WIP_ENTITY:MEANING'
, EN.DESCRIPTION
, RE.QUANTITY_COMPLETED
, RE.FIRST_UNIT_START_DATE
, RE.LAST_UNIT_COMPLETION_DATE
, RE.DATE_CLOSED
, '_LA:RE.STATUS_TYPE:MFG_LOOKUPS:WIP_JOB_STATUS:MEANING'
, RE.BOM_REVISION_DATE
, RE.ROUTING_REVISION_DATE
, RE.ALTERNATE_BOM_DESIGNATOR
, RE.ALTERNATE_ROUTING_DESIGNATOR
, RE.DEMAND_CLASS
, EN.WIP_ENTITY_ID
, EN.ORGANIZATION_ID
, EN.PRIMARY_ITEM_ID
, EN.CREATION_DATE
, EN.CREATED_BY
, EN.LAST_UPDATE_DATE
, EN.LAST_UPDATED_BY
FROM WIP_ENTITIES EN
, WIP_REPETITIVE_SCHEDULES RE
WHERE RE.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND RE.ORGANIZATION_ID = EN.ORGANIZATION_ID
AND '_SEC:RE.ORGANIZATION_ID' IS NOT NULL UNION SELECT EN.WIP_ENTITY_NAME
, '_LA:EN.ENTITY_TYPE:MFG_LOOKUPS:WIP_ENTITY:MEANING'
, EN.DESCRIPTION
, FL.QUANTITY_COMPLETED
, FL.SCHEDULED_START_DATE
, FL.SCHEDULED_COMPLETION_DATE
, FL.DATE_CLOSED
, '_LA:FL.STATUS:MFG_LOOKUPS:WIP_FLOW_SCHEDULE_STATUS:MEANING'
, FL.BOM_REVISION_DATE
, FL.ROUTING_REVISION_DATE
, FL.ALTERNATE_BOM_DESIGNATOR
, FL.ALTERNATE_ROUTING_DESIGNATOR
, FL.DEMAND_CLASS
, EN.WIP_ENTITY_ID
, EN.ORGANIZATION_ID
, EN.PRIMARY_ITEM_ID
, EN.CREATION_DATE
, EN.CREATED_BY
, EN.LAST_UPDATE_DATE
, EN.LAST_UPDATED_BY
FROM WIP_ENTITIES EN
, WIP_FLOW_SCHEDULES FL
WHERE FL.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND FL.ORGANIZATION_ID = EN.ORGANIZATION_ID
AND '_SEC:FL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns