eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.CSD_REPAIRS_NON_SEC_V

Object Details

Object Name:	CSD_REPAIRS_NON_SEC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSD.CSD_REPAIRS_NON_SEC_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.
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.
RO_PRIORITY_CODE	VARCHAR2	(30)		Repair Order Priority Code
RO_PRIORITY_MEANING	VARCHAR2	(80)		Repair Order Priority Meaning
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 integraion
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
,      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
,      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_NON_SEC_V;

Dependencies

[top of page]

APPS.CSD_REPAIRS_NON_SEC_V references the following:

APPS: CSD_REPAIRS; CSD_REPAIR_TYPES_VL; CSI_INSTANCE_STATUSES; CSI_ITEM_INSTANCES; CS_INCIDENTS_ALL_B; CS_STD - show dependent code; FND_GLOBAL - show dependent code; FND_LOOKUPS; FND_PROFILE - show dependent code; MTL_SYSTEM_ITEMS_VL; MTL_UNITS_OF_MEASURE_VL; OKC_K_HEADERS_B; OKC_K_LINES_B; PA_CROSS_BUSINESS_GRP - show dependent code; PA_PROJECT_UTILS - show dependent code; PA_SECURITY - show dependent code; PA_TASK_UTILS - show dependent code; PJM_PROJECTS_V; PJM_TASKS_V; QP_LIST_HEADERS_TL

APPS.CSD_REPAIRS_NON_SEC_V is not referenced by any database object