VIEW: APPS.MTL_LOT_NUMBERS_ALL_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)