Product: | GMD - Process Manufacturing Product Development |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GMD_ITEM_SUBSTITUTION_HDR_VL |
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')