DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CSD_REPAIRS_V

Object Details
Object Name: CSD_REPAIRS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSD.CSD_REPAIRS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


The view for getting repair orders.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROWID from CSD_REPAIRS
SR_ORG_ID NUMBER

Service Request Org identifier.
REPAIR_LINE_ID NUMBER (15) Yes Unique repair order identifier
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REPAIR_NUMBER VARCHAR2 (30) Yes Unique number for the repair order
INCIDENT_ID NUMBER (15) Yes Service request identifier
INCIDENT_NUMBER VARCHAR2 (64) Yes Service request number
CUSTOMER_ID NUMBER (15)
Customer identifier
INVENTORY_ITEM_ID NUMBER (15) Yes Inventory item identifier
ITEM VARCHAR2 (40)
Inventory item name
ITEM_DESC VARCHAR2 (240)
Inventory item description
UNIT_OF_MEASURE VARCHAR2 (3) Yes Unit of Measure for the quantity field
UNIT_OF_MEASURE_TL VARCHAR2 (25) Yes Unit of Measure translation
QUANTITY NUMBER (15) Yes Ordered quantity
QUANTITY_IN_WIP NUMBER

Total quantity in the WIP for the repair order
QUANTITY_RCVD NUMBER

Total quantity received for the repair order
QUANTITY_SHIPPED NUMBER

Total quantity shipped for the repair order
PROJECT_ID NUMBER (15)
Project identifier
PROJECT_NUMBER VARCHAR2 (25)
Project Number
TASK_ID NUMBER (15)
Task identifier
TASK_NUMBER VARCHAR2 (25)
Task Number
UNIT_NUMBER VARCHAR2 (30)
Unit Number
CONTRACT_LINE_ID NUMBER

Service line identifier
CONTRACT_NUMBER VARCHAR2 (120)
Service contract number for the repair order.
CONTRACT_ID NUMBER

Service contract header id for the repair order.
CUSTOMER_PRODUCT_ID NUMBER (15)
Customer product identifier
REFERENCE_NUMBER VARCHAR2 (30)
Customer product reference number
LOT_NUMBER VARCHAR2 (80)
Customer product lot number
CP_STATUS VARCHAR2 (50)
Customer product status
ITEM_REVISION VARCHAR2 (3)
Customer product revision
SYSTEM_ID NUMBER

InstallBase System Identification
INSTALL_SITE_USE_ID NUMBER

Installed Site Identification for the Customer Product
SERIAL_NUMBER VARCHAR2 (30)
Serial number of the product
RESOURCE_ID NUMBER (15)
Repair owner identifier
RESOURCE_NAME VARCHAR2 (0)
Repair owner name
JOB_TITLE VARCHAR2 (0)
Repair owner job title
REPAIR_TYPE_ID NUMBER (15)
Repair type identifier
REPAIR_TYPE_NAME VARCHAR2 (80) Yes Repair type name
REPAIR_TYPE_REF VARCHAR2 (30)
Reference Repair Type
INTERNAL_ORDER_FLAG VARCHAR2 (1)
To identify if the repair type is internal or not.
INSTANCE_ID NUMBER (15)
Workflow instance identifier
APPROVAL_REQUIRED_FLAG VARCHAR2 (1) Yes Flag indicating that customer approval is required for the repair. Valid values are 'Y' and 'N'.
APPROVAL_STATUS VARCHAR2 (30)
Customer approval status code
APPROVAL_STATUS_MEANING VARCHAR2 (80)
Customer approval status meaning
STATUS VARCHAR2 (30) Yes Repair order status code
STATUS_MEANING VARCHAR2 (80) Yes Repair order status meaning
DATE_CLOSED DATE

Repair order closed date
PROMISE_DATE DATE

Promise date of delivery of the repaired broken product
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
STATUS_REASON_CODE VARCHAR2 (30)
Reason for the status. Valid values are from the FND lookup CSD_REASON
STATUS_REASON_MEANING VARCHAR2 (80)
Meaning for the status reason code from the FND lookup CSD_REASON
STATUS_REASON_DESCRIPTION VARCHAR2 (240)
Description for the status reason code from the FND lookup CSD_REASON
AUTO_PROCESS_RMA VARCHAR2 (1)
Auto Process RMA Flag
REPAIR_MODE VARCHAR2 (30)
Repair Mode
OBJECT_VERSION_NUMBER NUMBER
Yes Sequential number used for database locking control
CURRENCY_CODE VARCHAR2 (15)
Repair order currency code.
DEFAULT_PO_NUM VARCHAR2 (80)
Default PO Number
ORIGINAL_SOURCE_HEADER_ID NUMBER

