VIEW: APPS.INVFV_SERIAL_NUMBERS

Source

View Text - Preformatted

SELECT MSN.SERIAL_NUMBER, MSN.INVENTORY_ITEM_ID, '_KF:INV:MSTK:MSI', /* KEYFLEX */ MSN.CURRENT_ORGANIZATION_ID, MP.ORGANIZATION_CODE, HOU.NAME, MSN.INITIALIZATION_DATE, MSN.CURRENT_SUBINVENTORY_CODE, MSN.CURRENT_LOCATOR_ID, '_KF:INV:MTLL:MIL', /* KEYFLEX */ MSN.REVISION, MSN.LOT_NUMBER, '_LA:MSN.CURRENT_STATUS:MFG_LOOKUPS:SERIAL_NUM_STATUS:MEANING', /* LOOKUP */ MSN.COMPLETION_DATE, MSN.SHIP_DATE, MSN.ORIGINAL_WIP_ENTITY_ID, WIP.WIP_ENTITY_NAME, MSN.ORIGINAL_UNIT_VENDOR_ID, PO.VENDOR_NAME, MSN.VENDOR_SERIAL_NUMBER, MSN.VENDOR_LOT_NUMBER, MSN.LAST_TRANSACTION_ID, MSN.LAST_RECEIPT_ISSUE_TYPE, MSN.CREATED_BY, MSN.CREATION_DATE, MSN.LAST_UPDATED_BY, MSN.LAST_UPDATE_DATE, MSN.END_ITEM_UNIT_NUMBER FROM WIP_ENTITIES WIP, PO_VENDORS PO, MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS MSI, HR_ALL_ORGANIZATION_UNITS HOU, MTL_ITEM_LOCATIONS MIL, MTL_SERIAL_NUMBERS MSN WHERE MSI.ORGANIZATION_ID = MSN.CURRENT_ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID AND MIL.ORGANIZATION_ID (+) = MSN.CURRENT_ORGANIZATION_ID AND MIL.INVENTORY_LOCATION_ID (+) = MSN.CURRENT_LOCATOR_ID AND MP.ORGANIZATION_ID = MSN.CURRENT_ORGANIZATION_ID AND HOU.ORGANIZATION_ID = MSN.CURRENT_ORGANIZATION_ID AND WIP.WIP_ENTITY_ID (+) = MSN.ORIGINAL_WIP_ENTITY_ID AND PO.VENDOR_ID (+) = MSN.ORIGINAL_UNIT_VENDOR_ID AND '_SEC:MSN.CURRENT_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT MSN.SERIAL_NUMBER
, MSN.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
, /* KEYFLEX */ MSN.CURRENT_ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOU.NAME
, MSN.INITIALIZATION_DATE
, MSN.CURRENT_SUBINVENTORY_CODE
, MSN.CURRENT_LOCATOR_ID
, '_KF:INV:MTLL:MIL'
, /* KEYFLEX */ MSN.REVISION
, MSN.LOT_NUMBER
, '_LA:MSN.CURRENT_STATUS:MFG_LOOKUPS:SERIAL_NUM_STATUS:MEANING'
, /* LOOKUP */ MSN.COMPLETION_DATE
, MSN.SHIP_DATE
, MSN.ORIGINAL_WIP_ENTITY_ID
, WIP.WIP_ENTITY_NAME
, MSN.ORIGINAL_UNIT_VENDOR_ID
, PO.VENDOR_NAME
, MSN.VENDOR_SERIAL_NUMBER
, MSN.VENDOR_LOT_NUMBER
, MSN.LAST_TRANSACTION_ID
, MSN.LAST_RECEIPT_ISSUE_TYPE
, MSN.CREATED_BY
, MSN.CREATION_DATE
, MSN.LAST_UPDATED_BY
, MSN.LAST_UPDATE_DATE
, MSN.END_ITEM_UNIT_NUMBER
FROM WIP_ENTITIES WIP
, PO_VENDORS PO
, MTL_PARAMETERS MP
, MTL_SYSTEM_ITEMS MSI
, HR_ALL_ORGANIZATION_UNITS HOU
, MTL_ITEM_LOCATIONS MIL
, MTL_SERIAL_NUMBERS MSN
WHERE MSI.ORGANIZATION_ID = MSN.CURRENT_ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
AND MIL.ORGANIZATION_ID (+) = MSN.CURRENT_ORGANIZATION_ID
AND MIL.INVENTORY_LOCATION_ID (+) = MSN.CURRENT_LOCATOR_ID
AND MP.ORGANIZATION_ID = MSN.CURRENT_ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MSN.CURRENT_ORGANIZATION_ID
AND WIP.WIP_ENTITY_ID (+) = MSN.ORIGINAL_WIP_ENTITY_ID
AND PO.VENDOR_ID (+) = MSN.ORIGINAL_UNIT_VENDOR_ID
AND '_SEC:MSN.CURRENT_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY