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') |