[Home] [Help] [Dependency Information]
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 |
A public view which may be useful for custom reporting or other data
requirements.
The view for getting repair orders.
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 |
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;
APPS.CSD_REPAIRS_NON_SEC_V is not referenced by any database object
|
|
|