Results for “customer_product_type”
36 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
SO_LINE_SERVICE_DETAILS_V is a reporting view in the Oracle E-Business Suite Order Entry (OE) module. It exposes service detail records associated with order lines, presenting denormalized service, system, transaction type, customer product, and contact information in a single queryable object. The view is defined over the SO_LINE_SERVICE_DETAILS base table (aliased LSD) and joins to several reference and master tables to resolve codes into descriptive values.
Because the view resolves foreign-key identifiers into human-readable names — transaction type, system name, customer product type, system type, contact names, and customer address details — it is well suited for reporting, extract, and integration scenarios where consumers require descriptive service-line context rather than raw identifiers. The user search term "system_type" maps directly to the SYSTEM_TYPE column exposed by this view, which is populated from the SYSTEM_TYPE_CODE lookup and resolved through a lookup join.
Underlying Base Objects
The view text reveals the following referenced objects:
- SO_LINE_SERVICE_DETAILS (LSD) — the primary base table holding line service detail rows.
- Transaction Type (TT) — resolves TRANSACTION_TYPE_ID to a name and revision flag.
- CS Lookups (CSLK, CSLK1) — resolve customer product type and system type codes to their meaning text.
- System table (SYS) — resolves SYSTEM_ID to SYSTEM_NAME.
- Contact table (CON, CON1) — resolves technical and service contact identifiers to formatted names.
- RA_CUSTOMERS / RA_SITE_USE / RA_ADDRESSES (RACST, RASIT, RAADR) — supply customer name, number, site, and concatenated address fields.
The view is documented as "Not implemented in this database," meaning it may not be seeded by default in every instance and may require validation against the target environment's source tables.
Key Columns
- LINE_SERVICE_DETAIL_ID — primary key of the service detail record.
- LINE_ID — links the detail to the parent order line.
- SYSTEM_TYPE — the descriptive meaning of SYSTEM_TYPE_CODE, resolved via lookup; this is the column most relevant to a search on "system_type."
- SYSTEM_TYPE_CODE — the stored code value.
- SYSTEM_NAME — resolved system name from the System table.
- TRANSACTION_TYPE and REVISION_FLAG — descriptive transaction classification.
- CUSTOMER_PRODUCT_TYPE and CP_QUANTITY — product classification and quantity.
- TECHNICAL_CONTACT and SERVICE_CONTACT_NAME — formatted contact names.
- CUSTOMER_NAME / CUSTOMER_NUMBER / LOCATION / ADDRESS fields — concatenated customer and site descriptors.
- ATTRIBUTE1–15 and CONTEXT — descriptive flexfield columns for extensibility.
Common Use Cases and Queries
Typical uses include service-line reporting, order-line enrichment for downstream systems, and auditing of system and transaction type assignments.
Example query filtering on system type:
SELECT line_id, transaction_type, system_name, system_type,
customer_product_type, cp_quantity, technical_contact, service_contact_name
FROM so_line_service_details_v
WHERE system_type = :p_system_type;
Example by order line:
SELECT line_service_detail_id, line_id, transaction_type, system_name, system_type
FROM so_line_service_details_v
WHERE line_id = :p_line_id;
Because the view performs multiple outer joins to resolve codes, queries benefit from filtering on indexed columns of the base table, such as LINE_ID, and from avoiding unfiltered full scans where the customer and address joins return large result sets.
-
Customer Product Types
-
Customer Product Types
-
Not implemented in this database·Explore OE module →
-
Not implemented in this database·Explore OE module →
-
View: CS_CP_AUDIT_MAINTAIN_V 12.2.2
View of the Customer Product Audit table
Not implemented in this database·Explore CS module →
-
View: CS_CP_AUDIT_MAINTAIN_V 12.1.1
View of the Customer Product Audit table
Not implemented in this database·Explore CS module →
-
VIEW: APPS.CS_ACC_CP_RG_V 12.1.1
-
View: CS_CP_AUDIT_MAINT_V 12.2.2
Audit information for customer products
APPS.CS_CP_AUDIT_MAINT_V·↳ CSICUMPI_PUB·↳ CS_CP_AUDIT·↳ CS_CUSTOMER_PRODUCTS_ALL·Explore CS module →
-
View: AST_INSTALLED_BASE_V 12.1.1
Not implemented in this database·Explore AST module →
-
View: CS_CP_AUDIT_MAINT_V 12.1.1
Audit information for customer products
APPS.CS_CP_AUDIT_MAINT_V·↳ CSICUMPI_PUB·↳ CS_CP_AUDIT·↳ CS_CUSTOMER_PRODUCTS_ALL·Explore CS module →
-
VIEW: APPS.CS_ACC_CP_RG_V 12.2.2
-
View: CS_ACC_CP_RG_V_1155 12.1.1
This view is used by the main service request form for a record group to retrieve install base information.
Not implemented in this database·Explore CS module →
-
View: CS_ACC_CP_RG_V_1155 12.2.2
This view is used by the main service request form for a record group to retrieve install base information.
Not implemented in this database·Explore CS module →
-
View: AST_INSTALLED_BASE_V 12.2.2
Not implemented in this database·Explore AST module →
-
View: CS_ACC_CP_RG_V 12.2.2
This view is used by the main service request form for a record group to retrieve install base information.
APPS.CS_ACC_CP_RG_V·↳ CSICUMPI_PUB·↳ CS_CP_REVISIONS·↳ CS_CUSTOMER_PRODUCTS_ALL·Explore CS module →
-
- Retrofitted
APPS.CS_CUSTOMER_PRODUCTS_REPORT_V·↳ CSICUMPI_PUB·↳ CS_CP_REVISIONS·↳ CS_CUSTOMER_PRODUCTS_ALL·Explore CS module →
-
View: CS_ACC_CP_RG_V 12.1.1
This view is used by the main service request form for a record group to retrieve install base information.
APPS.CS_ACC_CP_RG_V·↳ CSICUMPI_PUB·↳ CS_CP_REVISIONS·↳ CS_CUSTOMER_PRODUCTS_ALL·Explore CS module →
-
View: CS_CUST_PROD_MAINT_V 12.1.1
New View for Customer Products - Performance
Not implemented in this database·Explore CS module →
-
- Retrofitted
APPS.CS_CUSTOMER_PRODUCTS_REPORT_V·↳ CSICUMPI_PUB·↳ CS_CP_REVISIONS·↳ CS_CUSTOMER_PRODUCTS_ALL·Explore CS module →
-
View: CS_CUST_PROD_MAINT_V 12.2.2
New View for Customer Products - Performance
Not implemented in this database·Explore CS module →
-
12.2.2 FND Design Data 12.2.2
-
View: CS_CP_MAINT_V 12.1.1
Products in the installed base
Not implemented in this database·Explore CS module →
-
View: CS_CP_MAINT_V 12.2.2
Products in the installed base
Not implemented in this database·Explore CS module →
-
12.1.1 FND Design Data 12.1.1
-
View: CSI_INSTALLED_BASE_V 12.2.2
View for the grid in E-Business Center.
APPS.CSI_INSTALLED_BASE_V·↳ CSI_INSTANCE_STATUSES·↳ CSI_ITEM_INSTANCES·↳ CSI_LOOKUPS·Explore CSI module →
-
View: CSI_INSTALLED_BASE_V 12.1.1
View for the grid in E-Business Center.
APPS.CSI_INSTALLED_BASE_V·↳ CSI_INSTANCE_STATUSES·↳ CSI_ITEM_INSTANCES·↳ CSI_LOOKUPS·Explore CSI module →
-
Products in the installed base
Not implemented in this database·Explore CS module →
-
View: CS_CUST_PROD_FORM_V 12.1.1
Not implemented in this database·Explore CS module →
-
Products in the installed base
Not implemented in this database·Explore CS module →
-
View: CS_CUST_PROD_FORM_V 12.2.2
Not implemented in this database·Explore CS module →