View: CSD_REPAIR_ESTIMATE_V

Product:	CSD - Depot Repair
Description:	Fetches the estimate header for repair orders.
Implementation/DBA Data:	APPS.CSD_REPAIR_ESTIMATE_V

View Text

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

Columns