PSC_COM_AGENCY_VL

Details

• Schema: FUSION

• Object owner: PSC

• Object type: VIEW

Columns

Name

AGENCY_ID AGENCY_NAME ASSIGNMENT_OPTION COUNTRY_CODE CURRENCY_CODE PARCEL_OWNER_FORMAT TZNAME DESCRIPTION TIME_FORMAT DATE_FORMAT NUMBER_FORMAT ENABLE_FIN_GL LEDGER_ID OPA_POLICY_ID APO_ACCESS ALLOW_PARTIAL_PAYMENT PMT_ALLOCATION_RULE_FEE HIDE_PROPERTY_OWNER RULE_ID_ENTITY RULE_ID_LOCATION RULE_ID_LICENSE_ID RULE_ID_POLICY_ID DEFAULT_SEARCH_FILTER DEFAULT_SEARCH_TYPE DEF_PR_DT_TYPE_FLT DEF_PR_DT_FLT DEF_INS_DT_TYPE_FLT DEF_INS_DT_FLT DEF_INSPECTION_STATUS_FILTER PR_SAT_SUN_FLAG EM_ERROR_ENABLED_FLAG EM_ERROR_EMAIL EM_MAX_ATTEMPTS MAX_COPIES_ALLOWED INS_MAX_INSPECTOR_COUNT USE_GIS_APO_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT B.AGENCY_ID, B.AGENCY_NAME, B.ASSIGNMENT_OPTION, B.COUNTRY_CODE, B.CURRENCY_CODE, B.PARCEL_OWNER_FORMAT, B.TZNAME, L.DESCRIPTION, B.TIME_FORMAT, B.DATE_FORMAT, B.NUMBER_FORMAT, B.ENABLE_FIN_GL, B.LEDGER_ID, B.OPA_POLICY_ID, B.APO_ACCESS, B.ALLOW_PARTIAL_PAYMENT, B.PMT_ALLOCATION_RULE_FEE, B.HIDE_PROPERTY_OWNER, B.RULE_ID_ENTITY, B.RULE_ID_LOCATION, B.RULE_ID_LICENSE_ID, B.RULE_ID_POLICY_ID, B.DEFAULT_SEARCH_FILTER, B.DEFAULT_SEARCH_TYPE, B.DEF_PR_DT_TYPE_FLT, B.DEF_PR_DT_FLT, B.DEF_INS_DT_TYPE_FLT, B.DEF_INS_DT_FLT, B.DEF_INSPECTION_STATUS_FILTER, B.PR_SAT_SUN_FLAG, B.EM_ERROR_ENABLED_FLAG, B.EM_ERROR_EMAIL, B.EM_MAX_ATTEMPTS, B.MAX_COPIES_ALLOWED, B.INS_MAX_INSPECTOR_COUNT, B.USE_GIS_APO_FLAG, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER FROM PSC_COM_AGENCY_B B, PSC_COM_AGENCY_TL L WHERE B.AGENCY_ID = L.AGENCY_ID AND L.LANGUAGE = USERENV('LANG')