[Home] [Help]
View: MTL_CATALOG_SEARCH_ITEMS_ALL_V
View Text
SELECT A.GROUP_HANDLE_ID
, A.INVENTORY_ITEM_ID
, C.SEGMENT1 TEM_NUMBER
, A.DESCRIPTION
, A.ORGANIZATION_ID
, A.RESERVABLE_TYPE
, B.ORGANIZATION_CODE ORG_CODE
, A.PRIMARY_UOM_CODE
, C.ITEM_CATALOG_GROUP_ID
, C.CATALOG_STATUS_FLAG
, C.APPROVAL_STATUS
FROM MTL_CATALOG_SEARCH_ITEMS A
, MTL_PARAMETERS B
, MTL_SYSTEM_ITEMS_B C
WHERE A.ORGANIZATION_ID = B.ORGANIZATION_ID
AND A.ORGANIZATION_ID = C.ORGANIZATION_ID
AND A.INVENTORY_ITEM_ID = C.INVENTORY_ITEM_ID
Columns
Name |
GROUP_HANDLE_ID |
INVENTORY_ITEM_ID |
ITEM_NUMBER |
DESCRIPTION |
ORGANIZATION_ID |
RESERVABLE_TYPE |
ORG_CODE |
PRIMARY_UOM_CODE |
ITEM_CATALOG_GROUP_ID |
CATALOG_STATUS_FLAG |
APPROVAL_STATUS |