View: CSD_RO_SOLNS_V

Product:	CSD - Depot Repair
Description:	Displays solutions that are linked to repair orders.
Implementation/DBA Data:	APPS.CSD_RO_SOLNS_V

View Text

SELECT KB.SET_ID
, KB.SET_NUMBER
, KB.SET_NAME
, KB.SET_LINK_TYPE
, KB.SET_LINK_TYPE_MEANING
, KB.OTHER_ID AS REPAIR_LINE_ID
, DECODE(CSD.APPLIED_FLAG
, 'Y'
, 'Y'
, 'N') AS APPLIED_FLAG
FROM CS_KB_LINKED_SOLUTIONS_VIEW KB
, (SELECT DISTINCT 'Y' AS APPLIED_FLAG
, CSD1.REPAIR_LINE_ID
, CSD1.SOURCE_SOLUTION_ID
FROM CSD_RO_SERVICE_CODES CSD1
, CS_KB_LINKED_SOLUTIONS_VIEW KB1
WHERE CSD1.REPAIR_LINE_ID = KB1.OTHER_ID
AND CSD1.SOURCE_TYPE_CODE = 'SOLUTION'
AND CSD1.SOURCE_SOLUTION_ID = KB1.SET_ID
AND (APPLIED_TO_EST_FLAG = 'Y' OR APPLIED_TO_WORK_FLAG = 'Y')) CSD
WHERE CSD.REPAIR_LINE_ID (+) = KB.OTHER_ID
AND CSD.SOURCE_SOLUTION_ID (+) = KB.SET_ID
AND KB.OBJECT_CODE = 'DR'
AND KB.SET_PUBLISHED_STATUS = 'PUB'

Columns