VIEW: APPS.WSH_STND_INVDETAILS_V

Source

View Text - Preformatted

SELECT WDD.DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID, WSN.FM_SERIAL_NUMBER FM_SERIAL_NUMBER, WSN.TO_SERIAL_NUMBER TO_SERIAL_NUMBER, WSN.QUANTITY QUANTITY, WSN.CREATION_DATE CREATION_DATE, WSN.CREATED_BY CREATED_BY, WSN.LAST_UPDATE_DATE LAST_UPDATE_DATE, WSN.LAST_UPDATED_BY LAST_UPDATED_BY, WSN.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, WSN.ATTRIBUTE1 ATTRIBUTE1, WSN.ATTRIBUTE2 ATTRIBUTE2, WSN.ATTRIBUTE3 ATTRIBUTE3, WSN.ATTRIBUTE4 ATTRIBUTE4, WSN.ATTRIBUTE5 ATTRIBUTE5, WSN.ATTRIBUTE6 ATTRIBUTE6, WSN.ATTRIBUTE7 ATTRIBUTE7, WSN.ATTRIBUTE8 ATTRIBUTE8, WSN.ATTRIBUTE9 ATTRIBUTE9, WSN.ATTRIBUTE10 ATTRIBUTE10, WSN.ATTRIBUTE11 ATTRIBUTE11, WSN.ATTRIBUTE12 ATTRIBUTE12, WSN.ATTRIBUTE13 ATTRIBUTE13, WSN.ATTRIBUTE14 ATTRIBUTE14, WSN.ATTRIBUTE15 ATTRIBUTE15 FROM WSH_DELIVERY_DETAILS WDD, WSH_SERIAL_NUMBERS WSN WHERE WDD.SOURCE_CODE = 'OE' AND WDD.DELIVERY_DETAIL_ID = WSN.DELIVERY_DETAIL_ID AND WDD.TRANSACTION_TEMP_ID IS NOT NULL UNION SELECT WDD.DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID, MSNT.FM_SERIAL_NUMBER FM_SERIAL_NUMBER, MSNT.TO_SERIAL_NUMBER TO_SERIAL_NUMBER, TO_NUMBER(MSNT.SERIAL_PREFIX) QUANTITY, MSNT.CREATION_DATE CREATION_DATE, MSNT.CREATED_BY CREATED_BY, MSNT.LAST_UPDATE_DATE LAST_UPDATE_DATE, MSNT.LAST_UPDATED_BY LAST_UPDATED_BY, MSNT.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, MSNT.ATTRIBUTE1 ATTRIBUTE1, MSNT.ATTRIBUTE2 ATTRIBUTE2, MSNT.ATTRIBUTE3 ATTRIBUTE3, MSNT.ATTRIBUTE4 ATTRIBUTE4, MSNT.ATTRIBUTE5 ATTRIBUTE5, MSNT.ATTRIBUTE6 ATTRIBUTE6, MSNT.ATTRIBUTE7 ATTRIBUTE7, MSNT.ATTRIBUTE8 ATTRIBUTE8, MSNT.ATTRIBUTE9 ATTRIBUTE9, MSNT.ATTRIBUTE10 ATTRIBUTE10, MSNT.ATTRIBUTE11 ATTRIBUTE11, MSNT.ATTRIBUTE12 ATTRIBUTE12, MSNT.ATTRIBUTE13 ATTRIBUTE13, MSNT.ATTRIBUTE14 ATTRIBUTE14, MSNT.ATTRIBUTE15 ATTRIBUTE15 FROM WSH_DELIVERY_DETAILS WDD, MTL_SERIAL_NUMBERS_TEMP MSNT WHERE WDD.SOURCE_CODE = 'OE' AND WDD.TRANSACTION_TEMP_ID = MSNT.TRANSACTION_TEMP_ID AND WDD.TRANSACTION_TEMP_ID IS NOT NULL UNION SELECT WDD.DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID, WDD.SERIAL_NUMBER FM_SERIAL_NUMBER, WDD.TO_SERIAL_NUMBER TO_SERIAL_NUMBER, WDD.SHIPPED_QUANTITY QUANTITY, NULL CREATION_DATE, NULL CREATED_BY, NULL LAST_UPDATE_DATE, NULL LAST_UPDATED_BY, NULL ATTRIBUTE_CATEGORY, NULL ATTRIBUTE1, NULL ATTRIBUTE2, NULL ATTRIBUTE3, NULL ATTRIBUTE4, NULL ATTRIBUTE5, NULL ATTRIBUTE6, NULL ATTRIBUTE7, NULL ATTRIBUTE8, NULL ATTRIBUTE9, NULL ATTRIBUTE10, NULL ATTRIBUTE11, NULL ATTRIBUTE12, NULL ATTRIBUTE13, NULL ATTRIBUTE14, NULL ATTRIBUTE15 FROM WSH_DELIVERY_DETAILS WDD WHERE WDD.SOURCE_CODE = 'OE' AND WDD.SERIAL_NUMBER IS NOT NULL AND WDD.TRANSACTION_TEMP_ID IS NULL

View Text - HTML Formatted

