PSC_COM_EXPIRATION_GROUP

Details

Schema: FUSION
Object owner: PSC_CC
Object type: VIEW

Columns

Name
AGENCY_ID EXPIRATION_GROUP_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE CLASSIFICATION SUBCLASSIFICATION ENABLED_FLAG EXPIRATION_GROUP DESCRIPTION OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN EXPIRATION_RENEW_FLAG

Name

AGENCY_ID

EXPIRATION_GROUP_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

CLASSIFICATION

SUBCLASSIFICATION

ENABLED_FLAG

EXPIRATION_GROUP

DESCRIPTION

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

EXPIRATION_RENEW_FLAG

Query

SQL_Statement
SELECT B.AGENCY_ID, B.EXPIRATION_GROUP_ID, B.EFFECTIVE_START_DATE, B.EFFECTIVE_END_DATE, B.CLASSIFICATION, B.SUBCLASSIFICATION, B.ENABLED_FLAG, TL.EXPIRATION_GROUP, TL.DESCRIPTION, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.EXPIRATION_RENEW_FLAG FROM PSC_COM_EXP_GROUP_F_B B, PSC_COM_EXP_GROUP_F_TL TL WHERE B.AGENCY_ID = TL.AGENCY_ID AND B.EXPIRATION_GROUP_ID = TL.EXPIRATION_GROUP_ID AND B.EFFECTIVE_START_DATE = TL.EFFECTIVE_START_DATE AND B.EFFECTIVE_END_DATE = TL.EFFECTIVE_END_DATE AND TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.AGENCY_ID,

B.EXPIRATION_GROUP_ID,

B.EFFECTIVE_START_DATE,

B.EFFECTIVE_END_DATE,

B.CLASSIFICATION,

B.SUBCLASSIFICATION,

B.ENABLED_FLAG,

TL.EXPIRATION_GROUP,

TL.DESCRIPTION,

B.OBJECT_VERSION_NUMBER,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.EXPIRATION_RENEW_FLAG

FROM

PSC_COM_EXP_GROUP_F_B B,

PSC_COM_EXP_GROUP_F_TL TL

WHERE

B.AGENCY_ID = TL.AGENCY_ID AND B.EXPIRATION_GROUP_ID = TL.EXPIRATION_GROUP_ID AND B.EFFECTIVE_START_DATE = TL.EFFECTIVE_START_DATE AND B.EFFECTIVE_END_DATE = TL.EFFECTIVE_END_DATE AND TL.LANGUAGE = USERENV('LANG')