VIEW: APPS.CSD_RO_GROUP_ESTIMATE_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'