I cannot avoid multiplexing when joining item and category tables. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

I cannot avoid multiplexing when joining item and category tables.

in Product Master Data Management 2 comments

Hello

The following SQL multiplexes up to the item organizations record. CAT.CATEGORY_NAME AS CATEGORY_NAME and
CAT.CATEGORY_CODE AS CATEGORY_CODE multiplexes on the basis of item organizations for data whose fields are full. How can I prevent this?

SELECT
ITM.ITEM_NUMBER AS KALEM_KODU,
ITM.DESCRIPTION AS KALEM_ACIKLAMASI,
ITM.PRIMARY_UOM_CODE AS ANA_OLCU_BIRIM,
ITM.HTML_LONG_DESCRIPTION AS KALEM_UZUN_ACIKLAMA,
ITM.UNIT_WEIGHT AS AGIRLIK,
ITM.WEIGHT_UOM_CODE AS AGIRLIK_OLCU_BIRIMI,
NVL(EFF1.ATTRIBUTE_CHAR1, '') AS ENERJI,
EFF1.ATTRIBUTE_CHAR2 AS YAG,
EFF1.ATTRIBUTE_CHAR3 AS DOYMUS_YAG,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!