VIEW: APPS.ENI_RESOURCE_DEPARTMENT_V

Source

View Text - Preformatted

SELECT DEPARTMENT_ID || '-1' ID, DEPARTMENT_CODE ||'(' || B.ORGANIZATION_CODE || ')' VALUE, TO_CHAR(DEPARTMENT_ID) DEPARTMENT_ID, DEPARTMENT_CODE DEPARTMENT_CODE, DESCRIPTION DEPARTMENT_DESC, A.ORGANIZATION_ID ORGANIZATION_ID FROM BOM_DEPARTMENTS A, MTL_PARAMETERS B WHERE A.ORGANIZATION_ID = B.ORGANIZATION_ID UNION ALL SELECT RESOURCE_CLASS || '-2' ID, RESOURCE_CLASS VALUE, RESOURCE_CLASS, RESOURCE_CLASS, RESOURCE_CLASS_DESC, NULL FROM CR_RSRC_CLS_TL WHERE LANGUAGE = USERENV('LANG') UNION ALL SELECT LOOKUP_CODE ID, MEANING VALUE, LOOKUP_CODE, MEANING, DESCRIPTION, NULL FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'RESOURCE_DIM' AND LOOKUP_CODE = '-1' AND LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT DEPARTMENT_ID || '-1' ID
, DEPARTMENT_CODE ||'(' || B.ORGANIZATION_CODE || ')' VALUE
, TO_CHAR(DEPARTMENT_ID) DEPARTMENT_ID
, DEPARTMENT_CODE DEPARTMENT_CODE
, DESCRIPTION DEPARTMENT_DESC
, A.ORGANIZATION_ID ORGANIZATION_ID
FROM BOM_DEPARTMENTS A
, MTL_PARAMETERS B
WHERE A.ORGANIZATION_ID = B.ORGANIZATION_ID UNION ALL SELECT RESOURCE_CLASS || '-2' ID
, RESOURCE_CLASS VALUE
, RESOURCE_CLASS
, RESOURCE_CLASS
, RESOURCE_CLASS_DESC
, NULL
FROM CR_RSRC_CLS_TL
WHERE LANGUAGE = USERENV('LANG') UNION ALL SELECT LOOKUP_CODE ID
, MEANING VALUE
, LOOKUP_CODE
, MEANING
, DESCRIPTION
, NULL
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'RESOURCE_DIM'
AND LOOKUP_CODE = '-1'
AND LANGUAGE = USERENV('LANG')