View: CSD_SC_RECOMMENDATIONS_VL

Product:	CSD - Depot Repair
Description:
Implementation/DBA Data:	APPS.CSD_SC_RECOMMENDATIONS_VL

View Text

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')

Columns