View: WIP_SHOP_FLOOR_STATUSES_V

Product:	WIP - Work in Process
Description:	Foreign-key data for WIP_SHOP_FLOOR_STATUSES
Implementation/DBA Data:	APPS.WIP_SHOP_FLOOR_STATUSES_V

View Text

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'

Columns