View: CSD_JOB_HEADER_V

Product:	CSD - Depot Repair
Description:	This view gets the header information for the job to be submitted. This view is used by the header block of the submit Repair Job screen. This is specific to the header screen brought up, when navigate from the Repair order Workbench.
Implementation/DBA Data:	APPS.CSD_JOB_HEADER_V

View Text

SELECT DRA.ROWID ROW_ID
, DRA.REPAIR_LINE_ID
, DRA.OBJECT_VERSION_NUMBER
, DRA.REPAIR_NUMBER REPAIR_ORDER_NUMBER
, DECODE (SR.CALLER_TYPE
, 'ORGANIZATION'
, HZP.PARTY_NAME
, 'PERSON'
, HZP.PERSON_FIRST_NAME||' '||HZP.PERSON_LAST_NAME ) CUSTOMER_NAME
, DRA.QUANTITY REPAIR_ORDER_QUANTITY
, NVL(DRA.QUANTITY_RCVD
, 0) RECEIVED_QUANTITY
, RTYPE.NAME REPAIR_TYPE
, FND.MEANING REPAIR_ORDER_STATUS
, DRA.PROMISE_DATE REPAIR_PROMISE_DATE
, DRA.CREATED_BY
, DRA.CREATION_DATE
, DRA.LAST_UPDATED_BY
, DRA.LAST_UPDATE_DATE
, DRA.LAST_UPDATE_LOGIN
, DRA.ATTRIBUTE_CATEGORY
, DRA.ATTRIBUTE1
, DRA.ATTRIBUTE2
, DRA.ATTRIBUTE3
, DRA.ATTRIBUTE4
, DRA.ATTRIBUTE5
, DRA.ATTRIBUTE6
, DRA.ATTRIBUTE7
, DRA.ATTRIBUTE8
, DRA.ATTRIBUTE9
, DRA.ATTRIBUTE10
, DRA.ATTRIBUTE11
, DRA.ATTRIBUTE12
, DRA.ATTRIBUTE13
, DRA.ATTRIBUTE14
, DRA.ATTRIBUTE15
FROM CSD_REPAIRS DRA
, CS_INCIDENTS_ALL_B SR
, CSD_REPAIR_TYPES_VL RTYPE
, FND_LOOKUPS FND
, HZ_PARTIES HZP
WHERE DRA.INCIDENT_ID = SR.INCIDENT_ID
AND DRA.REPAIR_TYPE_ID = RTYPE.REPAIR_TYPE_ID
AND DRA.STATUS = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE = 'CSD_REPAIR_STATUS'
AND SR.CUSTOMER_ID = HZP.PARTY_ID

Columns