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

TABLE: CSD.CSD_REPAIRS_INTERFACE

Object Details
Object Name: CSD_REPAIRS_INTERFACE
Object Type: TABLE
Owner: CSD
FND Design Data: TableCSD.CSD_REPAIRS_INTERFACE
Subobject Name:
Status: VALID


An interface table to create repair orders in bulk


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER

Transaction Id for the current transaction
GROUP_ID NUMBER
Yes Group id
SR_ACCOUNT_ID NUMBER
Yes Service Request Account ID
SR_PARTY_ID NUMBER
Yes Service Request Customer Id (party id)
SR_INCIDENT_ID NUMBER

Service Request ID
SR_INCIDENT_SUMMARY VARCHAR2 (80)
Service Request Summary
SR_BILL_TO_SITE_USE_ID NUMBER

Service Request Bill to Site
SR_SHIP_TO_SITE_USE_ID NUMBER

Service Request ship to site
SR_TYPE_ID NUMBER

Service Request type id.
SR_STATUS_ID NUMBER

Service Request Status ID
SR_SEVERITY_ID NUMBER

Service Request Severity ID
SR_URGENCY_ID NUMBER

Service Request Urgency Id
SR_OWNER_ID NUMBER

Service Request Owner Id
SR_RESOURCE_TYPE NUMBER

Service Request resource type
REPAIR_LINE_ID NUMBER

Repair Line id
REQUEST_ID NUMBER

Conc request id
PROGRAM_ID NUMBER

Conc program id
PROGRAM_APPLICATION_ID NUMBER

Program app id.
PROGRAM_UPDATE_DATE DATE

Program update date.
CREATED_BY NUMBER

WHO column
CREATION_DATE DATE

WHO column
LAST_UPDATED_BY NUMBER

WHO column
LAST_UPDATE_DATE DATE

WHO column
LAST_UPDATE_LOGIN NUMBER

WHO column
REPAIR_NUMBER VARCHAR2 (30)
Repair Number
INCIDENT_ID NUMBER

Incident Id
INVENTORY_ITEM_ID NUMBER
Yes Inventory item Id
CUSTOMER_PRODUCT_ID NUMBER

Instance id
UNIT_OF_MEASURE VARCHAR2 (3)
Unit of measure
REPAIR_TYPE_ID NUMBER

Repair type id
RESOURCE_ID NUMBER

Repair owner
INSTANCE_ID NUMBER

Instance id
PROJECT_ID NUMBER

Project id
TASK_ID NUMBER

Task id
CONTRACT_LINE_ID NUMBER

Service contract line id
QUANTITY NUMBER
Yes repair quantity
STATUS VARCHAR2 (30)
repair state
APPROVAL_REQUIRED_FLAG VARCHAR2 (1)
estimate approval required flag
DATE_CLOSED DATE

repair order closed date
QUANTITY_IN_WIP NUMBER

Quantity in WIP
APPROVAL_STATUS VARCHAR2 (30)
Estimate approval status
QUANTITY_RCVD NUMBER

Received quantity
QUANTITY_SHIPPED NUMBER

Shipped quantity
SERIAL_NUMBER VARCHAR2 (30)
Serial number
PROMISE_DATE DATE

