VIEW: APPS.MTL_SYSTEM_ITEMS_ER2_V

Source

View Text - Preformatted

SELECT P.ORGANIZATION_CODE , O.NAME , C.CONCATENATED_SEGMENTS , B.CONCATENATED_SEGMENTS , T.DESCRIPTION , B.INVENTORY_ITEM_ID , B.ORGANIZATION_ID , P.MASTER_ORGANIZATION_ID FROM MTL_SYSTEM_ITEMS_TL T , MTL_SYSTEM_ITEMS_B_KFV B , MTL_ITEM_CATALOG_GROUPS_KFV C , HR_ALL_ORGANIZATION_UNITS_TL O , MTL_PARAMETERS P WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = T.ORGANIZATION_ID AND T.LANGUAGE = USERENV('LANG') AND O.ORGANIZATION_ID = B.ORGANIZATION_ID AND O.LANGUAGE = USERENV('LANG') AND P.ORGANIZATION_ID = O.ORGANIZATION_ID AND B.ITEM_CATALOG_GROUP_ID = C.ITEM_CATALOG_GROUP_ID (+)

View Text - HTML Formatted

SELECT P.ORGANIZATION_CODE
, O.NAME
, C.CONCATENATED_SEGMENTS
, B.CONCATENATED_SEGMENTS
, T.DESCRIPTION
, B.INVENTORY_ITEM_ID
, B.ORGANIZATION_ID
, P.MASTER_ORGANIZATION_ID
FROM MTL_SYSTEM_ITEMS_TL T
, MTL_SYSTEM_ITEMS_B_KFV B
, MTL_ITEM_CATALOG_GROUPS_KFV C
, HR_ALL_ORGANIZATION_UNITS_TL O
, MTL_PARAMETERS P
WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
AND T.LANGUAGE = USERENV('LANG')
AND O.ORGANIZATION_ID = B.ORGANIZATION_ID
AND O.LANGUAGE = USERENV('LANG')
AND P.ORGANIZATION_ID = O.ORGANIZATION_ID
AND B.ITEM_CATALOG_GROUP_ID = C.ITEM_CATALOG_GROUP_ID (+)