VIEW: APPS.WIPBV_WIP_STATUS_CODES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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