Oracle Depot Repair Lookup Codes

This appendix presents the seeded Oracle Depot Repair lookup codes and values.

This appendix covers the following topics:

Depot Repair Types (CSD_REPAIR_TYPES)

The following lookup values are seeded for the Repair Type Refs in Oracle Depot Repair.

Code Description Editable?
AE Advanced Exchange No
AL Loaner No
ARR Loaner, Repair and Return No
E Exchange No
R Replacement No
RF Refurbishment No
RR Repair and Return No
SR Standard Repair No

Repair Type Reason (CSD_REASON)

Repair Type Reasons are values seeded for the different reasons that affect the return of an item for repair.

Code Description Editable?
APPRV Customer approves the RMA No
EST Estimate approved No
HOLD Repair on hold No
REJECT_1 Product unrepairable No
REJECT_2 Declined repair No
REV_EST Revised estimate approved No
WAIT_1 Customer contacted No
WAIT_2 Awaiting approval No

Repair Mode for the Depot Repair Processes (CSD_REPAIR_MODE)

The following seeded lookup values are used to define the repair mode used to process a repair using Oracle Depot Repair.

Code Description Editable?
ALL Display all the values for repair modes No
NONE None of the modes are applicable No
TASK JTF Tasks No
WIP Discrete Jobs in Work in Process module No

Repair Approval Status (CSD_APPROVAL_STATUS)

Repair Approval Status lookup values are defined (seeded) to represent the acceptance or rejection of an item's repair.

Code Meaning Editable?
A Approved No
P Pending No
R Rejected No

Repair Status (CSD_REPAIR_STATUS)

The Repair Status lookup values define whether a Repair Order is open, closed, or on hold. The following values are seeded.

Code Meaning Editable?
C Closed No
D Draft (used in Mass RO) No
H Hold No
O Open No

Repair Event (CSD_EVENT)

Repair Event lookups are defined to represent particular events that take place in a depot during repair processing. The following values are seeded.

Code Meaning Editable?
A Customer Approved No
CM Charges Manually Updated for Repair Order No
CONU Default Contract Updated No
CR Charges Recorded No
DIA Diagnosed No
DROC Depot Repair Owner Changed No
ESU Estimate Status Updated No
IP Inspection Performed No
JC Job Completed No
JCA Job Completed Alert No
JCN Job Canceled No
JS Job Created No
JSA Job Submitted No
JSU Job Submitted Alert No
OA Repair Order Alert No
PDC Promise Date Changed No
PS Shipment No
PSI Sales Order Completed No
R Customer Rejected No
RC Repair Order Opened No
RE RMA Created No
RO Replace Order Created No
RR RMA Received No
RRI Requisition Received No
RSC Receipt Serial Number is different No
RSCI Sales Order Alert No
SC Status Changed No
SLT Repair Order Split No
SOC Sales Order Created No
SRU Service Request Status Updated No
SSC Shipped Serial Number is different No
TAC Task Assignee Changed No
TBR Ready to be Returned No
TC Task Created No
TOC Task Updated No
TSC Task Status Change No

Estimate Billing Type (CSD_EST_BILLING_TYPE)

Estimate Billing Type lookup values are defined to represent the type of transaction being billed. Following are the seeded values.

Code Description Editable?
E Expense No
L Labor No
M Material No

Estimate Status (CSD_ESTIMATE_STATUS)

Estimate statuses are values defined for the different states of an estimate. Following are the seeded Estimate Status values.

Code Description Editable?
ACCEPTED Estimate approved by customer No
BID Estimate awaiting customer approval No
CANCELLED Estimate is cancelled No
DRAFT Estimate with information but not ready to reveal to customer No
NEW Estimate with no information entered No
REJECTED Estimate not approved by customer No

Estimate Reject Reasons (CSD_REJECT_REASON)

The following lookup values are seeded to specify the reason for an estimate rejection.

