VIEW: APPS.CSD_REPAIR_ORDER_GROUPS_V

Source

View Text - Preformatted

SELECT crog.rowid , crog.repair_group_id , crog.incident_id , sr.org_id , sr.incident_number , sr.customer_id , items.concatenated_segments product, items.description product_desc, crog.repair_group_number , crog.repair_type_id , crtv.name repair_type , crog.inventory_item_id, crog.unit_of_measure , uom.unit_of_measure_tl, crog.group_quantity , crog.repair_order_quantity, crog.rma_quantity , crog.received_quantity, crog.approved_quantity, crog.submitted_quantity, crog.completed_quantity, crog.released_quantity , crog.shipped_quantity , crog.created_by , crog.creation_date , crog.last_updated_by , crog.last_update_date , crog.last_update_login , crog.context , crog.attribute1 , crog.attribute2 , crog.attribute3 , crog.attribute4 , crog.attribute5 , crog.attribute6 , crog.attribute7 , crog.attribute8 , crog.attribute9 , crog.attribute10 , crog.attribute11 , crog.attribute12 , crog.attribute13 , crog.attribute14 , crog.attribute15 , crog.security_group_id , crog.object_version_number, crog.wip_entity_id , crog.group_txn_status, crtv.repair_type_ref, csd_process_util.get_group_rejected_quantity(crog.repair_group_id) rejected_quantity, crog.group_approval_status, crog.repair_mode from csd_repair_order_groups crog, cs_incidents_all_b sr, csd_repair_types_vl crtv, mtl_system_items_vl items, mtl_units_of_measure_vl uom WHERE crog.incident_id = sr.incident_id and crog.repair_type_id = crtv.repair_type_id and crog.inventory_item_id = items.inventory_item_id and items.organization_id = cs_std.get_item_valdn_orgzn_id and crog.unit_of_measure = uom.uom_code

View Text - HTML Formatted

SELECT CROG.ROWID
, CROG.REPAIR_GROUP_ID
, CROG.INCIDENT_ID
, SR.ORG_ID
, SR.INCIDENT_NUMBER
, SR.CUSTOMER_ID
, ITEMS.CONCATENATED_SEGMENTS PRODUCT
, ITEMS.DESCRIPTION PRODUCT_DESC
, CROG.REPAIR_GROUP_NUMBER
, CROG.REPAIR_TYPE_ID
, CRTV.NAME REPAIR_TYPE
, CROG.INVENTORY_ITEM_ID
, CROG.UNIT_OF_MEASURE
, UOM.UNIT_OF_MEASURE_TL
, CROG.GROUP_QUANTITY
, CROG.REPAIR_ORDER_QUANTITY
, CROG.RMA_QUANTITY
, CROG.RECEIVED_QUANTITY
, CROG.APPROVED_QUANTITY
, CROG.SUBMITTED_QUANTITY
, CROG.COMPLETED_QUANTITY
, CROG.RELEASED_QUANTITY
, CROG.SHIPPED_QUANTITY
, CROG.CREATED_BY
, CROG.CREATION_DATE
, CROG.LAST_UPDATED_BY
, CROG.LAST_UPDATE_DATE
, CROG.LAST_UPDATE_LOGIN
, CROG.CONTEXT
, CROG.ATTRIBUTE1
, CROG.ATTRIBUTE2
, CROG.ATTRIBUTE3
, CROG.ATTRIBUTE4
, CROG.ATTRIBUTE5
, CROG.ATTRIBUTE6
, CROG.ATTRIBUTE7
, CROG.ATTRIBUTE8
, CROG.ATTRIBUTE9
, CROG.ATTRIBUTE10
, CROG.ATTRIBUTE11
, CROG.ATTRIBUTE12
, CROG.ATTRIBUTE13
, CROG.ATTRIBUTE14
, CROG.ATTRIBUTE15
, CROG.SECURITY_GROUP_ID
, CROG.OBJECT_VERSION_NUMBER
, CROG.WIP_ENTITY_ID
, CROG.GROUP_TXN_STATUS
, CRTV.REPAIR_TYPE_REF
, CSD_PROCESS_UTIL.GET_GROUP_REJECTED_QUANTITY(CROG.REPAIR_GROUP_ID) REJECTED_QUANTITY
, CROG.GROUP_APPROVAL_STATUS
, CROG.REPAIR_MODE
FROM CSD_REPAIR_ORDER_GROUPS CROG
, CS_INCIDENTS_ALL_B SR
, CSD_REPAIR_TYPES_VL CRTV
, MTL_SYSTEM_ITEMS_VL ITEMS
, MTL_UNITS_OF_MEASURE_VL UOM
WHERE CROG.INCIDENT_ID = SR.INCIDENT_ID
AND CROG.REPAIR_TYPE_ID = CRTV.REPAIR_TYPE_ID
AND CROG.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID
AND ITEMS.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID
AND CROG.UNIT_OF_MEASURE = UOM.UOM_CODE