VIEW: APPS.GMD_ITEM_SUBSTITUTION_HDR_VL

Source

View Text - Preformatted

SELECT itsub.ROWID ,itsub.SUBSTITUTION_ID ,itsub.SUBSTITUTION_NAME ,itsubt.SUBSTITUTION_DESCRIPTION ,itsub.SUBSTITUTION_VERSION ,itsub.SUBSTITUTION_STATUS ,itsub.ORIGINAL_ITEM_ID ,itsub.ORIGINAL_QTY ,itsub.PREFERENCE ,itsub.START_DATE ,itsub.END_DATE ,itsub.OWNER_ORGN_CODE ,itsub.REPLACEMENT_UOM_TYPE ,itsub.ATTRIBUTE_CATEGORY ,itsub.ATTRIBUTE1 ,itsub.ATTRIBUTE2 ,itsub.ATTRIBUTE3 ,itsub.ATTRIBUTE4 ,itsub.ATTRIBUTE5 ,itsub.ATTRIBUTE6 ,itsub.ATTRIBUTE7 ,itsub.ATTRIBUTE8 ,itsub.ATTRIBUTE9 ,itsub.ATTRIBUTE10 ,itsub.ATTRIBUTE11 ,itsub.ATTRIBUTE12 ,itsub.ATTRIBUTE13 ,itsub.ATTRIBUTE14 ,itsub.ATTRIBUTE15 ,itsub.ATTRIBUTE16 ,itsub.ATTRIBUTE17 ,itsub.ATTRIBUTE18 ,itsub.ATTRIBUTE19 ,itsub.ATTRIBUTE20 ,itsub.ATTRIBUTE21 ,itsub.ATTRIBUTE22 ,itsub.ATTRIBUTE23 ,itsub.ATTRIBUTE24 ,itsub.ATTRIBUTE25 ,itsub.ATTRIBUTE26 ,itsub.ATTRIBUTE27 ,itsub.ATTRIBUTE28 ,itsub.ATTRIBUTE29 ,itsub.ATTRIBUTE30 ,itsub.CREATED_BY ,itsub.CREATION_DATE ,itsub.LAST_UPDATE_DATE ,itsub.LAST_UPDATED_BY ,itsub.LAST_UPDATE_LOGIN ,itsub.ORIGINAL_INVENTORY_ITEM_ID ,itsub.ORIGINAL_UOM ,itsub.OWNER_ORGANIZATION_ID FROM GMD_ITEM_SUBSTITUTION_HDR_B itsub, GMD_ITEM_SUBSTITUTION_HDR_TL itsubt WHERE itsub.SUBSTITUTION_ID = itsubt.SUBSTITUTION_ID AND itsubt.LANGUAGE = USERENV ('LANG')

View Text - HTML Formatted

SELECT ITSUB.ROWID
, ITSUB.SUBSTITUTION_ID
, ITSUB.SUBSTITUTION_NAME
, ITSUBT.SUBSTITUTION_DESCRIPTION
, ITSUB.SUBSTITUTION_VERSION
, ITSUB.SUBSTITUTION_STATUS
, ITSUB.ORIGINAL_ITEM_ID
, ITSUB.ORIGINAL_QTY
, ITSUB.PREFERENCE
, ITSUB.START_DATE
, ITSUB.END_DATE
, ITSUB.OWNER_ORGN_CODE
, ITSUB.REPLACEMENT_UOM_TYPE
, ITSUB.ATTRIBUTE_CATEGORY
, ITSUB.ATTRIBUTE1
, ITSUB.ATTRIBUTE2
, ITSUB.ATTRIBUTE3
, ITSUB.ATTRIBUTE4
, ITSUB.ATTRIBUTE5
, ITSUB.ATTRIBUTE6
, ITSUB.ATTRIBUTE7
, ITSUB.ATTRIBUTE8
, ITSUB.ATTRIBUTE9
, ITSUB.ATTRIBUTE10
, ITSUB.ATTRIBUTE11
, ITSUB.ATTRIBUTE12
, ITSUB.ATTRIBUTE13
, ITSUB.ATTRIBUTE14
, ITSUB.ATTRIBUTE15
, ITSUB.ATTRIBUTE16
, ITSUB.ATTRIBUTE17
, ITSUB.ATTRIBUTE18
, ITSUB.ATTRIBUTE19
, ITSUB.ATTRIBUTE20
, ITSUB.ATTRIBUTE21
, ITSUB.ATTRIBUTE22
, ITSUB.ATTRIBUTE23
, ITSUB.ATTRIBUTE24
, ITSUB.ATTRIBUTE25
, ITSUB.ATTRIBUTE26
, ITSUB.ATTRIBUTE27
, ITSUB.ATTRIBUTE28
, ITSUB.ATTRIBUTE29
, ITSUB.ATTRIBUTE30
, ITSUB.CREATED_BY
, ITSUB.CREATION_DATE
, ITSUB.LAST_UPDATE_DATE
, ITSUB.LAST_UPDATED_BY
, ITSUB.LAST_UPDATE_LOGIN
, ITSUB.ORIGINAL_INVENTORY_ITEM_ID
, ITSUB.ORIGINAL_UOM
, ITSUB.OWNER_ORGANIZATION_ID
FROM GMD_ITEM_SUBSTITUTION_HDR_B ITSUB
, GMD_ITEM_SUBSTITUTION_HDR_TL ITSUBT
WHERE ITSUB.SUBSTITUTION_ID = ITSUBT.SUBSTITUTION_ID
AND ITSUBT.LANGUAGE = USERENV ('LANG')