View: WIPBV_WIP_STATUS_CODES

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

View Text

SELECT /* REGULAR ATTRIBUTES */ SH.SHOP_FLOOR_STATUS_CODE
, SH.ORGANIZATION_ID
, SH.DISABLE_DATE
, SH.DESCRIPTION
, LO.MEANING
, /* RESOLVED FOREIGN KEYS */ PA.ORGANIZATION_CODE
, AL.NAME
, /* WHO */ SH.CREATION_DATE
, SH.CREATED_BY
, SH.LAST_UPDATE_DATE
, SH.LAST_UPDATED_BY
FROM MFG_LOOKUPS LO
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, WIP_SHOP_FLOOR_STATUS_CODES SH
WHERE SH.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND SH.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND LO.LOOKUP_CODE = SH.STATUS_MOVE_FLAG
AND LO.LOOKUP_TYPE = 'SYS_YES_NO'
AND '_SEC:SH.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns