SELECT F.ORGANIZATION_CODE,
E.SEGMENT1 PRODUCT,
C.SEGMENT1 CATEGORY,
A.DESCRIPTION CATEGORY_DESC,
D.CATEGORY_SET_NAME
FROM MTL_CATEGORIES_TL A,
MTL_ITEM_CATEGORIES B,
MTL_CATEGORIES_B C,
MTL_CATEGORY_SETS_TL D,
MTL_SYSTEM_ITEMS_B E,
MTL_PARAMETERS F
WHERE A.CATEGORY_ID = B.CATEGORY_ID
AND B.CATEGORY_ID = C.CATEGORY_ID
AND B.CATEGORY_SET_ID = D.CATEGORY_SET_ID
AND A.LANGUAGE = 'US'
--AND D.CATEGORY_SET_NAME = 'ENTER CATEGORY NAME'
AND D.LANGUAGE = 'US'
--AND F.ORGANIZATION_CODE='ENTER ORG NAME'
--AND E.SEGMENT1 = 'ENTER PRODUCT NUMBER'
--AND B.ORGANIZATION_ID= 'ENTER ORGANIZATION ID'
AND B.INVENTORY_ITEM_ID=E.INVENTORY_ITEM_ID
AND B.ORGANIZATION_ID=E.ORGANIZATION_ID
AND B.ORGANIZATION_ID=F.ORGANIZATION_ID;
E.SEGMENT1 PRODUCT,
C.SEGMENT1 CATEGORY,
A.DESCRIPTION CATEGORY_DESC,
D.CATEGORY_SET_NAME
FROM MTL_CATEGORIES_TL A,
MTL_ITEM_CATEGORIES B,
MTL_CATEGORIES_B C,
MTL_CATEGORY_SETS_TL D,
MTL_SYSTEM_ITEMS_B E,
MTL_PARAMETERS F
WHERE A.CATEGORY_ID = B.CATEGORY_ID
AND B.CATEGORY_ID = C.CATEGORY_ID
AND B.CATEGORY_SET_ID = D.CATEGORY_SET_ID
AND A.LANGUAGE = 'US'
--AND D.CATEGORY_SET_NAME = 'ENTER CATEGORY NAME'
AND D.LANGUAGE = 'US'
--AND F.ORGANIZATION_CODE='ENTER ORG NAME'
--AND E.SEGMENT1 = 'ENTER PRODUCT NUMBER'
--AND B.ORGANIZATION_ID= 'ENTER ORGANIZATION ID'
AND B.INVENTORY_ITEM_ID=E.INVENTORY_ITEM_ID
AND B.ORGANIZATION_ID=E.ORGANIZATION_ID
AND B.ORGANIZATION_ID=F.ORGANIZATION_ID;
No comments:
Post a Comment