View: WIPFV_MFG_ORDERS

Product:	WIP - Work in Process
Description:
Implementation/DBA Data:	APPS.WIPFV_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
, PA.ORGANIZATION_CODE
, AL.NAME
, '_KF:INV:MSTK:SY'
, 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 MTL_SYSTEM_ITEMS SY
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, WIP_ENTITIES EN
, WIP_DISCRETE_JOBS DI
WHERE DI.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND DI.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND DI.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND DI.PRIMARY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND DI.ORGANIZATION_ID = SY.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
, PA.ORGANIZATION_CODE
, AL.NAME
, '_KF:INV:MSTK:SY'
, 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 MTL_SYSTEM_ITEMS SY
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, WIP_ENTITIES EN
, WIP_REPETITIVE_ITEMS IT
, WIP_REPETITIVE_SCHEDULES RE
WHERE RE.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND RE.WIP_ENTITY_ID = IT.WIP_ENTITY_ID
AND RE.LINE_ID = IT.LINE_ID
AND RE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND RE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND IT.PRIMARY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND IT.ORGANIZATION_ID = SY.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
, PA.ORGANIZATION_CODE
, AL.NAME
, '_KF:INV:MSTK:SY'
, 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 MTL_SYSTEM_ITEMS SY
, WIP_ENTITIES EN
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, WIP_FLOW_SCHEDULES FL
WHERE FL.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND FL.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND FL.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND FL.PRIMARY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND FL.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND '_SEC:FL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns