PSC_PZ_COA_CAT_SUBCAT_V

Details

• Schema: FUSION

• Object owner: PSC_PZ

• Object type: VIEW

Columns

Name
AGENCY_ID CATEGORY_ID CAT_ENABLED_FLAG CAT_NAME CAT_DESCRIPTION SUBCATEGORY_ID NAME DESCRIPTION SUBCAT_ENABLED_FLAG

Query

SQL_Statement
SELECT CB.AGENCY_ID AGENCY_ID, CB.CATEGORY_ID CATEGORY_ID, CB.ENABLED_FLAG CAT_ENABLED_FLAG, CB.NAME CAT_NAME, CB.DESCRIPTION CAT_DESCRIPTION, B.SUBCATEGORY_ID SUBCATEGORY_ID, B.NAME NAME, B.DESCRIPTION DESCRIPTION, B.ENABLED_FLAG SUBCAT_ENABLED_FLAG FROM PSC_PZ_COA_CAT_VL CB left outer join PSC_PZ_COA_SUBCAT_VL B on (CB.AGENCY_ID = B.AGENCY_ID AND cb.category_id=b.category_id)