CSO_CONTENT_TEXT_PROD

Details

Schema: FUSION
Object owner: CSO
Object type: VIEW

Columns

Name
CONTENT_TEXT_ID INVENTORY_ITEM_ID INVENTORY_ORG_ID PROD_GROUP_ID PRODUCT_TYPE

Name

CONTENT_TEXT_ID

INVENTORY_ITEM_ID

INVENTORY_ORG_ID

PROD_GROUP_ID

PRODUCT_TYPE

Query

SQL_Statement
SELECT CONTENT_TEXT_ID, (CASE WHEN INVENTORY_ITEM_ID<0 THEN NULL ELSE INVENTORY_ITEM_ID END) INVENTORY_ITEM_ID, (CASE WHEN INVENTORY_ORG_ID<0 THEN NULL ELSE INVENTORY_ORG_ID END) INVENTORY_ORG_ID, PROD_GROUP_ID, PRODUCT_TYPE FROM CSO_CONTENT_TEXT_PROD UNION SELECT ctc.CONTENT_TEXT_ID, (CASE WHEN t.INVENTORY_ORG_ID IS NULL THEN NULL ELSE t.EXTERNAL_ID END) INVENTORY_ITEM_ID, t.INVENTORY_ORG_ID INVENTORY_ORG_ID, (CASE WHEN t.INVENTORY_ORG_ID IS NULL THEN t.EXTERNAL_ID ELSE (SELECT p.EXTERNAL_ID from CSO_TAG p where p.RECORD_ID = t.PARENT_ID) END ) PROD_GROUP_ID, (CASE WHEN t.INVENTORY_ORG_ID IS NULL THEN 'PRODUCT_GROUP' ELSE 'PRODUCT_ITEM' END) PRODUCT_TYPE from CSO_CONTENT_TEXT_CATEGORY ctc, CSO_TAG t where t.RECORD_ID = ctc.TAG_ID AND t.EXTERNAL_TYPE = 'PRODUCT'

SQL_Statement

SELECT CONTENT_TEXT_ID, (CASE WHEN INVENTORY_ITEM_ID<0 THEN NULL ELSE INVENTORY_ITEM_ID END) INVENTORY_ITEM_ID, (CASE WHEN INVENTORY_ORG_ID<0 THEN NULL ELSE INVENTORY_ORG_ID END) INVENTORY_ORG_ID, PROD_GROUP_ID, PRODUCT_TYPE FROM CSO_CONTENT_TEXT_PROD

UNION

SELECT ctc.CONTENT_TEXT_ID, (CASE WHEN t.INVENTORY_ORG_ID IS NULL THEN NULL ELSE t.EXTERNAL_ID END) INVENTORY_ITEM_ID, t.INVENTORY_ORG_ID INVENTORY_ORG_ID, (CASE WHEN t.INVENTORY_ORG_ID IS NULL THEN t.EXTERNAL_ID ELSE (SELECT p.EXTERNAL_ID from CSO_TAG p where p.RECORD_ID = t.PARENT_ID) END ) PROD_GROUP_ID, (CASE WHEN t.INVENTORY_ORG_ID IS NULL THEN 'PRODUCT_GROUP' ELSE 'PRODUCT_ITEM' END) PRODUCT_TYPE from CSO_CONTENT_TEXT_CATEGORY ctc, CSO_TAG t where t.RECORD_ID = ctc.TAG_ID AND t.EXTERNAL_TYPE = 'PRODUCT'