FND Design Data [Home] [Help]

View: OKX_ITEM_CATEGORIES_V

Product: OKX - Contracts Integration
Description:
Implementation/DBA Data: ViewAPPS.OKX_ITEM_CATEGORIES_V
View Text

SELECT IC.CATEGORY_ID ID1
, SUBSTR(TO_CHAR(IC.INVENTORY_ITEM_ID) ||'#'|| TO_CHAR(IC.ORGANIZATION_ID)
, 1
, 90) ID2
, SUBSTR(T.DESCRIPTION ||' '|| CT.DESCRIPTION
, 1
, 480) NAME
, SUBSTR(B.CONCATENATED_SEGMENTS ||' '|| BK.CONCATENATED_SEGMENTS
, 1
, 400) DESCRIPTION
, SUBSTR(TO_CHAR(NULL)
, 1
, 1) STATUS
, TO_DATE('01-JAN-1950'
, 'DD-MON-YYYY') START_DATE_ACTIVE
, TO_DATE(NULL) END_DATE_ACTIVE
, IC.INVENTORY_ITEM_ID
, IC.ORGANIZATION_ID
, IC.CATEGORY_SET_ID
, IC.CATEGORY_ID
FROM MTL_SYSTEM_ITEMS_B_KFV B
, MTL_SYSTEM_ITEMS_TL T
, MTL_CATEGORIES_TL CT
, MTL_CATEGORIES_B_KFV BK
, MTL_ITEM_CATEGORIES_V IC
WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
AND T.LANGUAGE = USERENV('LANG')
AND BK.CATEGORY_ID = CT.CATEGORY_ID
AND CT.LANGUAGE = USERENV('LANG')
AND B.INVENTORY_ITEM_ID =IC.INVENTORY_ITEM_ID
AND B.ORGANIZATION_ID = IC.ORGANIZATION_ID
AND BK.CATEGORY_ID = IC.CATEGORY_ID

Columns

Name
ID1
ID2
NAME
DESCRIPTION
STATUS
START_DATE_ACTIVE
END_DATE_ACTIVE
INVENTORY_ITEM_ID
ORGANIZATION_ID
CATEGORY_SET_ID
CATEGORY_ID