PJC_CINT_RATE_SCH_VL

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name
RATE_SCH_NAME DESCRIPTION CINT_RATE_SCH_ID ORG_TREE_STRUCTURE_CODE ORG_TREE_CODE ORG_TREE_VERSION_ID START_ORGANIZATION_ID START_DATE_ACTIVE END_DATE_ACTIVE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT PJC_CINT_RATE_SCH_TL.RATE_SCH_NAME RATE_SCH_NAME, PJC_CINT_RATE_SCH_TL.DESCRIPTION DESCRIPTION, PJC_CINT_RATE_SCH_B.CINT_RATE_SCH_ID CINT_RATE_SCH_ID, PJC_CINT_RATE_SCH_B.ORG_TREE_STRUCTURE_CODE ORG_TREE_STRUCTURE_CODE, PJC_CINT_RATE_SCH_B.ORG_TREE_CODE ORG_TREE_CODE, PJC_CINT_RATE_SCH_B.ORG_TREE_VERSION_ID, PJC_CINT_RATE_SCH_B.START_ORGANIZATION_ID START_ORGANIZATION_ID, PJC_CINT_RATE_SCH_B.START_DATE_ACTIVE START_DATE_ACTIVE, PJC_CINT_RATE_SCH_B.END_DATE_ACTIVE END_DATE_ACTIVE, PJC_CINT_RATE_SCH_B.CREATED_BY CREATED_BY, PJC_CINT_RATE_SCH_B.CREATION_DATE CREATION_DATE, PJC_CINT_RATE_SCH_B.LAST_UPDATED_BY LAST_UPDATED_BY, PJC_CINT_RATE_SCH_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, PJC_CINT_RATE_SCH_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PJC_CINT_RATE_SCH_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM PJC_CINT_RATE_SCH_TL, PJC_CINT_RATE_SCH_B WHERE PJC_CINT_RATE_SCH_TL.CINT_RATE_SCH_ID = PJC_CINT_RATE_SCH_B.CINT_RATE_SCH_ID AND PJC_CINT_RATE_SCH_TL.LANGUAGE = USERENV('LANG')