[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 |
APPS.MTL_CATALOG_SEARCH_ITEMS_ALL_V