PJO_CUSTOM_LAYOUTS_VL

Details

• Schema: FUSION

• Object owner: PJO

• Object type: VIEW

Columns

Name
CUSTOM_LAYOUT_ID USER_GUID PAGE_ARTIFACT COMP_ARTIFACT IS_ACTIVE CUSTOM_LAYOUT_SEED_ID NAME DESCRIPTION LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER PLAN_CLASS_CODE

Query

SQL_Statement

SELECT PCLB.CUSTOM_LAYOUT_ID CUSTOM_LAYOUT_ID, PCLB.USER_GUID USER_GUID, PCLB.PAGE_ARTIFACT PAGE_ARTIFACT, PCLB.COMP_ARTIFACT COMP_ARTIFACT, PCLB.IS_ACTIVE IS_ACTIVE, PCLB.CUSTOM_LAYOUT_SEED_ID, PCLT.NAME NAME, PCLT.DESCRIPTION DESCRIPTION, PCLB.LAST_UPDATE_DATE LAST_UPDATE_DATE, PCLB.LAST_UPDATED_BY LAST_UPDATED_BY, PCLB.CREATION_DATE CREATION_DATE, PCLB.CREATED_BY CREATED_BY, PCLB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PCLB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PCLB.PLAN_CLASS_CODE PLAN_CLASS_CODE FROM PJO_CUSTOM_LAYOUTS_B PCLB, PJO_CUSTOM_LAYOUTS_TL PCLT WHERE PCLB.CUSTOM_LAYOUT_ID = PCLT.CUSTOM_LAYOUT_ID AND LANGUAGE = USERENV('LANG')