View: WIPFV_INTRAOP_STEP_STATUSES

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

View Text

SELECT SC.DESCRIPTION
, ML2.MEANING
, SC.DISABLE_DATE
, SH.WIP_ENTITY_ID
, SH.LINE_ID
, SH.OPERATION_SEQ_NUM
, ML1.MEANING
, SH.SHOP_FLOOR_STATUS_CODE
, EN.WIP_ENTITY_NAME
, LI.LINE_CODE
, PA.ORGANIZATION_CODE
, AL.NAME
, SH.ORGANIZATION_ID
, '_DF:WIP:WIP_SHOP_FLOOR_STATUS_CODES:SC'
, SH.CREATION_DATE
, SH.CREATED_BY
, SH.LAST_UPDATE_DATE
, SH.LAST_UPDATED_BY
FROM WIP_LINES LI
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, WIP_ENTITIES EN
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, WIP_SHOP_FLOOR_STATUS_CODES SC
, WIP_SHOP_FLOOR_STATUSES SH
WHERE SH.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND SH.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND SH.SHOP_FLOOR_STATUS_CODE = SC.SHOP_FLOOR_STATUS_CODE
AND SH.ORGANIZATION_ID = SC.ORGANIZATION_ID
AND SH.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND SH.ORGANIZATION_ID = EN.ORGANIZATION_ID
AND ML1.LOOKUP_TYPE = 'WIP_INTRAOPERATION_STEP'
AND ML1.LOOKUP_CODE = SH.INTRAOPERATION_STEP_TYPE
AND ML2.LOOKUP_TYPE = 'SYS_YES_NO'
AND ML2.LOOKUP_CODE = SC.STATUS_MOVE_FLAG
AND SH.LINE_ID = LI.LINE_ID(+)
AND SH.ORGANIZATION_ID = LI.ORGANIZATION_ID(+)
AND '_SEC:SH.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns