View: MTL_LOT_NUMBERS_ALL_V

Product:	INV - Inventory
Description:	10SC ONLYCHANGES DONE AS VIEW IS NON MERGEABLE DUE TO JOIN ON MTL_MATERIAL_STATUSES_VL
Implementation/DBA Data:	APPS.MTL_LOT_NUMBERS_ALL_V

View Text

SELECT LOT.ROWID ROW_ID
, LOT.INVENTORY_ITEM_ID
, LOT.ORGANIZATION_ID
, LOT.LOT_NUMBER
, LOT.LAST_UPDATE_DATE
, LOT.LAST_UPDATED_BY
, LOT.CREATION_DATE
, LOT.CREATED_BY
, LOT.LAST_UPDATE_LOGIN
, LOT.EXPIRATION_DATE
, LOT.DISABLE_FLAG
, LOT.ATTRIBUTE_CATEGORY
, LOT.ATTRIBUTE1
, LOT.ATTRIBUTE2
, LOT.ATTRIBUTE3
, LOT.ATTRIBUTE4
, LOT.ATTRIBUTE5
, LOT.ATTRIBUTE6
, LOT.ATTRIBUTE7
, LOT.ATTRIBUTE8
, LOT.ATTRIBUTE9
, LOT.ATTRIBUTE10
, LOT.ATTRIBUTE11
, LOT.ATTRIBUTE12
, LOT.ATTRIBUTE13
, LOT.ATTRIBUTE14
, LOT.ATTRIBUTE15
, LOT.REQUEST_ID
, LOT.PROGRAM_APPLICATION_ID
, LOT.PROGRAM_ID
, LOT.PROGRAM_UPDATE_DATE
, ITEM.DESCRIPTION
, LOT.DESCRIPTION LOT_DESCRIPTION
, LOT.VENDOR_ID
, PV.VENDOR_NAME
, LOT.SUPPLIER_LOT_NUMBER
, LOT.TERRITORY_CODE
, LOT.GRADE_CODE
, LOT.ORIGINATION_DATE
, LOT.DATE_CODE
, LOT.STATUS_ID
, MSTL.STATUS_CODE
, LOT.CHANGE_DATE
, LOT.AGE
, LOT.RETEST_DATE
, LOT.MATURITY_DATE
, LOT.LOT_ATTRIBUTE_CATEGORY
, LOT.ITEM_SIZE
, LOT.COLOR
, LOT.VOLUME
, LOT.VOLUME_UOM
, LOT.PLACE_OF_ORIGIN
, LOT.BEST_BY_DATE
, LOT.LENGTH
, LOT.LENGTH_UOM
, LOT.RECYCLED_CONTENT
, LOT.THICKNESS
, LOT.THICKNESS_UOM
, LOT.WIDTH
, LOT.WIDTH_UOM
, LOT.CURL_WRINKLE_FOLD
, LOT.C_ATTRIBUTE1
, LOT.C_ATTRIBUTE2
, LOT.C_ATTRIBUTE3
, LOT.C_ATTRIBUTE4
, LOT.C_ATTRIBUTE5
, LOT.C_ATTRIBUTE6
, LOT.C_ATTRIBUTE7
, LOT.C_ATTRIBUTE8
, LOT.C_ATTRIBUTE9
, LOT.C_ATTRIBUTE10
, LOT.C_ATTRIBUTE11
, LOT.C_ATTRIBUTE12
, LOT.C_ATTRIBUTE13
, LOT.C_ATTRIBUTE14
, LOT.C_ATTRIBUTE15
, LOT.C_ATTRIBUTE16
, LOT.C_ATTRIBUTE17
, LOT.C_ATTRIBUTE18
, LOT.C_ATTRIBUTE19
, LOT.C_ATTRIBUTE20
, LOT.D_ATTRIBUTE1
, LOT.D_ATTRIBUTE2
, LOT.D_ATTRIBUTE3
, LOT.D_ATTRIBUTE4
, LOT.D_ATTRIBUTE5
, LOT.D_ATTRIBUTE6
, LOT.D_ATTRIBUTE7
, LOT.D_ATTRIBUTE8
, LOT.D_ATTRIBUTE9
, LOT.D_ATTRIBUTE10
, LOT.N_ATTRIBUTE1
, LOT.N_ATTRIBUTE2
, LOT.N_ATTRIBUTE3
, LOT.N_ATTRIBUTE4
, LOT.N_ATTRIBUTE5
, LOT.N_ATTRIBUTE6
, LOT.N_ATTRIBUTE7
, LOT.N_ATTRIBUTE8
, LOT.N_ATTRIBUTE9
, LOT.N_ATTRIBUTE10
, LOT.GEN_OBJECT_ID
, LOT.PARENT_LOT_NUMBER
, LOT.ORIGINATION_TYPE
, LOT.EXPIRATION_ACTION_DATE
, LOT.EXPIRATION_ACTION_CODE
, LOT.HOLD_DATE
, LOT.SAMPLING_EVENT_ID
FROM MTL_LOT_NUMBERS LOT
, MTL_SYSTEM_ITEMS ITEM
, MTL_MATERIAL_STATUSES_B MSTB
, MTL_MATERIAL_STATUSES_TL MSTL
, PO_VENDORS PV
WHERE LOT.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID
AND ITEM.ORGANIZATION_ID = LOT.ORGANIZATION_ID
AND LOT.STATUS_ID = MSTB.STATUS_ID(+)
AND MSTB.STATUS_ID = MSTL.STATUS_ID(+)
AND MSTL.LANGUAGE(+) =USERENV('LANG')
AND LOT.VENDOR_ID = PV.VENDOR_ID(+)

Columns