POZ_PROD_SERV_CATEGORY_V

Details

• Schema: FUSION

• Object owner: POZ

• Object type: VIEW

Columns

Name
CATEGORY_ID CATEGORY_NAME PURCHASING_CAT_FLAG

Query

SQL_Statement

SELECT psps.category_id category_id, DECODE(psps.purchasing_cat_flag,'N',pbct.category_name,'Y',ect.category_name) category_name, psps.purchasing_cat_flag purchasing_cat_flag FROM por_browse_categories_tl pbct, egp_categories_tl ect, poz_sup_products_services psps WHERE psps.category_id= pbct.category_id(+) AND psps.category_id = ect.category_id(+) AND pbct.language(+)=userenv('LANG') AND ect.language(+)=userenv('LANG')