VIEW: APPS.OPI_MFG_WO_STATUS_LVL_V

Source

View Text - Preformatted

SELECT lookup_code id, meaning value FROM fnd_lookup_values WHERE lookup_type = 'WIP_JOB_STATUS' and lookup_code in ('3','4','5','6','7','12','14','15') and language = userenv('LANG') and view_application_id = 700 and security_group_id = fnd_global.lookup_security_group(lookup_type,view_application_id)

View Text - HTML Formatted

SELECT LOOKUP_CODE ID
, MEANING VALUE
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'WIP_JOB_STATUS'
AND LOOKUP_CODE IN ('3'
, '4'
, '5'
, '6'
, '7'
, '12'
, '14'
, '15')
AND LANGUAGE = USERENV('LANG')
AND VIEW_APPLICATION_ID = 700
AND SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(LOOKUP_TYPE
, VIEW_APPLICATION_ID)