FFS_ORGANIZATION_VL

Details

• Schema: FUSION

• Object owner: FFS

• Object type: VIEW

Columns

Name
ORGANIZATION_ID LABEL STATUS TYPE TRAVEL_KEY_TYPE_NEW TRAVEL_KEY_TYPE_CURRENT NAME DELETED_FLAG PARTNER_PARTY_ID CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT b.ORGANIZATION_ID ORGANIZATION_ID, b.LABEL LABEL, b.STATUS STATUS, b.TYPE TYPE, b.TRAVEL_KEY_TYPE_NEW TRAVEL_KEY_TYPE_NEW, b.TRAVEL_KEY_TYPE_CURRENT TRAVEL_KEY_TYPE_CURRENT, nvl (tl.NAME, b.LABEL) NAME, b.DELETED_FLAG DELETED_FLAG, b.PARTNER_PARTY_ID PARTNER_PARTY_ID, b.CREATION_DATE CREATION_DATE, b.CREATED_BY CREATED_BY, b.LAST_UPDATE_DATE LAST_UPDATE_DATE, b.LAST_UPDATED_BY LAST_UPDATED_BY, b.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from ffs_organization b left join ffs_organization_tl tl on b.ORGANIZATION_ID = tl.ORGANIZATION_ID and tl.LANGUAGE = USERENV('LANG')