Product: | CSD - Depot Repair |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CSD_SC_RECOMMENDATIONS_VL |
SELECT B.ROWID AS ROW_ID
, B.SC_RECOMMENDATION_ID
, B.OBJECT_VERSION_NUMBER
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.SC_DOMAIN_ID
, B.RECOMMENDATION_TYPE_CODE
, B.ACTIVE_FROM
, B.ACTIVE_TO
, TL.SC_RECOMMENDATION_NAME
FROM CSD_SC_RECOMMENDATIONS_B B
, CSD_SC_RECOMMENDATIONS_TL TL
WHERE B.SC_RECOMMENDATION_ID = TL.SC_RECOMMENDATION_ID
AND TL.LANGUAGE = USERENV('LANG')