View: MTL_LOT_CONV_AUDITDETAILS_ERV

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.MTL_LOT_CONV_AUDITDETAILS_ERV

View Text

SELECT MLCA.CONV_AUDIT_DETAIL_ID CONV_AUDIT_DETAIL_ID
, MLCA.CONV_AUDIT_ID CONV_AUDIT_ID
, MLCA.REVISION REVISION
, MLCA.ORGANIZATION_ID ORGANIZATION_ID
, MLCA.LPN_ID LPN_ID
, WLPN.LICENSE_PLATE_NUMBER LICENSE_PLATE_NUMBER
, MLCA.SUBINVENTORY_CODE SUBINVENTORY_CODE
, MLCA.LOCATOR_ID LOCATOR_ID
, MIL.CONCATENATED_SEGMENTS LOCATOR
, MLCA.OLD_PRIMARY_QTY OLD_PRIMARY_QTY
, MLCA.OLD_SECONDARY_QTY OLD_SECONDARY_QTY
, MLCA.NEW_PRIMARY_QTY NEW_PRIMARY_QTY
, MLCA.NEW_SECONDARY_QTY NEW_SECONDARY_QTY
, MLCA.TRANSACTION_PRIMARY_QTY TRANSACTION_PRIMARY_QTY
, MLCA.TRANSACTION_SECONDARY_QTY TRANSACTION_SECONDARY_QTY
, DECODE(MLCA.TRANSACTION_UPDATE_FLAG
, 0
, 'NO'
, 1
, 'YES') TRANSACTION_UPDATE_FLAG
, MLCA.CREATED_BY CREATED_BY
, MLCA.CREATION_DATE CREATION_DATE
, MLCA.LAST_UPDATED_BY LAST_UPDATED_BY
, MLCA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MLCA.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM MTL_LOT_CONV_AUDIT_DETAILS MLCA
, MTL_ITEM_LOCATIONS_KFV MIL
, WMS_LICENSE_PLATE_NUMBERS WLPN
WHERE MLCA.LOCATOR_ID = MIL.INVENTORY_LOCATION_ID(+)
AND MLCA.LPN_ID = WLPN.LPN_ID(+)

Columns