View: CSD_RO_GROUP_ESTIMATE_V

Product:	CSD - Depot Repair
Description:	View to summarize all the estimates for a given repair order line by MLE categories.
Implementation/DBA Data:	APPS.CSD_RO_GROUP_ESTIMATE_V

View Text

SELECT CR.ROWID
, CR.REPAIR_NUMBER
, CR.REPAIR_LINE_ID
, CR.REPAIR_GROUP_ID
, CSD_PROCESS_UTIL.GET_ESTIMATE(CR.REPAIR_LINE_ID
, 'M') MATERIAL
, CSD_PROCESS_UTIL.GET_ESTIMATE(CR.REPAIR_LINE_ID
, 'L') LABOR
, CSD_PROCESS_UTIL.GET_ESTIMATE(CR.REPAIR_LINE_ID
, 'E') EXPENSE
, CSD_PROCESS_UTIL.GET_ESTIMATE(CR.REPAIR_LINE_ID
, 'T') TOTAL_ESTIMATE
, CR.APPROVAL_REQUIRED_FLAG
, FL.MEANING ESIMATE_STATUS
, FL1.MEANING APPROVAL_STATUS
FROM CSD_REPAIRS CR
, CSD_REPAIR_ESTIMATE CRE
, FND_LOOKUPS FL
, FND_LOOKUPS FL1
WHERE CR.REPAIR_LINE_ID = CRE.REPAIR_LINE_ID(+)
AND FL.LOOKUP_CODE(+) = CRE.ESTIMATE_STATUS
AND FL.LOOKUP_TYPE(+) = 'CSD_ESTIMATE_STATUS'
AND FL1.LOOKUP_CODE(+) = CR.APPROVAL_STATUS
AND FL1.LOOKUP_TYPE(+) = 'CSD_APPROVAL_STATUS'

Columns