PSC_CE_AGENCY_OPT_VL

Details

• Schema: FUSION

• Object owner: PSC_CE

• Object type: VIEW

Columns

Name

AGENCY_ID OFFERING_ID CONTENT_URL ANONYMOUS_FLAG WORKFLOW_ENABLED MAX_INS_COUNT AUTO_ASSIGNMENT MOST_REC_PERIOD MOST_REC_PERIOD_UNITS MOST_REC_STATUS AUTO_NUM_RULE_CITATION AUTO_NUM_RULE_NOTICE AUTO_NUM_RULE_INSPECTION AUTO_NUM_RULE_FEE TEXT_LABEL SHORT_DESCRIPTION LONG_DESCRIPTION OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN AUTO_ROUTE_INC SCHEDULE_ID

Query

SQL_Statement

SELECT B.AGENCY_ID, B.OFFERING_ID, B.CONTENT_URL, B.ANONYMOUS_FLAG, B.WORKFLOW_ENABLED, B.MAX_INS_COUNT, B.AUTO_ASSIGNMENT, B.MOST_REC_PERIOD, B.MOST_REC_PERIOD_UNITS, B.MOST_REC_STATUS, B.AUTO_NUM_RULE_CITATION, B.AUTO_NUM_RULE_NOTICE, B.AUTO_NUM_RULE_INSPECTION, B.AUTO_NUM_RULE_FEE, TL.TEXT_LABEL, TL.SHORT_DESCRIPTION, TL.LONG_DESCRIPTION, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.AUTO_ROUTE_INC, B.SCHEDULE_ID FROM PSC_CE_AGENCY_OPT_B B, PSC_CE_AGENCY_OPT_TL TL WHERE B.AGENCY_ID = TL.AGENCY_ID AND TL.LANGUAGE = USERENV('LANG')