VIEW: APPS.CSD_REPAIR_ESTIMATE_V

Source

View Text - Preformatted

SELECT cre.rowid, cr.repair_line_id, cr.repair_number, cre.repair_estimate_id, cre.estimate_date, cre.estimate_status, cr.repair_mode, cr.repair_type_id, cr.incident_id, cia.incident_number, cr.quantity repair_quantity, cr.approval_required_flag, cr.approval_status, cr.status, cr.promise_date, cre.context, cre.attribute1, cre.attribute2, cre.attribute3, cre.attribute4, cre.attribute5, cre.attribute6, cre.attribute7, cre.attribute8, cre.attribute9, cre.attribute10, cre.attribute11, cre.attribute12, cre.attribute13, cre.attribute14, cre.attribute15, cre.created_by, cre.creation_date, cre.last_updated_by, cre.last_update_date, cre.last_update_login, cre.work_summary, cre.lead_time, cre.lead_time_uom, cre.object_version_number, cre.po_number, cre.estimate_freeze_flag, cre.estimate_reason_code, cre.not_to_exceed, cre.routing_sequence_id FROM csd_repairs cr, cs_incidents_b_sec cia, csd_repair_estimate cre WHERE cr.incident_id = cia.incident_id and cr.repair_line_id = cre.repair_line_id

View Text - HTML Formatted

SELECT CRE.ROWID
, CR.REPAIR_LINE_ID
, CR.REPAIR_NUMBER
, CRE.REPAIR_ESTIMATE_ID
, CRE.ESTIMATE_DATE
, CRE.ESTIMATE_STATUS
, CR.REPAIR_MODE
, CR.REPAIR_TYPE_ID
, CR.INCIDENT_ID
, CIA.INCIDENT_NUMBER
, CR.QUANTITY REPAIR_QUANTITY
, CR.APPROVAL_REQUIRED_FLAG
, CR.APPROVAL_STATUS
, CR.STATUS
, CR.PROMISE_DATE
, CRE.CONTEXT
, CRE.ATTRIBUTE1
, CRE.ATTRIBUTE2
, CRE.ATTRIBUTE3
, CRE.ATTRIBUTE4
, CRE.ATTRIBUTE5
, CRE.ATTRIBUTE6
, CRE.ATTRIBUTE7
, CRE.ATTRIBUTE8
, CRE.ATTRIBUTE9
, CRE.ATTRIBUTE10
, CRE.ATTRIBUTE11
, CRE.ATTRIBUTE12
, CRE.ATTRIBUTE13
, CRE.ATTRIBUTE14
, CRE.ATTRIBUTE15
, CRE.CREATED_BY
, CRE.CREATION_DATE
, CRE.LAST_UPDATED_BY
, CRE.LAST_UPDATE_DATE
, CRE.LAST_UPDATE_LOGIN
, CRE.WORK_SUMMARY
, CRE.LEAD_TIME
, CRE.LEAD_TIME_UOM
, CRE.OBJECT_VERSION_NUMBER
, CRE.PO_NUMBER
, CRE.ESTIMATE_FREEZE_FLAG
, CRE.ESTIMATE_REASON_CODE
, CRE.NOT_TO_EXCEED
, CRE.ROUTING_SEQUENCE_ID
FROM CSD_REPAIRS CR
, CS_INCIDENTS_B_SEC CIA
, CSD_REPAIR_ESTIMATE CRE
WHERE CR.INCIDENT_ID = CIA.INCIDENT_ID
AND CR.REPAIR_LINE_ID = CRE.REPAIR_LINE_ID