VIEW: APPS.CSD_JOB_HEADER_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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