VIEW: APPS.OKL_SYSTEM_ITEMS_UV

Source

View Text - Preformatted

SELECT B.INVENTORY_ITEM_ID ID1, B.ORGANIZATION_ID ID2, B.SEGMENT1 ITEM_NUMBER, T.DESCRIPTION DESCRIPTION FROM MTL_SYSTEM_ITEMS_B B, MTL_SYSTEM_ITEMS_B BM, MTL_SYSTEM_ITEMS_TL T, FA_CATEGORY_BOOK_DEFAULTS FA, MTL_PARAMETERS MP, OKL_SYSTEM_PARAMS OSP WHERE B.ORGANIZATION_ID = OSP.ITEM_INV_ORG_ID AND B.ENABLED_FLAG = 'Y' AND B.ORGANIZATION_ID = MP.ORGANIZATION_ID AND MP.MASTER_ORGANIZATION_ID = BM.ORGANIZATION_ID AND BM.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND BM.ASSET_CATEGORY_ID = FA.CATEGORY_ID AND FA.BOOK_TYPE_CODE = OSP.ASST_ADD_BOOK_TYPE_CODE AND B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = T.ORGANIZATION_ID AND T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.INVENTORY_ITEM_ID ID1
, B.ORGANIZATION_ID ID2
, B.SEGMENT1 ITEM_NUMBER
, T.DESCRIPTION DESCRIPTION
FROM MTL_SYSTEM_ITEMS_B B
, MTL_SYSTEM_ITEMS_B BM
, MTL_SYSTEM_ITEMS_TL T
, FA_CATEGORY_BOOK_DEFAULTS FA
, MTL_PARAMETERS MP
, OKL_SYSTEM_PARAMS OSP
WHERE B.ORGANIZATION_ID = OSP.ITEM_INV_ORG_ID
AND B.ENABLED_FLAG = 'Y'
AND B.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MP.MASTER_ORGANIZATION_ID = BM.ORGANIZATION_ID
AND BM.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
AND BM.ASSET_CATEGORY_ID = FA.CATEGORY_ID
AND FA.BOOK_TYPE_CODE = OSP.ASST_ADD_BOOK_TYPE_CODE
AND B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
AND T.LANGUAGE = USERENV('LANG')