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
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
|
|
|