Product: | CSD - Depot Repair |
---|---|
Description: | Views that fetches all the repair order groups for service request. |
Implementation/DBA Data: | APPS.CSD_REPAIR_ORDER_GROUPS_V |
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