DBA Data[Home] [Help]

VIEW: APPS.OKX_ITEM_CATEGORIES_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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