PSC_COM_FEE_ITEM_VL

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: VIEW

Columns

Name
FEE_ITEM_ID ENABLED_FLAG REVREC_DATE_OPTION DEPARTMENT_ID AGENCY_ID DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER ACCOUNT_CODE_VAL_ONE ACCOUNT_CODE_PCT_ONE ACCOUNT_CODE_VAL_TWO ACCOUNT_CODE_PCT_TWO ACCOUNT_CODE_VAL_THREE ACCOUNT_CODE_PCT_THREE ACCOUNT_CODE_VAL_FOUR ACCOUNT_CODE_PCT_FOUR

Query

SQL_Statement

select B.FEE_ITEM_ID, B.ENABLED_FLAG, B.REVREC_DATE_OPTION, B.DEPARTMENT_ID, B.AGENCY_ID, L.DESCRIPTION, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER ,B.ACCOUNT_CODE_VAL_ONE,B.ACCOUNT_CODE_PCT_ONE,B.ACCOUNT_CODE_VAL_TWO,B.ACCOUNT_CODE_PCT_TWO, B.ACCOUNT_CODE_VAL_THREE,B.ACCOUNT_CODE_PCT_THREE,B.ACCOUNT_CODE_VAL_FOUR,B.ACCOUNT_CODE_PCT_FOUR from PSC_COM_FEE_ITEM_B B,PSC_COM_FEE_ITEM_TL L where B.AGENCY_ID = L.AGENCY_ID AND B.FEE_ITEM_ID = L.FEE_ITEM_ID AND L.LANGUAGE = USERENV('LANG')