PJR_RESOURCE_POOLS_VL

Details

• Schema: FUSION

• Object owner: FUSION

• Object type: VIEW

Columns

Name
POOL_ID NAME DESCRIPTION RESOURCE_ID FROM_DATE TO_DATE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN PARENT_POOL_ID POOL_TYPE_CODE ENTERPRISE_ID POOL_CODE

Query

SQL_Statement

SELECT PJR_RESOURCE_POOLS_B.POOL_ID POOL_ID, PJR_RESOURCE_POOLS_TL.NAME NAME, PJR_RESOURCE_POOLS_TL.DESCRIPTION DESCRIPTION, PJR_RESOURCE_POOLS_B.RESOURCE_ID RESOURCE_ID, PJR_RESOURCE_POOLS_B.FROM_DATE FROM_DATE, PJR_RESOURCE_POOLS_B.TO_DATE TO_DATE, PJR_RESOURCE_POOLS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PJR_RESOURCE_POOLS_B.CREATED_BY CREATED_BY, PJR_RESOURCE_POOLS_B.CREATION_DATE CREATION_DATE, PJR_RESOURCE_POOLS_B.LAST_UPDATED_BY LAST_UPDATED_BY, PJR_RESOURCE_POOLS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, PJR_RESOURCE_POOLS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PJR_RESOURCE_POOLS_B.PARENT_POOL_ID PARENT_POOL_ID, PJR_RESOURCE_POOLS_B.POOL_TYPE_CODE POOL_TYPE_CODE, PJR_RESOURCE_POOLS_B.ENTERPRISE_ID, PJR_RESOURCE_POOLS_B.POOL_CODE FROM PJR_RESOURCE_POOLS_B, PJR_RESOURCE_POOLS_TL WHERE PJR_RESOURCE_POOLS_B.POOL_ID = PJR_RESOURCE_POOLS_TL.POOL_ID AND PJR_RESOURCE_POOLS_TL.LANGUAGE = USERENV('LANG') AND PJR_RESOURCE_POOLS_B.ENTERPRISE_ID = PJR_RESOURCE_POOLS_TL.ENTERPRISE_ID