PSC_PZ_HRG_BODY

Details

Schema: FUSION
Object owner: PSC_PZ
Object type: VIEW

Columns

Name
AGENCY_ID HRG_BODY_CODE CLASSIFICATION NAME DESCRIPTION ENABLED_FLAG RECURRENCE_OPTION START_DATETIME RECUR_FREQUENCY MONDAY_FLAG TUESDAY_FLAG WEDNESDAY_FLAG THURSDAY_FLAG FRIDAY_FLAG SATURDAY_FLAG SUNDAY_FLAG MONTH_RECUR_OPTION NOTIFICATION_PERIOD APPEAL_PERIOD EXPIRATION_PERIOD MAX_AGENDA_ITEMS COUNTRY_CODE ADDRESS1 ADDRESS2 ADDRESS3 ADDRESS4 CITY_NAME ZIP_CODE STATE_CODE_ISO PROVINCE COUNTY_CODE_INCITS POSTAL_PLUS4_CODE HRG_HRCY_CODE APPEAL_ONLY_FLAG BIP_TEMPLATE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Name

AGENCY_ID

HRG_BODY_CODE

CLASSIFICATION

NAME

DESCRIPTION

ENABLED_FLAG

RECURRENCE_OPTION

START_DATETIME

RECUR_FREQUENCY

MONDAY_FLAG

TUESDAY_FLAG

WEDNESDAY_FLAG

THURSDAY_FLAG

FRIDAY_FLAG

SATURDAY_FLAG

SUNDAY_FLAG

MONTH_RECUR_OPTION

NOTIFICATION_PERIOD

APPEAL_PERIOD

EXPIRATION_PERIOD

MAX_AGENDA_ITEMS

COUNTRY_CODE

ADDRESS1

ADDRESS2

ADDRESS3

ADDRESS4

CITY_NAME

ZIP_CODE

STATE_CODE_ISO

PROVINCE

COUNTY_CODE_INCITS

POSTAL_PLUS4_CODE

HRG_HRCY_CODE

APPEAL_ONLY_FLAG

BIP_TEMPLATE_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement
SELECT B.AGENCY_ID AGENCY_ID, B.HRG_BODY_CODE HRG_BODY_CODE, B.CLASSIFICATION CLASSIFICATION, L.NAME NAME, L.DESCRIPTION DESCRIPTION, B.ENABLED_FLAG ENABLED_FLAG, B.RECURRENCE_OPTION RECURRENCE_OPTION, B.START_DATETIME START_DATETIME, B.RECUR_FREQUENCY RECUR_FREQUENCY, B.MONDAY_FLAG MONDAY_FLAG, B.TUESDAY_FLAG TUESDAY_FLAG, B.WEDNESDAY_FLAG WEDNESDAY_FLAG, B.THURSDAY_FLAG THURSDAY_FLAG, B.FRIDAY_FLAG FRIDAY_FLAG, B.SATURDAY_FLAG SATURDAY_FLAG, B.SUNDAY_FLAG SUNDAY_FLAG, B.MONTH_RECUR_OPTION MONTH_RECUR_OPTION, B.NOTIFICATION_PERIOD NOTIFICATION_PERIOD, B.APPEAL_PERIOD APPEAL_PERIOD, B.EXPIRATION_PERIOD EXPIRATION_PERIOD, B.MAX_AGENDA_ITEMS MAX_AGENDA_ITEMS, B.COUNTRY_CODE COUNTRY_CODE, B.ADDRESS1 ADDRESS1, B.ADDRESS2 ADDRESS2, B.ADDRESS3 ADDRESS3, B.ADDRESS4 ADDRESS4, B.CITY_NAME CITY_NAME, B.ZIP_CODE ZIP_CODE, B.STATE_CODE_ISO STATE_CODE_ISO, B.PROVINCE PROVINCE, B.COUNTY_CODE_INCITS COUNTY_CODE_INCITS, B.POSTAL_PLUS4_CODE POSTAL_PLUS4_CODE, B.HRG_HRCY_CODE, B.APPEAL_ONLY_FLAG, B.BIP_TEMPLATE_ID, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM PSC_PZ_HRG_BODY_B B, PSC_PZ_HRG_BODY_TL L WHERE B.AGENCY_ID = L.AGENCY_ID AND B.HRG_BODY_CODE = L.HRG_BODY_CODE AND L.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.AGENCY_ID AGENCY_ID,

B.HRG_BODY_CODE HRG_BODY_CODE,

B.CLASSIFICATION CLASSIFICATION,

L.NAME NAME,

L.DESCRIPTION DESCRIPTION,

B.ENABLED_FLAG ENABLED_FLAG,

B.RECURRENCE_OPTION RECURRENCE_OPTION,

B.START_DATETIME START_DATETIME,

B.RECUR_FREQUENCY RECUR_FREQUENCY,

B.MONDAY_FLAG MONDAY_FLAG,

B.TUESDAY_FLAG TUESDAY_FLAG,

B.WEDNESDAY_FLAG WEDNESDAY_FLAG,

B.THURSDAY_FLAG THURSDAY_FLAG,

B.FRIDAY_FLAG FRIDAY_FLAG,

B.SATURDAY_FLAG SATURDAY_FLAG,

B.SUNDAY_FLAG SUNDAY_FLAG,

B.MONTH_RECUR_OPTION MONTH_RECUR_OPTION,

B.NOTIFICATION_PERIOD NOTIFICATION_PERIOD,

B.APPEAL_PERIOD APPEAL_PERIOD,

B.EXPIRATION_PERIOD EXPIRATION_PERIOD,

B.MAX_AGENDA_ITEMS MAX_AGENDA_ITEMS,

B.COUNTRY_CODE COUNTRY_CODE,

B.ADDRESS1 ADDRESS1,

B.ADDRESS2 ADDRESS2,

B.ADDRESS3 ADDRESS3,

B.ADDRESS4 ADDRESS4,

B.CITY_NAME CITY_NAME,

B.ZIP_CODE ZIP_CODE,

B.STATE_CODE_ISO STATE_CODE_ISO,

B.PROVINCE PROVINCE,

B.COUNTY_CODE_INCITS COUNTY_CODE_INCITS,

B.POSTAL_PLUS4_CODE POSTAL_PLUS4_CODE,

B.HRG_HRCY_CODE,

B.APPEAL_ONLY_FLAG,

B.BIP_TEMPLATE_ID,

B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

B.CREATED_BY CREATED_BY,

B.CREATION_DATE CREATION_DATE,

B.LAST_UPDATED_BY LAST_UPDATED_BY,

B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN

FROM

PSC_PZ_HRG_BODY_B B,

PSC_PZ_HRG_BODY_TL L

WHERE

B.AGENCY_ID = L.AGENCY_ID AND B.HRG_BODY_CODE = L.HRG_BODY_CODE AND L.LANGUAGE = USERENV('LANG')