Product: | INV - Inventory |
---|---|
Description: | |
Implementation/DBA Data: |
![]() |
SELECT OFT.ROWID ROW_ID
, OFT.FREIGHT_CODE
, OFT.ORGANIZATION_ID
, OFT.FREIGHT_CODE_TL
, OFT.LANGUAGE
, OFT.SOURCE_LANG
, OFT.LAST_UPDATE_DATE
, OFT.LAST_UPDATED_BY
, OFT.CREATION_DATE
, OFT.CREATED_BY
, OFT.LAST_UPDATE_LOGIN
, OFT.DESCRIPTION
, OFT.DISABLE_DATE
, OFT.DISTRIBUTION_ACCOUNT
, OFT.ATTRIBUTE_CATEGORY
, OFT.ATTRIBUTE1
, OFT.ATTRIBUTE2
, OFT.ATTRIBUTE3
, OFT.ATTRIBUTE4
, OFT.ATTRIBUTE5
, OFT.ATTRIBUTE6
, OFT.ATTRIBUTE7
, OFT.ATTRIBUTE8
, OFT.ATTRIBUTE9
, OFT.ATTRIBUTE10
, OFT.ATTRIBUTE11
, OFT.ATTRIBUTE12
, OFT.ATTRIBUTE13
, OFT.ATTRIBUTE14
, OFT.ATTRIBUTE15
, OFT.GLOBAL_ATTRIBUTE1
, OFT.GLOBAL_ATTRIBUTE2
, OFT.GLOBAL_ATTRIBUTE3
, OFT.GLOBAL_ATTRIBUTE4
, OFT.GLOBAL_ATTRIBUTE5
, OFT.GLOBAL_ATTRIBUTE6
, OFT.GLOBAL_ATTRIBUTE7
, OFT.GLOBAL_ATTRIBUTE8
, OFT.GLOBAL_ATTRIBUTE9
, OFT.GLOBAL_ATTRIBUTE10
, OFT.GLOBAL_ATTRIBUTE11
, OFT.GLOBAL_ATTRIBUTE12
, OFT.GLOBAL_ATTRIBUTE13
, OFT.GLOBAL_ATTRIBUTE14
, OFT.GLOBAL_ATTRIBUTE15
, OFT.GLOBAL_ATTRIBUTE16
, OFT.GLOBAL_ATTRIBUTE17
, OFT.GLOBAL_ATTRIBUTE18
, OFT.GLOBAL_ATTRIBUTE19
, OFT.GLOBAL_ATTRIBUTE20
, OFT.GLOBAL_ATTRIBUTE_CATEGORY
, OFT.PARTY_ID
, MP.ORGANIZATION_CODE
FROM ORG_FREIGHT_TL OFT
, MTL_PARAMETERS MP
WHERE LANGUAGE = USERENV('LANG')
AND OFT.ORGANIZATION_ID = MP.ORGANIZATION_ID