View: POS_MTL_ONHAND_SERIAL_KFV

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.POS_MTL_ONHAND_SERIAL_KFV

View Text

SELECT A.INVENTORY_ITEM_ID
, A.SERIAL_NUMBER
, A.REVISION
, A.CURRENT_STATUS
, A.LOT_NUMBER
, A.CURRENT_SUBINVENTORY_CODE
, A.CURRENT_LOCATOR_ID
, A.CURRENT_ORGANIZATION_ID
, C.NAME ORGANIZATION_NAME
, B.DESCRIPTION ITEM_DESCRIPTION
, B.PRIMARY_UOM_CODE
, B.CONCATENATED_SEGMENTS ITEM
, D.CONCATENATED_SEGMENTS LOCATION
, B.ATTRIBUTE14 ITEM_URL
FROM MTL_SERIAL_NUMBERS A
, MTL_SYSTEM_ITEMS_KFV B
, HR_ORGANIZATION_UNITS C
, MTL_ITEM_LOCATIONS_KFV D
WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
AND A.CURRENT_ORGANIZATION_ID = B.ORGANIZATION_ID
AND A.CURRENT_ORGANIZATION_ID = C.ORGANIZATION_ID
AND A.CURRENT_LOCATOR_ID IS NOT NULL
AND A.CURRENT_LOCATOR_ID = D.INVENTORY_LOCATION_ID
AND A.CURRENT_ORGANIZATION_ID = D.ORGANIZATION_ID UNION SELECT A.INVENTORY_ITEM_ID
, A.SERIAL_NUMBER
, A.REVISION
, A.CURRENT_STATUS
, A.LOT_NUMBER
, A.CURRENT_SUBINVENTORY_CODE
, A.CURRENT_LOCATOR_ID
, A.CURRENT_ORGANIZATION_ID
, C.NAME ORGANIZATION_NAME
, B.DESCRIPTION ITEM_DESCRIPTION
, B.PRIMARY_UOM_CODE
, B.CONCATENATED_SEGMENTS ITEM
, NULL LOCATION
, B.ATTRIBUTE14 ITEM_URL
FROM MTL_SERIAL_NUMBERS A
, MTL_SYSTEM_ITEMS_KFV B
, HR_ORGANIZATION_UNITS C
WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
AND A.CURRENT_ORGANIZATION_ID = B.ORGANIZATION_ID
AND A.CURRENT_ORGANIZATION_ID = C.ORGANIZATION_ID
AND A.CURRENT_STATUS = 3
AND A.CURRENT_LOCATOR_ID IS NULL

Columns