Code Description Editable?
CUST_REJECT Customer Rejects Estimate No
MAC_SHORTAGE Machine Not Available in Depot No
MAT_SHORTAGE Material Shortage in Depot No
NOT_PROFITABLE Unprofitable for depot to repair the item No
NOT_REPAIRABLE Product Beyond Repair in Depot No
RES_SHORTAGE Resource Shortage in Depot No

Product Transaction Action Codes (CSD_PRODUCT_ACTION_CODE)

The following are the Product Transaction Action codes seeded for Depot Repair.

Code Description Editable?
CUST_PROD Customer Item No
DEFECTIVES Defective Item No
EXCHANGE Item Exchange No
LOANER Loaned Item No
REPLACEMENT Replacement Item No
USABLES Usable Item No

Product Transaction Action Type (CSD_PROD_ACTION_TYPE)

The following Product Transaction Action Type lookup values are seeded in Oracle Depot Repair.

Code Description Editable?
MOVE_IN Move in defective products No
MOVE_OUT Move out usable products No
RMA Inbound transaction for returned product No
SHIP Outbound transaction for Repaired Product, Loaner etc. No

Product Transaction Status (CSD_PRODUCT_TXN_STATUS)

Product Transaction Statuses are lookup values defined for representing the state of product transactions. The following values are seeded.

Code Description Editable?
BOOKED Sales Order Booked No
ENTERED Created Product Txn No
RECEIVED Received against RMA No
RELEASED Sales Order Pick Released No
SHIPPED Sales Order Shipped No
SUBMITTED Charge Line Interfaced No

Repair Order Transaction Status (CSD_RO_TXN_STATUS)

Repair Order Statuses are lookup values that define the different stages in Repair Order processing. The following Repair Order Transaction Status values are seeded in Oracle Depot Repair.

Code Description Editable?
CHARGE_ENTERED Charge Entered No
ESTIMATE_APPROVED Estimate Approved No
ESTIMATE_REJECTED Estimate Rejected No
NEW New No
OM_BOOKED OM Booked No
OM_RECEIVED OM Received No
OM_RELEASED OM Released No
OM_SHIPPED OM Shipped No
OM_SUBMITTED OM Submitted No
WIP_COMPLETED WIP Job Complete No
WIP_SUBMITTED WIP Job Submitted No

Units of Measure (CSD_UNIT_OF_MEASURE)

The following are the seeded values for Unit of Measure for the estimated repair lead time.

Code Description Editable?
DAY Day No
HR Hour No
MONTH Month No
WEEK Week No
YEAR Year No

Repair Job Statuses (CSD_WIP_JOB_STATUS)

The following lookup values are seeded for Repair Job Statuses in Oracle Depot Repair.

Code Description Editable?
RELEASED Released No
UNRELEASED UnReleased No

Recall Flow Statuses (CSD_RECALL_FLOW_STATUS)

The following lookup values are seeded for Recall Flow Statuses in Oracle Depot Repair.

Code Description Editable?
CLOSED CLOSED Yes
DRAFT DRAFT Yes
OPEN OPEN Yes

Material Dispositions (CSD_MATERIAL_DISPOSITIONS)

The following lookup values are seeded for Material Dispositions in Oracle Depot Repair.

Code Description Editable?
HAZMAT Hazardous Materials No
RECOVER Recover No
RECYCLE Recycle No
REUSE Re-use No
SCRAP Scrap No

Return Streams (CSD_RETURN_STREAMS)

The following lookup values are seeded for Return Streams in Oracle Depot Repair.

Code Description Editable?
CUST_CREDIT Customer Return For Credit Yes
TRADEIN Trade In Yes
TAKEBACK Takeback Yes
INT_CREDIT Internal User Return For Credit Yes
TOOMUCH Excess and Obsolete Yes
RET_ASSETS Retired Assests Yes
RET_SPARES Retired Spares Yes
EWASTE e-Waste Yes