View: CSD_REPAIRS_V

Product:	CSD - Depot Repair
Description:	The view for getting repair orders.
Implementation/DBA Data:	APPS.CSD_REPAIRS_V

View Text

SELECT DRA.ROWID
, SR.ORG_ID
, DRA.REPAIR_LINE_ID
, DRA.REQUEST_ID
, DRA.PROGRAM_ID
, DRA.PROGRAM_APPLICATION_ID
, DRA.PROGRAM_UPDATE_DATE
, 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
, DRA.INVENTORY_ITEM_ID
, ITEMS.CONCATENATED_SEGMENTS
, ITEMS.DESCRIPTION ITEM_DESC
, DRA.UNIT_OF_MEASURE
, UOM.UNIT_OF_MEASURE_TL
, DRA.QUANTITY
, NVL(DRA.QUANTITY_IN_WIP
, 0)
, NVL(DRA.QUANTITY_RCVD
, 0)
, NVL(DRA.QUANTITY_SHIPPED
, 0)
, DRA.PROJECT_ID
, PPV.PROJECT_NUMBER
, DRA.TASK_ID
, PTV.TASK_NUMBER
, DRA.UNIT_NUMBER
, DRA.CONTRACT_LINE_ID
, OKH.CONTRACT_NUMBER
, OKH.ID
, DRA.CUSTOMER_PRODUCT_ID
, CP.INSTANCE_NUMBER
, CP.LOT_NUMBER
, CPS.NAME
, DECODE(DRA.CUSTOMER_PRODUCT_ID
, ''
, DRA.ITEM_REVISION
, CP.INVENTORY_REVISION)
, CP.SYSTEM_ID
, CP.LOCATION_ID
, DECODE(DRA.CUSTOMER_PRODUCT_ID
, ''
, DRA.SERIAL_NUMBER
, CP.SERIAL_NUMBER)
, DRA.RESOURCE_ID
, NULL
, NULL
, DRA.REPAIR_TYPE_ID
, DRTVL.NAME
, DRTVL.REPAIR_TYPE_REF
, DRTVL.INTERNAL_ORDER_FLAG
, DRA.INSTANCE_ID
, DRA.APPROVAL_REQUIRED_FLAG
, DRA.APPROVAL_STATUS
, FNDL1.MEANING
, DRA.STATUS
, FNDL2.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
, DRA.STATUS_REASON_CODE
, FNDL3.MEANING
, FNDL3.DESCRIPTION
, DRA.AUTO_PROCESS_RMA
, DRA.REPAIR_MODE
, DRA.OBJECT_VERSION_NUMBER
, DRA.CURRENCY_CODE
, DRA.DEFAULT_PO_NUM
, DRA.ORIGINAL_SOURCE_HEADER_ID
, DRA.ORIGINAL_SOURCE_LINE_ID
, DRA.SPLIT_FROM_REP_LINE_ID
, DRA.SPLIT_FLAG
, DRA.PRICE_LIST_HEADER_ID
, QP.NAME
, DRA.SUPERCESSION_INV_ITEM_ID
, DRTVL.BUSINESS_PROCESS_ID BUSINESS_PROCESS_ID
, DRA.FLOW_STATUS_ID FLOW_STATUS_ID
, FS_B.FLOW_STATUS_CODE FLOW_STATUS_CODE
, FS_LKUP.MEANING FLOW_STATUS
, DRA.WF_ITEM_TYPE WF_ITEM_TYPE
, DRA.WF_ITEM_KEY WF_ITEM_KEY
, DRA.OWNING_ORGANIZATION_ID
, DRA.INVENTORY_ORG_ID
, DRA.PROBLEM_DESCRIPTION
, DRA.RO_PRIORITY_CODE
, P_LKUP.MEANING RO_PRIORITY_MEANING
, DRA.RESOLVE_BY_DATE
, FNDES.LOOKUP_CODE ESCALATION_CODE
, FNDES.MEANING ESCALATION_MEANING
, FNDES.DESCRIPTION ESCALATION_DESC
, FNDIW.LOOKUP_CODE IN_WARRANTY_CODE
, FNDIW.MEANING IN_WARRANTY_MEANING
, FNDIW.DESCRIPTION IN_WARRANTY_DESC
, FNDWV.LOOKUP_CODE WARRANTY_VIOLATION_CODE
, FNDWV.MEANING WARRANTY_VIOLATION_MEANING
, FNDWV.DESCRIPTION WARRANTY_VIOLATION_DESC
, FNDRWK.LOOKUP_CODE REWORK_CODE
, FNDRWK.MEANING REWORK_MEANING
, FNDRWK.DESCRIPTION REWORK_DESC
, DRA.BULLETIN_CHECK_DATE
, DRA.REPAIR_YIELD_QUANTITY
, DRA.ATTRIBUTE16
, DRA.ATTRIBUTE17
, DRA.ATTRIBUTE18
, DRA.ATTRIBUTE19
, DRA.ATTRIBUTE20
, DRA.ATTRIBUTE21
, DRA.ATTRIBUTE22
, DRA.ATTRIBUTE23
, DRA.ATTRIBUTE24
, DRA.ATTRIBUTE25
, DRA.ATTRIBUTE26
, DRA.ATTRIBUTE27
, DRA.ATTRIBUTE28
, DRA.ATTRIBUTE29
, DRA.ATTRIBUTE30
FROM CS_INCIDENTS_B_SEC SR
, FND_LOOKUPS FNDL1
, FND_LOOKUPS FNDL2
, FND_LOOKUPS FNDL3
, CSD_REPAIR_TYPES_VL DRTVL
, CSI_ITEM_INSTANCES CP
, CSI_INSTANCE_STATUSES CPS
, MTL_SYSTEM_ITEMS_VL ITEMS
, MTL_UNITS_OF_MEASURE_VL UOM
, CSD_REPAIRS DRA
, OKC_K_LINES_B OKL
, OKC_K_HEADERS_B OKH
, QP_LIST_HEADERS_TL QP
, PJM_PROJECTS_V PPV
, PJM_TASKS_V PTV
, CSD_FLOW_STATUSES_B FS_B
, CSD_FLOW_STATUSES_TL FS_TL
, FND_LOOKUPS FS_LKUP
, FND_LOOKUPS P_LKUP
, FND_LOOKUPS FNDES
, FND_LOOKUPS FNDIW
, FND_LOOKUPS FNDWV
, FND_LOOKUPS FNDRWK
WHERE DRA.REPAIR_TYPE_ID = DRTVL.REPAIR_TYPE_ID
AND DRA.INCIDENT_ID = SR.INCIDENT_ID
AND DRA.CUSTOMER_PRODUCT_ID = CP.INSTANCE_ID(+)
AND CP.INSTANCE_STATUS_ID = CPS.INSTANCE_STATUS_ID(+)
AND DRA.APPROVAL_STATUS = FNDL1.LOOKUP_CODE (+)
AND FNDL1.LOOKUP_TYPE (+) = 'CSD_APPROVAL_STATUS'
AND DRA.STATUS = FNDL2.LOOKUP_CODE
AND FNDL2.LOOKUP_TYPE = 'CSD_REPAIR_STATUS'
AND DRA.STATUS_REASON_CODE = FNDL3.LOOKUP_CODE (+)
AND FNDL3.LOOKUP_TYPE (+) = 'CSD_REASON'
AND DRA.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID
AND ITEMS.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID
AND DRA.UNIT_OF_MEASURE = UOM.UOM_CODE
AND OKL.ID(+) = DRA.CONTRACT_LINE_ID
AND OKH.ID(+) = OKL.CHR_ID
AND QP.LANGUAGE(+)=USERENV('LANG')
AND DRA.PRICE_LIST_HEADER_ID = QP.LIST_HEADER_ID(+)
AND DRA.PROJECT_ID = PPV.PROJECT_ID(+)
AND DRA.TASK_ID = PTV.TASK_ID(+)
AND FS_B.FLOW_STATUS_ID = DRA.FLOW_STATUS_ID
AND FS_TL.FLOW_STATUS_ID = FS_B.FLOW_STATUS_ID
AND FS_TL.LANGUAGE = USERENV('LANG')
AND FS_LKUP.LOOKUP_TYPE = 'CSD_REPAIR_FLOW_STATUS'
AND FS_LKUP.LOOKUP_CODE = FS_B.FLOW_STATUS_CODE
AND DRA.RO_PRIORITY_CODE = P_LKUP.LOOKUP_CODE(+)
AND P_LKUP.LOOKUP_TYPE(+) = 'CSD_RO_PRIORITY'
AND DRA.ESCALATION_CODE = FNDES.LOOKUP_CODE (+)
AND FNDES.LOOKUP_TYPE (+) = 'CSD_ESCALATION_CODES'
AND DRA.IN_WARRANTY_CODE = FNDIW.LOOKUP_CODE (+)
AND FNDIW.LOOKUP_TYPE (+) = 'CSD_YES_NO_VALUE_SET'
AND DRA.WARRANTY_VIOLATION_CODE = FNDWV.LOOKUP_CODE (+)
AND FNDWV.LOOKUP_TYPE (+) = 'CSD_WARRANTY_VIOLATION'
AND DRA.REWORK_CODE = FNDRWK.LOOKUP_CODE (+)
AND FNDRWK.LOOKUP_TYPE (+) = 'CSD_REWORK'

Columns