VIEW: APPS.WIP_SHOP_FLOOR_STATUSES_V

Source

View Text - Preformatted

SELECT WSFS.ROWID ROW_ID , WSFS.CREATION_DATE , WSFS.CREATED_BY , WSFS.LAST_UPDATE_DATE , WSFS.LAST_UPDATED_BY , WSFS.LAST_UPDATE_LOGIN , WSFS.ORGANIZATION_ID , WSFS.WIP_ENTITY_ID , WSFS.LINE_ID , WO.REPETITIVE_SCHEDULE_ID , WSFS.OPERATION_SEQ_NUM , BD.DEPARTMENT_CODE , WSFS.INTRAOPERATION_STEP_TYPE , ML.MEANING INTRAOPERATION_STEP_MEANING , WSFS.SHOP_FLOOR_STATUS_CODE , WSFSC.DESCRIPTION , WSFSC.STATUS_MOVE_FLAG , WSFS.ATTRIBUTE_CATEGORY , WSFS.ATTRIBUTE1 , WSFS.ATTRIBUTE2 , WSFS.ATTRIBUTE3 , WSFS.ATTRIBUTE4 , WSFS.ATTRIBUTE5 , WSFS.ATTRIBUTE6 , WSFS.ATTRIBUTE7 , WSFS.ATTRIBUTE8 , WSFS.ATTRIBUTE9 , WSFS.ATTRIBUTE10 , WSFS.ATTRIBUTE11 , WSFS.ATTRIBUTE12 , WSFS.ATTRIBUTE13 , WSFS.ATTRIBUTE14 , WSFS.ATTRIBUTE15 FROM MFG_LOOKUPS ML , BOM_DEPARTMENTS BD , WIP_OPERATIONS WO , WIP_SHOP_FLOOR_STATUS_CODES WSFSC , WIP_SHOP_FLOOR_STATUSES WSFS WHERE WSFS.ORGANIZATION_ID = WSFSC.ORGANIZATION_ID AND WSFS.SHOP_FLOOR_STATUS_CODE = WSFSC.SHOP_FLOOR_STATUS_CODE AND WO.ORGANIZATION_ID = WSFS.ORGANIZATION_ID AND WO.WIP_ENTITY_ID = WSFS.WIP_ENTITY_ID AND WO.OPERATION_SEQ_NUM = WSFS.OPERATION_SEQ_NUM AND BD.DEPARTMENT_ID = WO.DEPARTMENT_ID AND ML.LOOKUP_CODE = WSFS.INTRAOPERATION_STEP_TYPE AND ML.LOOKUP_TYPE = 'WIP_INTRAOPERATION_STEP'

View Text - HTML Formatted

SELECT WSFS.ROWID ROW_ID
, WSFS.CREATION_DATE
, WSFS.CREATED_BY
, WSFS.LAST_UPDATE_DATE
, WSFS.LAST_UPDATED_BY
, WSFS.LAST_UPDATE_LOGIN
, WSFS.ORGANIZATION_ID
, WSFS.WIP_ENTITY_ID
, WSFS.LINE_ID
, WO.REPETITIVE_SCHEDULE_ID
, WSFS.OPERATION_SEQ_NUM
, BD.DEPARTMENT_CODE
, WSFS.INTRAOPERATION_STEP_TYPE
, ML.MEANING INTRAOPERATION_STEP_MEANING
, WSFS.SHOP_FLOOR_STATUS_CODE
, WSFSC.DESCRIPTION
, WSFSC.STATUS_MOVE_FLAG
, WSFS.ATTRIBUTE_CATEGORY
, WSFS.ATTRIBUTE1
, WSFS.ATTRIBUTE2
, WSFS.ATTRIBUTE3
, WSFS.ATTRIBUTE4
, WSFS.ATTRIBUTE5
, WSFS.ATTRIBUTE6
, WSFS.ATTRIBUTE7
, WSFS.ATTRIBUTE8
, WSFS.ATTRIBUTE9
, WSFS.ATTRIBUTE10
, WSFS.ATTRIBUTE11
, WSFS.ATTRIBUTE12
, WSFS.ATTRIBUTE13
, WSFS.ATTRIBUTE14
, WSFS.ATTRIBUTE15
FROM MFG_LOOKUPS ML
, BOM_DEPARTMENTS BD
, WIP_OPERATIONS WO
, WIP_SHOP_FLOOR_STATUS_CODES WSFSC
, WIP_SHOP_FLOOR_STATUSES WSFS
WHERE WSFS.ORGANIZATION_ID = WSFSC.ORGANIZATION_ID
AND WSFS.SHOP_FLOOR_STATUS_CODE = WSFSC.SHOP_FLOOR_STATUS_CODE
AND WO.ORGANIZATION_ID = WSFS.ORGANIZATION_ID
AND WO.WIP_ENTITY_ID = WSFS.WIP_ENTITY_ID
AND WO.OPERATION_SEQ_NUM = WSFS.OPERATION_SEQ_NUM
AND BD.DEPARTMENT_ID = WO.DEPARTMENT_ID
AND ML.LOOKUP_CODE = WSFS.INTRAOPERATION_STEP_TYPE
AND ML.LOOKUP_TYPE = 'WIP_INTRAOPERATION_STEP'