SELECT WDD.DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID
, WSN.FM_SERIAL_NUMBER FM_SERIAL_NUMBER
, WSN.TO_SERIAL_NUMBER TO_SERIAL_NUMBER
, WSN.QUANTITY QUANTITY
, WSN.CREATION_DATE CREATION_DATE
, WSN.CREATED_BY CREATED_BY
, WSN.LAST_UPDATE_DATE LAST_UPDATE_DATE
, WSN.LAST_UPDATED_BY LAST_UPDATED_BY
, WSN.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, WSN.ATTRIBUTE1 ATTRIBUTE1
, WSN.ATTRIBUTE2 ATTRIBUTE2
, WSN.ATTRIBUTE3 ATTRIBUTE3
, WSN.ATTRIBUTE4 ATTRIBUTE4
, WSN.ATTRIBUTE5 ATTRIBUTE5
, WSN.ATTRIBUTE6 ATTRIBUTE6
, WSN.ATTRIBUTE7 ATTRIBUTE7
, WSN.ATTRIBUTE8 ATTRIBUTE8
, WSN.ATTRIBUTE9 ATTRIBUTE9
, WSN.ATTRIBUTE10 ATTRIBUTE10
, WSN.ATTRIBUTE11 ATTRIBUTE11
, WSN.ATTRIBUTE12 ATTRIBUTE12
, WSN.ATTRIBUTE13 ATTRIBUTE13
, WSN.ATTRIBUTE14 ATTRIBUTE14
, WSN.ATTRIBUTE15 ATTRIBUTE15
FROM WSH_DELIVERY_DETAILS WDD
, WSH_SERIAL_NUMBERS WSN
WHERE WDD.SOURCE_CODE = 'OE'
AND WDD.DELIVERY_DETAIL_ID = WSN.DELIVERY_DETAIL_ID
AND WDD.TRANSACTION_TEMP_ID IS NOT NULL UNION SELECT WDD.DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID
, MSNT.FM_SERIAL_NUMBER FM_SERIAL_NUMBER
, MSNT.TO_SERIAL_NUMBER TO_SERIAL_NUMBER
, TO_NUMBER(MSNT.SERIAL_PREFIX) QUANTITY
, MSNT.CREATION_DATE CREATION_DATE
, MSNT.CREATED_BY CREATED_BY
, MSNT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MSNT.LAST_UPDATED_BY LAST_UPDATED_BY
, MSNT.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, MSNT.ATTRIBUTE1 ATTRIBUTE1
, MSNT.ATTRIBUTE2 ATTRIBUTE2
, MSNT.ATTRIBUTE3 ATTRIBUTE3
, MSNT.ATTRIBUTE4 ATTRIBUTE4
, MSNT.ATTRIBUTE5 ATTRIBUTE5
, MSNT.ATTRIBUTE6 ATTRIBUTE6
, MSNT.ATTRIBUTE7 ATTRIBUTE7
, MSNT.ATTRIBUTE8 ATTRIBUTE8
, MSNT.ATTRIBUTE9 ATTRIBUTE9
, MSNT.ATTRIBUTE10 ATTRIBUTE10
, MSNT.ATTRIBUTE11 ATTRIBUTE11
, MSNT.ATTRIBUTE12 ATTRIBUTE12
, MSNT.ATTRIBUTE13 ATTRIBUTE13
, MSNT.ATTRIBUTE14 ATTRIBUTE14
, MSNT.ATTRIBUTE15 ATTRIBUTE15
FROM WSH_DELIVERY_DETAILS WDD
, MTL_SERIAL_NUMBERS_TEMP MSNT
WHERE WDD.SOURCE_CODE = 'OE'
AND WDD.TRANSACTION_TEMP_ID = MSNT.TRANSACTION_TEMP_ID
AND WDD.TRANSACTION_TEMP_ID IS NOT NULL UNION SELECT WDD.DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID
, WDD.SERIAL_NUMBER FM_SERIAL_NUMBER
, WDD.TO_SERIAL_NUMBER TO_SERIAL_NUMBER
, WDD.SHIPPED_QUANTITY QUANTITY
, NULL CREATION_DATE
, NULL CREATED_BY
, NULL LAST_UPDATE_DATE
, NULL LAST_UPDATED_BY
, NULL ATTRIBUTE_CATEGORY
, NULL ATTRIBUTE1
, NULL ATTRIBUTE2
, NULL ATTRIBUTE3
, NULL ATTRIBUTE4
, NULL ATTRIBUTE5
, NULL ATTRIBUTE6
, NULL ATTRIBUTE7
, NULL ATTRIBUTE8
, NULL ATTRIBUTE9
, NULL ATTRIBUTE10
, NULL ATTRIBUTE11
, NULL ATTRIBUTE12
, NULL ATTRIBUTE13
, NULL ATTRIBUTE14
, NULL ATTRIBUTE15
FROM WSH_DELIVERY_DETAILS WDD
WHERE WDD.SOURCE_CODE = 'OE'
AND WDD.SERIAL_NUMBER IS NOT NULL
AND WDD.TRANSACTION_TEMP_ID IS NULL