CSD Views (85)

CSD - Depot Repair — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`CSD_ACTUALS_FROM_WIP_V`	View to fetch all WIP jobs for Repair Order that are not shared and have the following statuses - Complete, Complete - No Charge and Closed.
`CSD_BOM_INQUIRY_EXPL_V`	View based on temporary table.
`CSD_BULLETINS_V`	View to fetch all Service Bulletins
`CSD_BULLETINS_VL`	View to join CSD_BULLETINS_B and CSD_BULLETINS_TL
`CSD_CONTACT_DETAILS_V`
`CSD_CP_REFERENCE_V`	The view for getting all the valid customer products.
`CSD_CUSTOMER_DETAILS_V`
`CSD_CUSTOMER_SEARCH_V`
`CSD_DC_DOMAINS_V`	View that displays the mapping between Diagnostic Codes and Product Categories.
`CSD_DC_FREQUENCY_V`	View used for the FREQUENCY column for Diagnostic Code in the Evaluation page.
`CSD_DIAGNOSTIC_CODES_VL`	View that displays Diagnostic Codes information.
`CSD_ESTIMATE_DETAILS_EXT_V`
`CSD_FLOW_STATUS_RULES_V`
`CSD_FLWSTS_MILESTONES_V`
`CSD_FLWSTS_TRAN_RESPS_V`
`CSD_GROUP_JOB_PARAM_TEMP_V`	The view that is based on CSD_GROUP_JOB_PARAM_TEMP.
`CSD_HZ_REL_V`	View for details of Related, Subject, Object party. Used in the Depot Repair Workbench.
`CSD_INCIDENTS_NON_SEC_V`	The view for getting service request information.
`CSD_INCIDENTS_V`	The view for getting service request information.
`CSD_IR_REPAIR_JOBS_V`	The view used in Submit Repair Jobs if the Allow create WIP Job w/o RMA is set
`CSD_JOB_HEADER_V`	This view gets the header information for the job to be submitted. This view is used by the header block of the submit Repair Job screen. Th
`CSD_KB_LINKS_V`	Views that gets all the solutions from Knowledge Base.
`CSD_LOGISTICS_LINE_STATUS_V`	View for logistics line on status details tab
`CSD_MASS_RO_SN_V`
`CSD_MOST_COMM_MTL_USED_V`	View used in the Most Common Material Used bin.
`CSD_MOST_COMM_RES_USED_V`	View used in the Most Common Resource Transacted bin.
`CSD_OE_LINE_STATUS_V`	View for order management line status on status details tab
`CSD_PARAMETERS_VL`
`CSD_PARTY_SITES_V`
`CSD_POST_RO_GROUP_V`	View based on which post repair logistics are performed.
`CSD_PRE_RO_GROUP_V`	View based on which pre repair logistics are performed.
`CSD_PRODUCT_TXNS_IRO_V`
`CSD_PRODUCT_TXNS_V`	This View is used for the Receive/Ship tab in the Repair Orders Workbench. This will show all the Charge Lines and related information creat
`CSD_PROJECT_DETAILS_V`
`CSD_RCV_LINE_STATUS_V`	View for receiving line status on status details tab
`CSD_REPAIRS_NON_SEC_V`	The view for getting repair orders. It is without Service Security.
`CSD_REPAIRS_V`	The view for getting repair orders.
`CSD_REPAIR_ACTUALS_V`
`CSD_REPAIR_ACTUAL_LINES_V`
`CSD_REPAIR_ACTUAL_V`
`CSD_REPAIR_ESTIMATE_LINES_V`	Fetches all the estimate lines for repair orders.
`CSD_REPAIR_ESTIMATE_V`	Fetches the estimate header for repair orders.
`CSD_REPAIR_FLOW_STATUSES_V`
`CSD_REPAIR_HISTORY_V`	The view for getting repair order history.
`CSD_REPAIR_JOBS_V`	The view for getting repair orders with service request information.
`CSD_REPAIR_JOB_XREF_V`	The view for getting repair order jobs.
`CSD_REPAIR_KB_SOLUTIONS_V`	Views that gets all the solutions from Knowledge Base based on reapair orders.
`CSD_REPAIR_ORDER_GROUPS_V`	Views that fetches all the repair order groups for service request.
`CSD_REPAIR_TASKS_V`	This view is used for the repair tasks tab of the Depot Repair workbench. This shows all the task related information for tasks created wit
`CSD_REPAIR_TYPES_SAR_VL`
`CSD_REPAIR_TYPES_VL`	This is the VL view of the Repair Types.
`CSD_REPAIR_TYPE_RULES_V`
`CSD_RETURN_RULES_VL`
`CSD_RETURN_TYPES_VL`
`CSD_RET_RULE_CONDITIONS_VL`
`CSD_RO_APPLICABLE_SC_V`	This view gets all the repair orders having applicable service codes, along with the applicable service codes.
`CSD_RO_DIAGNOSTIC_CODES_V`	Displays Diagnostic Codes associated to Repair Orders.
`CSD_RO_GROUP_DETAILS_V`	Views that defines all the repair order details for a group.
`CSD_RO_GROUP_ESTIMATE_V`	View to summarize all the estimates for a given repair order line by MLE categories.
`CSD_RO_GROUP_JOBS_V`	View that fetches the details of the WIP job that is submitted for the repair order group.
`CSD_RO_GROUP_MATERIALS_V`	View to summarize all the charges for a given repair ordergroup by MLE categories.
`CSD_RO_RMA_SLS_INT_ORDS_V`	This view gets RMA, sales order, internal order and internal requistion for repair orders.
`CSD_RO_SERVICE_CODES_V`	Displays Service Codes associated to Repair Orders.
`CSD_RO_SOLNS_V`	Displays solutions that are linked to repair orders.
`CSD_RO_SOLN_SC_ROUTE_V`
`CSD_RO_SOLN_SC_V`
`CSD_RO_SOLN_V`
`CSD_RO_SUMMARY_V`	Repair Order Summary View
`CSD_RO_V`
`CSD_RT_TRAN_RESPS_V`
`CSD_RULES_V`	View that displays all rules
`CSD_RULES_VL`	View that joins CSD_RULES_B with TL table
`CSD_RULE_CONDITIONS_V`	View that displays all rule conditions
`CSD_RULE_CONDITIONS_VL`	View that Joins CSD_RULE_CONDITIONS_B with TL table
`CSD_SC_BOM_AND_ROUTE_V`	View that displays the mapping between Service Codes and BOM and Routings.
`CSD_SC_DOMAINS_V`	View that displays the mapping between Service Codes and Product Categories.
`CSD_SC_FREQUENCY_V`	View used for the FREQUENCY column for Service Code in the Evaluation page.
`CSD_SC_RECOMMENDATIONS_VL`
`CSD_SC_TASK_TEMP_GROUP_V`	View that displays the mapping between Service Codes and Task Template Groups.
`CSD_SERIAL_NUMBERS_V`	View that displays all possible serial numbers, from IB, service request, and mtl
`CSD_SERVICE_CODES_VL`
`CSD_TASK_PRIORITIES_V`
`CSD_TASK_RESOURCES_V`
`CSD_TASK_TYPES_V`
`CSD_WSH_LINE_STATUS_V`	View for shipping line status on status details tab