View: CSD_RO_GROUP_DETAILS_V

Product:	CSD - Depot Repair
Description:	Views that defines all the repair order details for a group.
Implementation/DBA Data:	APPS.CSD_RO_GROUP_DETAILS_V

View Text

SELECT DRA.ROWID
, DRA.REPAIR_LINE_ID
, DRA.REPAIR_NUMBER
, CROG.REPAIR_GROUP_ID
, DRA.CREATED_BY
, DRA.CREATION_DATE
, DRA.LAST_UPDATED_BY
, DRA.LAST_UPDATE_DATE
, DRA.LAST_UPDATE_LOGIN
, DRA.INCIDENT_ID
, DRA.INVENTORY_ITEM_ID
, ITEMS.CONCATENATED_SEGMENTS PRODUCT
, ITEMS.DESCRIPTION PRODUCT_DESC
, DRA.UNIT_OF_MEASURE
, UOM.UNIT_OF_MEASURE_TL
, DRA.QUANTITY
, DRA.RESOURCE_ID
, DRA.REPAIR_TYPE_ID
, CRTV.NAME REPAIR_TYPE
, CRTV.REPAIR_TYPE_REF
, DRA.INSTANCE_ID
, DRA.APPROVAL_REQUIRED_FLAG
, DRA.APPROVAL_STATUS
, FNDL1.MEANING APPROVAL_STATUS_MEANING
, DRA.STATUS
, FNDL2.MEANING STATUS_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 REASON_CODE_MEANING
, DRA.OBJECT_VERSION_NUMBER
, (TRUNC(DRA.PROMISE_DATE) - TRUNC(SYSDATE)) DAYS_REMAINING
FROM CSD_REPAIR_ORDER_GROUPS CROG
, CSD_REPAIRS DRA
, FND_LOOKUPS FNDL1
, FND_LOOKUPS FNDL2
, FND_LOOKUPS FNDL3
, CSD_REPAIR_TYPES_VL CRTV
, MTL_SYSTEM_ITEMS_VL ITEMS
, MTL_UNITS_OF_MEASURE_VL UOM
WHERE CROG.REPAIR_GROUP_ID= DRA.REPAIR_GROUP_ID
AND CROG.REPAIR_TYPE_ID = CRTV.REPAIR_TYPE_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

Columns