RO Promise date
ATTRIBUTE_CATEGORY VARCHAR2 (30)
DFF Context
ATTRIBUTE1 VARCHAR2 (150)
DFF Segment
ATTRIBUTE2 VARCHAR2 (150)
DFF Segment
ATTRIBUTE3 VARCHAR2 (150)
DFF Segment
ATTRIBUTE4 VARCHAR2 (150)
DFF Segment
ATTRIBUTE5 VARCHAR2 (150)
DFF Segment
ATTRIBUTE6 VARCHAR2 (150)
DFF Segment
ATTRIBUTE7 VARCHAR2 (150)
DFF Segment
ATTRIBUTE8 VARCHAR2 (150)
DFF Segment
ATTRIBUTE9 VARCHAR2 (150)
DFF Segment
ATTRIBUTE10 VARCHAR2 (150)
DFF Segment
ATTRIBUTE11 VARCHAR2 (150)
DFF Segment
ATTRIBUTE12 VARCHAR2 (150)
DFF Segment
ATTRIBUTE13 VARCHAR2 (150)
DFF Segment
ATTRIBUTE14 VARCHAR2 (150)
DFF Segment
ATTRIBUTE15 VARCHAR2 (150)
DFF Segment
ATTRIBUTE16 VARCHAR2 (150)
DFF Segment
ATTRIBUTE17 VARCHAR2 (150)
DFF Segment
ATTRIBUTE18 VARCHAR2 (150)
DFF Segment
ATTRIBUTE19 VARCHAR2 (150)
DFF Segment
ATTRIBUTE20 VARCHAR2 (150)
DFF Segment
ATTRIBUTE21 VARCHAR2 (150)
DFF Segment
ATTRIBUTE22 VARCHAR2 (150)
DFF Segment
ATTRIBUTE23 VARCHAR2 (150)
DFF Segment
ATTRIBUTE24 VARCHAR2 (150)
DFF Segment
ATTRIBUTE25 VARCHAR2 (150)
DFF Segment
ATTRIBUTE26 VARCHAR2 (150)
DFF Segment
ATTRIBUTE27 VARCHAR2 (150)
DFF Segment
ATTRIBUTE28 VARCHAR2 (150)
DFF Segment
ATTRIBUTE29 VARCHAR2 (150)
DFF Segment
ATTRIBUTE30 VARCHAR2 (150)
DFF Segment
SECURITY_GROUP_ID NUMBER

Security group id
ORDER_LINE_ID NUMBER

OM order line id
ORIGINAL_SOURCE_REFERENCE VARCHAR2 (30)
Original source ref
STATUS_REASON_CODE VARCHAR2 (30)
Status reason code
OBJECT_VERSION_NUMBER NUMBER

Object version number
AUTO_PROCESS_RMA VARCHAR2 (1)
Auto process rma flag
REPAIR_MODE VARCHAR2 (30)
repair mode (task, wip or none)
ITEM_REVISION VARCHAR2 (3)
Item revision
RO_TXN_STATUS VARCHAR2 (30)
RO Ttransaction status
REPAIR_GROUP_ID NUMBER

Repair group
CURRENCY_CODE VARCHAR2 (15)
Currency Code
ORIGINAL_SOURCE_HEADER_ID NUMBER

Source header
ORIGINAL_SOURCE_LINE_ID NUMBER

Source line
PRICE_LIST_HEADER_ID NUMBER

Price list header Id
DEFAULT_PO_NUM VARCHAR2 (80)
Default PO number
SPLIT_FROM_REP_LINE_ID NUMBER

Split from repair line id
SPLIT_FLAG VARCHAR2 (1)
Split flag
SUPERCESSION_INV_ITEM_ID NUMBER

Supercession inv id.
OWNING_ORGANIZATION NUMBER

Owning organization
OWNING_ORGANIZATION_ID NUMBER

Owning organization id.
UNIT_NUMBER VARCHAR2 (30)
Unit number
PROBLEM_DESCRIPTION VARCHAR2 (240)
RO problem description
FLOW_STATUS_ID NUMBER

Flow status id
WF_ITEM_TYPE VARCHAR2 (8)
Workflow item type
WF_ITEM_KEY VARCHAR2 (240)
Workflow item key
INVENTORY_ORG_ID NUMBER

Inventory org id
RO_PRIORITY_CODE VARCHAR2 (30)
RO priority
RESOLVE_BY_DATE DATE

Resolve by date
ESCALATED_CODE VARCHAR2 (30)
escalation code
IN_WARRANTY_CODE VARCHAR2 (30)
In warranty flag
WARRANTY_VIOLATION_CODE VARCHAR2 (30)
Warranty violation
REWORK_CODE VARCHAR2 (30)
Rework code
BULLETIN_CHECK_DATE DATE

