VIEW: APPS.WIPFV_MFG_ORDERS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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