VIEW: APPS.OTA_OFFERINGS_VL

Source

View Text - Preformatted

SELECT OFR.ROWID, OFR.OFFERING_ID, OFR.ACTIVITY_VERSION_ID, OFL.NAME, OFL.DESCRIPTION, OFR.BUSINESS_GROUP_ID, OFR.START_DATE, OFR.END_DATE, OFR.OWNER_ID, OFR.DELIVERY_MODE_ID, OFR.LANGUAGE_ID, OFR.DURATION, OFR.DURATION_UNITS, OFR.LEARNING_OBJECT_ID, OFR.PLAYER_TOOLBAR_FLAG, OFR.PLAYER_TOOLBAR_BITSET, OFR.PLAYER_NEW_WINDOW_FLAG, OFR.MINIMUM_ATTENDEES, OFR.MAXIMUM_ATTENDEES, OFR.MAXIMUM_INTERNAL_ATTENDEES, OFR.ACTUAL_COST, OFR.BUDGET_COST, OFR.BUDGET_CURRENCY_CODE, OFR.PRICE_BASIS, OFR.CURRENCY_CODE, OFR.STANDARD_PRICE, OFR.OBJECT_VERSION_NUMBER, OFR.CREATED_BY, OFR.CREATION_DATE, OFR.LAST_UPDATE_DATE, OFR.LAST_UPDATED_BY, OFR.LAST_UPDATE_LOGIN, OFR.ATTRIBUTE_CATEGORY, OFR.ATTRIBUTE1, OFR.ATTRIBUTE2, OFR.ATTRIBUTE3, OFR.ATTRIBUTE4, OFR.ATTRIBUTE5, OFR.ATTRIBUTE6, OFR.ATTRIBUTE7, OFR.ATTRIBUTE8, OFR.ATTRIBUTE9, OFR.ATTRIBUTE10, OFR.ATTRIBUTE11, OFR.ATTRIBUTE12, OFR.ATTRIBUTE13, OFR.ATTRIBUTE14, OFR.ATTRIBUTE15, OFR.ATTRIBUTE16, OFR.ATTRIBUTE17, OFR.ATTRIBUTE18, OFR.ATTRIBUTE19, OFR.ATTRIBUTE20, OFR.DATA_SOURCE, OFR.VENDOR_ID, OFR.COMPETENCY_UPDATE_LEVEL, OFR.LANGUAGE_CODE FROM OTA_OFFERINGS OFR, OTA_OFFERINGS_TL OFL WHERE OFR.OFFERING_ID = OFL.OFFERING_ID AND OFL.LANGUAGE= USERENV('LANG')

View Text - HTML Formatted

SELECT OFR.ROWID
, OFR.OFFERING_ID
, OFR.ACTIVITY_VERSION_ID
, OFL.NAME
, OFL.DESCRIPTION
, OFR.BUSINESS_GROUP_ID
, OFR.START_DATE
, OFR.END_DATE
, OFR.OWNER_ID
, OFR.DELIVERY_MODE_ID
, OFR.LANGUAGE_ID
, OFR.DURATION
, OFR.DURATION_UNITS
, OFR.LEARNING_OBJECT_ID
, OFR.PLAYER_TOOLBAR_FLAG
, OFR.PLAYER_TOOLBAR_BITSET
, OFR.PLAYER_NEW_WINDOW_FLAG
, OFR.MINIMUM_ATTENDEES
, OFR.MAXIMUM_ATTENDEES
, OFR.MAXIMUM_INTERNAL_ATTENDEES
, OFR.ACTUAL_COST
, OFR.BUDGET_COST
, OFR.BUDGET_CURRENCY_CODE
, OFR.PRICE_BASIS
, OFR.CURRENCY_CODE
, OFR.STANDARD_PRICE
, OFR.OBJECT_VERSION_NUMBER
, OFR.CREATED_BY
, OFR.CREATION_DATE
, OFR.LAST_UPDATE_DATE
, OFR.LAST_UPDATED_BY
, OFR.LAST_UPDATE_LOGIN
, OFR.ATTRIBUTE_CATEGORY
, OFR.ATTRIBUTE1
, OFR.ATTRIBUTE2
, OFR.ATTRIBUTE3
, OFR.ATTRIBUTE4
, OFR.ATTRIBUTE5
, OFR.ATTRIBUTE6
, OFR.ATTRIBUTE7
, OFR.ATTRIBUTE8
, OFR.ATTRIBUTE9
, OFR.ATTRIBUTE10
, OFR.ATTRIBUTE11
, OFR.ATTRIBUTE12
, OFR.ATTRIBUTE13
, OFR.ATTRIBUTE14
, OFR.ATTRIBUTE15
, OFR.ATTRIBUTE16
, OFR.ATTRIBUTE17
, OFR.ATTRIBUTE18
, OFR.ATTRIBUTE19
, OFR.ATTRIBUTE20
, OFR.DATA_SOURCE
, OFR.VENDOR_ID
, OFR.COMPETENCY_UPDATE_LEVEL
, OFR.LANGUAGE_CODE
FROM OTA_OFFERINGS OFR
, OTA_OFFERINGS_TL OFL
WHERE OFR.OFFERING_ID = OFL.OFFERING_ID
AND OFL.LANGUAGE= USERENV('LANG')