VIEW: APPS.ORG_FREIGHT_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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