Product: | OTA - Learning Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OTA_BKNG_JUSTIFICATIONS_VL |
SELECT BJS.ROWID
, BJS.BOOKING_JUSTIFICATION_ID
, BJT.JUSTIFICATION_TEXT
, BJS.PRIORITY_LEVEL
, BJS.BUSINESS_GROUP_ID
, BJS.OBJECT_VERSION_NUMBER
, BJS.START_DATE_ACTIVE
, BJS.END_DATE_ACTIVE
, BJT.CREATED_BY
, BJT.CREATION_DATE
, BJT.LAST_UPDATE_DATE
, BJT.LAST_UPDATED_BY
, BJT.LAST_UPDATE_LOGIN
FROM OTA_BKNG_JUSTIFICATIONS_B BJS
, OTA_BKNG_JUSTIFICATIONS_TL BJT
WHERE BJS.BOOKING_JUSTIFICATION_ID = BJS.BOOKING_JUSTIFICATION_ID
AND BJT.LANGUAGE= USERENV('LANG')