PSC_RESTENDPOINTS_VL

Details

• Schema: FUSION

• Object owner: PSC_TS

• Object type: VIEW

Columns

Name
SERVICE_TYPE REST_END_POINT APPLICATION_ID SERVICE_NAME PAAS_SERVICE_TYPE TENANT_ID PROVISION_DATE EFFDATE EFFSTATUS POD_ID SERVICE_DESCRIPTION TENANT_DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

select B.SERVICE_TYPE, B.REST_END_POINT, B.APPLICATION_ID, B.SERVICE_NAME, B.PAAS_SERVICE_TYPE, B.TENANT_ID, B.PROVISION_DATE, B.EFFDATE, B.EFFSTATUS, B.POD_ID, L.SERVICE_DESCRIPTION, L.TENANT_DESCRIPTION, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER from PSC_RESTENDPOINTS_B B,PSC_RESTENDPOINTS_TL L where B.SERVICE_TYPE = L.SERVICE_TYPE AND L.LANGUAGE = USERENV('LANG')