View: CSD_IR_REPAIR_JOBS_V

Product:	CSD - Depot Repair
Description:	The view used in Submit Repair Jobs if the Allow create WIP Job w/o RMA is set
Implementation/DBA Data:	APPS.CSD_IR_REPAIR_JOBS_V

View Text

SELECT DRA.ROWID
, DRA.REPAIR_LINE_ID
, DRA.CREATED_BY
, DRA.CREATION_DATE
, DRA.LAST_UPDATED_BY
, DRA.LAST_UPDATE_DATE
, DRA.LAST_UPDATE_LOGIN
, DRA.REPAIR_NUMBER
, DRA.INCIDENT_ID
, SR.INCIDENT_NUMBER
, SR.CUSTOMER_ID
, SR.CALLER_TYPE
, DRA.INVENTORY_ITEM_ID
, ITEM.CONCATENATED_SEGMENTS
, ITEM.DESCRIPTION
, ITEM.ORGANIZATION_ID
, DRA.UNIT_OF_MEASURE
, DRA.QUANTITY
, NVL(DRA.QUANTITY_RCVD
, 0) RELEASED_QUANTITY
, (NVL(DRA.QUANTITY
, 0) - NVL(DRA.QUANTITY_IN_WIP
, 0)) REMAINING_QUANTITY
, NVL(DRA.QUANTITY_IN_WIP
, 0)
, NVL(DRA.QUANTITY_RCVD
, 0)
, NVL(DRA.QUANTITY_SHIPPED
, 0)
, DRA.PROJECT_ID
, DRA.TASK_ID
, DRA.CUSTOMER_PRODUCT_ID
, CP.INSTANCE_NUMBER
, DRA.SERIAL_NUMBER
, DRA.RESOURCE_ID
, NULL
, NULL
, DRA.REPAIR_TYPE_ID
, RTYPE.NAME
, DRA.INSTANCE_ID
, DRA.APPROVAL_REQUIRED_FLAG
, DRA.APPROVAL_STATUS
, FND1.MEANING
, DRA.STATUS
, FND2.MEANING
, DRA.DATE_CLOSED
, DRA.PROMISE_DATE
, 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
, DECODE (SR.CALLER_TYPE
, 'ORGANIZATION'
, HZP.PARTY_NAME
, 'PERSON'
, HZP.PERSON_FIRST_NAME||' '||HZP.PERSON_LAST_NAME
, PAPF.FULL_NAME) "PARTY_NAME"
, DECODE (SR.CALLER_TYPE
, 'ORGANIZATION'
, HZP.PARTY_NUMBER
, 'PERSON'
, HZP.PARTY_NUMBER
, PAPF.EMPLOYEE_NUMBER ) "PARTY_NUMBER"
, SEV.NAME SEVERITY
, URG.NAME URGENCY
, CITB.NAME INCIDENT_TYPE
, STAT.NAME INCIDENT_STATUS
, SR.INCIDENT_DATE
FROM CSD_REPAIRS DRA
, CS_INCIDENTS_ALL_B SR
, CSI_ITEM_INSTANCES CP
, MTL_SYSTEM_ITEMS_VL ITEM
, CSD_REPAIR_TYPES_VL RTYPE
, FND_LOOKUPS FND1
, FND_LOOKUPS FND2
, HZ_PARTIES HZP
, CS_INCIDENT_SEVERITIES_VL SEV
, CS_INCIDENT_URGENCIES_VL URG
, CS_INCIDENT_TYPES_VL CITB
, CS_INCIDENT_STATUSES_VL STAT
, PER_ALL_PEOPLE_F PAPF
WHERE DRA.INCIDENT_ID = SR.INCIDENT_ID
AND DRA.REPAIR_TYPE_ID = RTYPE.REPAIR_TYPE_ID
AND DRA.APPROVAL_STATUS = FND1.LOOKUP_CODE (+)
AND FND1.LOOKUP_TYPE (+) = 'CSD_APPROVAL_STATUS'
AND DRA.STATUS = FND2.LOOKUP_CODE
AND FND2.LOOKUP_TYPE = 'CSD_REPAIR_STATUS'
AND DRA.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID
AND (DRA.APPROVAL_REQUIRED_FLAG = 'N' OR (DRA.APPROVAL_REQUIRED_FLAG = 'Y'
AND DRA.APPROVAL_STATUS = 'A'))
AND DRA.CUSTOMER_PRODUCT_ID = CP.INSTANCE_ID(+)
AND SR.CUSTOMER_ID = HZP.PARTY_ID
AND SR.INCIDENT_SEVERITY_ID = SEV.INCIDENT_SEVERITY_ID
AND SR.INCIDENT_URGENCY_ID = URG.INCIDENT_URGENCY_ID
AND CITB.INCIDENT_TYPE_ID = SR.INCIDENT_TYPE_ID
AND STAT.INCIDENT_STATUS_ID = SR.INCIDENT_STATUS_ID
AND SR.EMPLOYEE_ID = PAPF.PERSON_ID(+)

Columns