View: MTL_LOT_CONV_AUDIT_DETAILS_V

Product:	INV - Inventory
Description:	Lot Specific UOM Conversions Audit Details
Implementation/DBA Data:	APPS.MTL_LOT_CONV_AUDIT_DETAILS_V

View Text

SELECT A.CONV_AUDIT_DETAIL_ID
, A.CONV_AUDIT_ID
, A.REVISION
, A.ORGANIZATION_ID
, A.SUBINVENTORY_CODE
, A.LPN_ID
, A.LOCATOR_ID
, A.OLD_PRIMARY_QTY
, A.OLD_SECONDARY_QTY
, A.NEW_PRIMARY_QTY
, A.NEW_SECONDARY_QTY
, A.TRANSACTION_PRIMARY_QTY
, A.TRANSACTION_SECONDARY_QTY
, A.TRANSACTION_UPDATE_FLAG
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, B.LICENSE_PLATE_NUMBER LPN
, C.CONCATENATED_SEGMENTS LOCATOR
FROM MTL_LOT_CONV_AUDIT_DETAILS A
, WMS_LICENSE_PLATE_NUMBERS B
, MTL_ITEM_LOCATIONS_KFV C
WHERE A.LPN_ID = B.LPN_ID(+)
AND A.ORGANIZATION_ID = C.ORGANIZATION_ID (+)
AND A.LOCATOR_ID = C.INVENTORY_LOCATION_ID(+)

Columns