DBA Data[Home] [Help]

VIEW: APPS.CSD_REPAIR_ACTUAL_V

Source

View Text - Preformatted

SELECT cra.ROWID, cr.repair_line_id, cr.repair_number, cra.repair_actual_id, cra.context, cra.attribute1 ATTRIBUTE1, cra.attribute2, cra.attribute3, cra.attribute4, cra.attribute5, cra.attribute6, cra.attribute7, cra.attribute8, cra.attribute9, cra.attribute10, cra.attribute11, cra.attribute12, cra.attribute13, cra.attribute14, cra.attribute15, cra.created_by, cra.creation_date, cra.last_updated_by, cra.last_update_date, cra.last_update_login, cra.object_version_number FROM csd_repairs cr, csd_repair_actuals cra WHERE cr.repair_line_id = cra.repair_line_id
View Text - HTML Formatted

SELECT CRA.ROWID
, CR.REPAIR_LINE_ID
, CR.REPAIR_NUMBER
, CRA.REPAIR_ACTUAL_ID
, CRA.CONTEXT
, CRA.ATTRIBUTE1 ATTRIBUTE1
, CRA.ATTRIBUTE2
, CRA.ATTRIBUTE3
, CRA.ATTRIBUTE4
, CRA.ATTRIBUTE5
, CRA.ATTRIBUTE6
, CRA.ATTRIBUTE7
, CRA.ATTRIBUTE8
, CRA.ATTRIBUTE9
, CRA.ATTRIBUTE10
, CRA.ATTRIBUTE11
, CRA.ATTRIBUTE12
, CRA.ATTRIBUTE13
, CRA.ATTRIBUTE14
, CRA.ATTRIBUTE15
, CRA.CREATED_BY
, CRA.CREATION_DATE
, CRA.LAST_UPDATED_BY
, CRA.LAST_UPDATE_DATE
, CRA.LAST_UPDATE_LOGIN
, CRA.OBJECT_VERSION_NUMBER
FROM CSD_REPAIRS CR
, CSD_REPAIR_ACTUALS CRA
WHERE CR.REPAIR_LINE_ID = CRA.REPAIR_LINE_ID