Bulletin check data
SUPERCESSION_QUANTITY NUMBER

Supercession quantity
ESCALATION_CODE VARCHAR2 (30)
escalation code
REPAIR_YIELD_QUANTITY NUMBER

repair yield
LOT_NUMBER VARCHAR2 (10)
lot number
EXTERNAL_REFERENCE VARCHAR2 (30)
external reference
PROCESSING_PHASE NUMBER

Processing phase
SERIAL_CONTROL_FLAG NUMBER

Item's serial control flag
REVISION_CONTROL_FLAG NUMBER

Items revision control flag
IB_CONTROL_FLAG VARCHAR2 (1)
Items IB trackable flag
Query Text

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


SELECT TRANSACTION_ID
,      GROUP_ID
,      SR_ACCOUNT_ID
,      SR_PARTY_ID
,      SR_INCIDENT_ID
,      SR_INCIDENT_SUMMARY
,      SR_BILL_TO_SITE_USE_ID
,      SR_SHIP_TO_SITE_USE_ID
,      SR_TYPE_ID
,      SR_STATUS_ID
,      SR_SEVERITY_ID
,      SR_URGENCY_ID
,      SR_OWNER_ID
,      SR_RESOURCE_TYPE
,      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
,      INVENTORY_ITEM_ID
,      CUSTOMER_PRODUCT_ID
,      UNIT_OF_MEASURE
,      REPAIR_TYPE_ID
,      RESOURCE_ID
,      INSTANCE_ID
,      PROJECT_ID
,      TASK_ID
,      CONTRACT_LINE_ID
,      QUANTITY
,      STATUS
,      APPROVAL_REQUIRED_FLAG
,      DATE_CLOSED
,      QUANTITY_IN_WIP
,      APPROVAL_STATUS
,      QUANTITY_RCVD
,      QUANTITY_SHIPPED
,      SERIAL_NUMBER
,      PROMISE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      SECURITY_GROUP_ID
,      ORDER_LINE_ID
,      ORIGINAL_SOURCE_REFERENCE
,      STATUS_REASON_CODE
,      OBJECT_VERSION_NUMBER
,      AUTO_PROCESS_RMA
,      REPAIR_MODE
,      ITEM_REVISION
,      RO_TXN_STATUS
,      REPAIR_GROUP_ID
,      CURRENCY_CODE
,      ORIGINAL_SOURCE_HEADER_ID
,      ORIGINAL_SOURCE_LINE_ID
,      PRICE_LIST_HEADER_ID
,      DEFAULT_PO_NUM
,      SPLIT_FROM_REP_LINE_ID
,      SPLIT_FLAG
,      SUPERCESSION_INV_ITEM_ID
,      OWNING_ORGANIZATION
,      OWNING_ORGANIZATION_ID
,      UNIT_NUMBER
,      PROBLEM_DESCRIPTION
,      FLOW_STATUS_ID
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      INVENTORY_ORG_ID
,      RO_PRIORITY_CODE
,      RESOLVE_BY_DATE
,      ESCALATED_CODE
,      IN_WARRANTY_CODE
,      WARRANTY_VIOLATION_CODE
,      REWORK_CODE
,      BULLETIN_CHECK_DATE
,      SUPERCESSION_QUANTITY
,      ESCALATION_CODE
,      REPAIR_YIELD_QUANTITY
,      LOT_NUMBER
,      EXTERNAL_REFERENCE
,      PROCESSING_PHASE
,      SERIAL_CONTROL_FLAG
,      REVISION_CONTROL_FLAG
,      IB_CONTROL_FLAG
FROM CSD.CSD_REPAIRS_INTERFACE;

Dependencies

[top of page]

CSD.CSD_REPAIRS_INTERFACE does not reference any database object

CSD.CSD_REPAIRS_INTERFACE is referenced by following:

SchemaCSD
ViewCSD_REPAIRS_INTERFACE#