VIEW: APPS.WIPFV_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 , '_DF:WIP:WIP_SHOP_FLOOR_STATUS_CODES:sh' /* 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
, '_DF:WIP:WIP_SHOP_FLOOR_STATUS_CODES:SH' /* 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