VIEW: APPS.CSD_RO_GROUP_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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