View: CSD_RO_APPLICABLE_SC_V

Product:	CSD - Depot Repair
Description:	This view gets all the repair orders having applicable service codes, along with the applicable service codes.
Implementation/DBA Data:	APPS.CSD_RO_APPLICABLE_SC_V

View Text

SELECT RSC.ROWID ROW_ID
, RSC.RO_SERVICE_CODE_ID
, RSC.OBJECT_VERSION_NUMBER
, RSC.REPAIR_LINE_ID
, RSC.SERVICE_CODE_ID
, CSC.NAME SERVICE_CODE
, CSC.DESCRIPTION SERVICE_CODE_DESC
, CSC.ACTIVE_FROM
, CSC.ACTIVE_TO
, RSC.CREATED_BY
, RSC.CREATION_DATE
, RSC.LAST_UPDATED_BY
, RSC.LAST_UPDATE_DATE
, RSC.LAST_UPDATE_LOGIN
FROM CSD_RO_SERVICE_CODES RSC
, CSD_SERVICE_CODES_VL CSC
WHERE RSC.APPLICABLE_FLAG = 'Y'
AND RSC.SERVICE_CODE_ID = CSC.SERVICE_CODE_ID

Columns