Header Id of the Source of the repair order creation.
ORIGINAL_SOURCE_LINE_ID NUMBER

Line Id of the Source of the repair order creation.
SPLIT_FROM_REP_LINE_ID NUMBER

This column is to store the original repair line id.
SPLIT_FLAG VARCHAR2 (1)
To identify if the repair order was split or not.
PRICE_LIST_HEADER_ID NUMBER

The price list header id for the Repair order.
PRICE_LIST VARCHAR2 (240)
The price list name for the Repair order.
SUPERCESSION_INV_ITEM_ID NUMBER

Inventory item id for upgraded product.
BUSINESS_PROCESS_ID NUMBER (15)
Business Process associated to the Repair Type of the Repair Order.
FLOW_STATUS_ID NUMBER

Flow status identifier.
FLOW_STATUS_CODE VARCHAR2 (30) Yes Flow Status code.
FLOW_STATUS VARCHAR2 (80) Yes Flow Status meaning.
WF_ITEM_TYPE VARCHAR2 (8)
Workflow Item Type.
WF_ITEM_KEY VARCHAR2 (240)
Workflow Item Key.
OWNING_ORGANIZATION_ID NUMBER

Repair order Owning oraganization id
INVENTORY_ORG_ID NUMBER

Inventory Organization Id
PROBLEM_DESCRIPTION VARCHAR2 (240)
Problem Description
RO_PRIORITY_CODE VARCHAR2 (30)
Repair Order Priority Code
RO_PRIORITY_MEANING VARCHAR2 (80)
Repair order priority.
RESOLVE_BY_DATE DATE

Resolve By Date.
ESCALATION_CODE VARCHAR2 (30)
Escalated code
ESCALATION_MEANING VARCHAR2 (80)
Escalated meaning
ESCALATION_DESCRIPTION VARCHAR2 (240)
Escalated description
RO_WARRANTY_STATUS_CODE VARCHAR2 (30)
Repair Order Warranty Status
RO_WARRANTY_STATUS_MEANING VARCHAR2 (80)
Repair Order Warranty Status Meaning
IN_WARRANTY_CODE VARCHAR2 (30)
In-warranty code
IN_WARRANTY_MEANING VARCHAR2 (80)
In-warranty meaning
IN_WARRANTY_DESCRIPTION VARCHAR2 (240)
In-warranty description
WARRANTY_VIOLATION_CODE VARCHAR2 (30)
Warranty violation code
WARRANTY_VIOLATION_MEANING VARCHAR2 (80)
Warranty violation meaning
WARRANTY_VIOLATION_DESCRIPTION VARCHAR2 (240)
Warranty violation description
REWORK_CODE VARCHAR2 (30)
Rework code
REWORK_MEANING VARCHAR2 (80)
Rework meaning
REWORK_DESCRIPTION VARCHAR2 (240)
Rework description
BULLETIN_CHECK_DATE DATE

