View: PA_BOM_EQUIPMENT_RES_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_BOM_EQUIPMENT_RES_V

View Text

SELECT B.RESOURCE_ID
, B.RESOURCE_CODE
, B.DESCRIPTION
, O.NAME ORGANIZATION_NAME
FROM BOM_RESOURCES B
, HR_ALL_ORGANIZATION_UNITS_VL O
WHERE B.RESOURCE_TYPE = 1
AND B.ORGANIZATION_ID = O.ORGANIZATION_ID
AND NVL(B.DISABLE_DATE
, SYSDATE) >= SYSDATE
AND B.EXPENDITURE_TYPE IS NOT NULL

Columns