VIEW: APPS.MTL_LOT_CONV_AUDIT_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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