Bulletin check date
REPAIR_YIELD_QUANTITY NUMBER (15)
Super-cession quantity for APS integration
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE21 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE22 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE23 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE24 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE25 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE26 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE27 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE28 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE29 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE30 VARCHAR2 (150)
Descriptive flexfield segment
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      SR_ORG_ID
,      REPAIR_LINE_ID
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REPAIR_NUMBER
,      INCIDENT_ID
,      INCIDENT_NUMBER
,      CUSTOMER_ID
,      INVENTORY_ITEM_ID
,      ITEM
,      ITEM_DESC
,      UNIT_OF_MEASURE
,      UNIT_OF_MEASURE_TL
,      QUANTITY
,      QUANTITY_IN_WIP
,      QUANTITY_RCVD
,      QUANTITY_SHIPPED
,      PROJECT_ID
,      PROJECT_NUMBER
,      TASK_ID
,      TASK_NUMBER
,      UNIT_NUMBER
,      CONTRACT_LINE_ID
,      CONTRACT_NUMBER
,      CONTRACT_ID
,      CUSTOMER_PRODUCT_ID
,      REFERENCE_NUMBER
,      LOT_NUMBER
,      CP_STATUS
,      ITEM_REVISION
,      SYSTEM_ID
,      INSTALL_SITE_USE_ID
,      SERIAL_NUMBER
,      RESOURCE_ID
,      RESOURCE_NAME
,      JOB_TITLE
,      REPAIR_TYPE_ID
,      REPAIR_TYPE_NAME
,      REPAIR_TYPE_REF
,      INTERNAL_ORDER_FLAG
,      INSTANCE_ID
,      APPROVAL_REQUIRED_FLAG
,      APPROVAL_STATUS
,      APPROVAL_STATUS_MEANING
,      STATUS
,      STATUS_MEANING
,      DATE_CLOSED
,      PROMISE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      STATUS_REASON_CODE
,      STATUS_REASON_MEANING
,      STATUS_REASON_DESCRIPTION
,      AUTO_PROCESS_RMA
,      REPAIR_MODE
,      OBJECT_VERSION_NUMBER
,      CURRENCY_CODE
,      DEFAULT_PO_NUM
,      ORIGINAL_SOURCE_HEADER_ID
,      ORIGINAL_SOURCE_LINE_ID
,      SPLIT_FROM_REP_LINE_ID
,      SPLIT_FLAG
,      PRICE_LIST_HEADER_ID
,      PRICE_LIST
,      SUPERCESSION_INV_ITEM_ID
,      BUSINESS_PROCESS_ID
,      FLOW_STATUS_ID
,      FLOW_STATUS_CODE
,      FLOW_STATUS
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      OWNING_ORGANIZATION_ID
,      INVENTORY_ORG_ID
,      PROBLEM_DESCRIPTION
,      RO_PRIORITY_CODE
,      RO_PRIORITY_MEANING
,      RESOLVE_BY_DATE
,      ESCALATION_CODE
,      ESCALATION_MEANING
,      ESCALATION_DESCRIPTION
,      RO_WARRANTY_STATUS_CODE
,      RO_WARRANTY_STATUS_MEANING
,      IN_WARRANTY_CODE
,      IN_WARRANTY_MEANING
,      IN_WARRANTY_DESCRIPTION
,      WARRANTY_VIOLATION_CODE
,      WARRANTY_VIOLATION_MEANING
,      WARRANTY_VIOLATION_DESCRIPTION
,      REWORK_CODE
,      REWORK_MEANING
,      REWORK_DESCRIPTION
,      BULLETIN_CHECK_DATE
,      REPAIR_YIELD_QUANTITY
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
FROM APPS.CSD_REPAIRS_V;

Dependencies

[top of page]

APPS.CSD_REPAIRS_V references the following:

SchemaAPPS
SynonymCSD_FLOW_STATUSES_B
SynonymCSD_FLOW_STATUSES_TL
SynonymCSD_REPAIRS
ViewCSD_REPAIR_TYPES_VL
SynonymCSI_INSTANCE_STATUSES
SynonymCSI_ITEM_INSTANCES
ViewCS_INCIDENTS_B_SEC
PL/SQL PackageCS_STD - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
PL/SQL PackageFND_PROFILE - show dependent code
ViewMTL_SYSTEM_ITEMS_VL
ViewMTL_UNITS_OF_MEASURE_VL
SynonymOKC_K_HEADERS_B
SynonymOKC_K_LINES_B
PL/SQL PackagePA_CROSS_BUSINESS_GRP - show dependent code
PL/SQL PackagePA_PROJECT_UTILS - show dependent code
PL/SQL PackagePA_SECURITY - show dependent code
PL/SQL PackagePA_TASK_UTILS - show dependent code
ViewPJM_PROJECTS_V
ViewPJM_TASKS_V
SynonymQP_LIST_HEADERS_TL
APPS.CSD_REPAIRS_V is referenced by following:

SchemaAPPS
Package BodyCSD_GEN_ERRMSGS_PVT - show dependent code
Package BodyCSD_ISUP_DEPOT_WF_PVT - show dependent code
Package BodyCSD_PROCESS_UTIL - show dependent code
ViewCSD_RO_SERVICE_CODES_V
ViewCSD_RO_V
Package BodyCSD_SPLIT_PKG - show dependent code
Package BodyCSD_WF_PROCESS_PVT - show dependent code
Package BodyCSD_WIP_JOB_PVT - show dependent code