Results for “approval_required_flag”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CSD_RO_GROUP_ESTIMATE_V is an Oracle E-Business Suite 12.1.1 / 12.2.2 reporting view owned by the APPS schema in the CSD (Depot Repair) product family. Its documented purpose is to summarize all estimates for a given repair order line, grouped by MLE (multi-lingual entity) categories. In practice, the view consolidates material, labor, expense, and total estimate amounts alongside their associated status lookups into a single, denormalized result set that can be queried directly by reports, OAF pages, concurrent programs, and integration interfaces without requiring callers to invoke packaging logic themselves.
The view is especially relevant to users searching on the term estimate_status, because it exposes an ESTIMATE_STATUS column that resolves the coded value stored on the estimate record to its translated meaning via FND_LOOKUPS. This makes the view a convenient data source when a repair order must be displayed or extracted together with human-readable estimate and approval statuses.
Underlying Base Objects
The ETRM metadata documents the following referenced base objects:
- CSD_PROCESS_UTIL (PACKAGE) — supplies the
GET_ESTIMATEfunction used inline in the view text to derive MATERIAL, LABOR, EXPENSE, and TOTAL_ESTIMATE values for a repair line. - CSD_REPAIRS (SYNONYM) — the repair order line source; contributes repair number, line/group identifiers, and approval attributes.
- CSD_REPAIR_ESTIMATE (SYNONYM) — the estimate record source; contributes the estimate status code.
- FND_LOOKUPS (VIEW) — joined twice with outer joins to translate the estimate status and approval status codes into their meanings.
- FND_GLOBAL (PACKAGE) — supplied for session/context resolution within the underlying logic.
The view joins CSD_REPAIRS to CSD_REPAIR_ESTIMATE on REPAIR_LINE_ID using an outer join, so repair lines without an estimate record are still returned. The lookup joins are likewise outer joins, which prevents rows from being dropped when a status code is null or has no matching lookup entry. The lookups are constrained to the lookup types CSD_ESTIMATE_STATUS and CSD_APPROVAL_STATUS.
Key Columns
- ROW_ID — the ROWID of the underlying CSD_REPAIRS row, useful for direct row access.
- REPAIR_NUMBER — the user-visible depot repair order number.
- REPAIR_LINE_ID — the primary key of the repair line; also passed to
GET_ESTIMATE. - REPAIR_GROUP_ID — the repair group identifier, supporting the "group estimate" aggregation implied by the view name.
- MATERIAL, LABOR, EXPENSE, TOTAL_ESTIMATE — amounts computed by
CSD_PROCESS_UTIL.GET_ESTIMATEusing category codes 'M', 'L', 'E', and 'T' respectively. - APPROVAL_REQUIRED_FLAG — indicates whether the estimate requires approval.
- ESTIMATE_STATUS — the translated meaning of the estimate status lookup (documented column name; the view text aliases it as ESIMATE_STATUS). This is the column of primary interest to users searching on estimate_status.
- APPROVAL_STATUS — the translated meaning of the approval status lookup.
Common Use Cases and Queries
The view is typically used to report estimate composition and status by repair line or group, to drive approval workflows, and to feed downstream cost or billing processes. A straightforward query listing estimate status per repair is:
SELECT repair_number, repair_line_id, material, labor, expense, total_estimate, estimate_status, approval_status FROM csd_ro_group_estimate_v;
Filtering by status is equally direct — for example, retrieving all lines awaiting approval by estimate status or by approval requirement:
SELECT repair_number, total_estimate, estimate_status FROM csd_ro_group_estimate_v WHERE estimate_status = 'Pending Approval';
SELECT repair_number, repair_group_id, total_estimate FROM csd_ro_group_estimate_v WHERE approval_required_flag = 'Y';
Because the view already resolves lookup meanings, it removes the need for application code to join FND_LOOKUPS manually, making it well suited to concurrent report data sources, OAF VO definitions, and outbound integration extracts.
-
View to summarize all the estimates for a given repair order line by MLE categories.
APPS.CSD_RO_GROUP_ESTIMATE_V·↳ CSD_PROCESS_UTIL·↳ CSD_REPAIRS·↳ CSD_REPAIR_ESTIMATE·Explore CSD module →
-
View to summarize all the estimates for a given repair order line by MLE categories.
APPS.CSD_RO_GROUP_ESTIMATE_V·↳ CSD_PROCESS_UTIL·↳ CSD_REPAIRS·↳ CSD_REPAIR_ESTIMATE·Explore CSD module →
-
10SC ONLY - Retrofitted
APPS.PO_RFQS_FOR_QUOTE_ALL_V·↳ FND_GLOBAL·↳ PO_HEADERS·↳ PO_LOOKUP_CODES·Explore PO module →
-
10SC ONLY - Retrofitted
APPS.PO_RFQS_FOR_QUOTE_ALL_V·↳ FND_GLOBAL·↳ PO_HEADERS·↳ PO_LOOKUP_CODES·Explore PO module →
-
View: CSD_REPAIR_ESTIMATE_V 12.1.1
Fetches the estimate header for repair orders.
APPS.CSD_REPAIR_ESTIMATE_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_ESTIMATE·↳ CS_INCIDENTS_B_SEC·Explore CSD module →
-
View: CSD_RO_GROUP_DETAILS_V 12.2.2
Views that defines all the repair order details for a group.
APPS.CSD_RO_GROUP_DETAILS_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_ORDER_GROUPS·↳ CSD_REPAIR_TYPES_VL·Explore CSD module →
-
The table stores the control item type definitions. The values are created by the customer.
-
View: PO_HEADERS_TRX_V 12.2.2
View on po_headers table.
-
View: PA_CI_TYPES_V 12.2.2
This view is used to display the details of the control item type, in the Update Control Item Type page.
APPS.PA_CI_TYPES_V·↳ PA_CI_TYPES_B·↳ PA_CI_TYPES_TL·↳ PA_CLASS_CATEGORIES·Explore PA module →
-
View: PO_ITEM_SOURCES 12.1.1
Sources for an item
APPS.PO_ITEM_SOURCES·↳ PO_HEADERS_ALL·↳ PO_LINES_ALL·↳ PO_LINE_LOCATIONS·Explore PO module →
-
The table stores the control item type definitions. The values are created by the customer.
-
View: CSD_REPAIR_JOBS_V 12.2.2
The view for getting repair orders with service request information.
APPS.CSD_REPAIR_JOBS_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_TYPES_VL·↳ CSI_ITEM_INSTANCES·Explore CSD module →
-
View: CSD_REPAIR_JOBS_V 12.1.1
The view for getting repair orders with service request information.
APPS.CSD_REPAIR_JOBS_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_TYPES_VL·↳ CSI_ITEM_INSTANCES·Explore CSD module →
-
View: CSD_REPAIR_ESTIMATE_V 12.2.2
Fetches the estimate header for repair orders.
APPS.CSD_REPAIR_ESTIMATE_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_ESTIMATE·↳ CS_INCIDENTS_B_SEC·Explore CSD module →
-
View: PA_CI_TYPES_VL 12.2.2
This view is used to display the list of existing control item types.
APPS.PA_CI_TYPES_VL·↳ PA_CI_TYPES_B·↳ PA_CI_TYPES_TL·Explore PA module →
-
PO_CHANGE_REQUEST table stores the change requests for Purchase Orders, Releases and Requisitions submitted by Suppliers or Requesters
-
View: CSD_PRODUCT_TXNS_V 12.2.2
This View is used for the Receive/Ship tab in the Repair Orders Workbench. This will show all the Charge Lines and related information created for the repair order
APPS.CSD_PRODUCT_TXNS_V·↳ CSD_PRODUCT_TRANSACTIONS·↳ CSD_REPAIRS·↳ CSI_ITEM_INSTANCES·Explore CSD module →
-
View: CSD_PRODUCT_TXNS_V 12.1.1
This View is used for the Receive/Ship tab in the Repair Orders Workbench. This will show all the Charge Lines and related information created for the repair order
APPS.CSD_PRODUCT_TXNS_V·↳ CSD_PRODUCT_TRANSACTIONS·↳ CSD_REPAIRS·↳ CSI_ITEM_INSTANCES·Explore CSD module →
-
View: PA_CI_TYPES_VL 12.1.1
APPS.PA_CI_TYPES_VL·↳ PA_CI_TYPES_B·↳ PA_CI_TYPES_TL·Explore PA module →
-
View: CSD_IR_REPAIR_JOBS_V 12.1.1
The view used in Submit Repair Jobs if the Allow create WIP Job w/o RMA is set
APPS.CSD_IR_REPAIR_JOBS_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_TYPES_VL·↳ CSI_ITEM_INSTANCES·Explore CSD module →
-
- Retrofitted
APPS.PO_QUOTATIONS_TO_APPROVE·↳ AP_TERMS·↳ FND_GLOBAL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
View: POS_PO_RFQ_HEADERS_V 12.1.1
APPS.POS_PO_RFQ_HEADERS_V·↳ AP_TERMS·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
View: PO_ITEM_SOURCES 12.2.2
Sources for an item
APPS.PO_ITEM_SOURCES·↳ PO_HEADERS_ALL·↳ PO_LINES_ALL·↳ PO_LINE_LOCATIONS·Explore PO module →
-
View: CSD_PRODUCT_TXNS_IRO_V 12.2.2
APPS.CSD_PRODUCT_TXNS_IRO_V·↳ CSD_PARTY_SITES_V·↳ CSD_PRODUCT_TRANSACTIONS·↳ CSD_REPAIRS·Explore CSD module →
-
View: PA_CI_TYPES_V 12.1.1
APPS.PA_CI_TYPES_V·↳ PA_CI_TYPES_B·↳ PA_CI_TYPES_TL·↳ PA_CLASS_CATEGORIES·Explore PA module →
-
APPS.CSD_REPAIR_ACTUAL_LINES_V·↳ BOM_RESOURCES_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_ACTUALS·Explore CSD module →
-
Fetches all the estimate lines for repair orders.
APPS.CSD_REPAIR_ESTIMATE_LINES_V·↳ BOM_RESOURCES_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_ESTIMATE·Explore CSD module →
-
Fetches all the estimate lines for repair orders.
APPS.CSD_REPAIR_ESTIMATE_LINES_V·↳ BOM_RESOURCES_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_ESTIMATE·Explore CSD module →
-
View: CSD_REPAIRS_NON_SEC_V 12.2.2
The view for getting repair orders. It is without Service Security.
APPS.CSD_REPAIRS_NON_SEC_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_TYPES_VL·↳ CSI_INSTANCE_STATUSES·Explore CSD module →
-
View: CSD_RO_GROUP_DETAILS_V 12.1.1
Views that defines all the repair order details for a group.
APPS.CSD_RO_GROUP_DETAILS_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_ORDER_GROUPS·↳ CSD_REPAIR_TYPES_VL·Explore CSD module →
-
Obsolete
APPS.ICX_PO_HDR_ARCHIVE_OPEN_V·↳ AP_TERMS·↳ FND_CURRENCY·↳ FND_GLOBAL·Explore ICX module →
-
Supplier Orders View
APPS.ICX_PO_SUPPLIER_ORDERS_V·↳ AP_TERMS·↳ FND_CURRENCY·↳ FND_GLOBAL·Explore ICX module →
-
View: CSD_IR_REPAIR_JOBS_V 12.2.2
The view used in Submit Repair Jobs if the Allow create WIP Job w/o RMA is set
APPS.CSD_IR_REPAIR_JOBS_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_TYPES_VL·↳ CSI_ITEM_INSTANCES·Explore CSD module →
-
- Retrofitted
APPS.PO_QUOTATIONS_TO_APPROVE·↳ AP_TERMS·↳ FND_GLOBAL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
View: CSD_PRODUCT_TXNS_IRO_V 12.1.1
APPS.CSD_PRODUCT_TXNS_IRO_V·↳ CSD_PARTY_SITES_V·↳ CSD_PRODUCT_TRANSACTIONS·↳ CSD_REPAIRS·Explore CSD module →
-
View: POS_PO_RFQ_HEADERS_V 12.2.2
APPS.POS_PO_RFQ_HEADERS_V·↳ AP_TERMS·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
View: CSD_REPAIRS_V 12.1.1
The view for getting repair orders.
APPS.CSD_REPAIRS_V·↳ CSD_FLOW_STATUSES_B·↳ CSD_FLOW_STATUSES_TL·↳ CSD_REPAIRS·Explore CSD module →
-
View: PO_HEADERS_RFQQT_V 12.1.1
- Retrofitted
APPS.PO_HEADERS_RFQQT_V·↳ AP_TERMS·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
View: PA_CI_CRPRJ_LIST_V 12.1.1
APPS.PA_CI_CRPRJ_LIST_V·↳ HZ_PARTIES·↳ PA_CI_SECURED_V·↳ PA_CI_SECURITY_PKG·Explore PA module →
-
View: ICX_PO_RFQ_HEADERS_V 12.2.2
Request for Quotations Header View
APPS.ICX_PO_RFQ_HEADERS_V·↳ AP_TERMS·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore ICX module →
-
View: PO_HEADERS_V 12.2.2
10SC ONLY
APPS.PO_HEADERS_V·↳ AP_TERMS·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
View: PA_CI_BASIC_CTL_V 12.1.1
APPS.PA_CI_BASIC_CTL_V·↳ FND_CURRENCIES_TL·↳ HZ_PARTIES·↳ PA_CI_TYPES_VL·Explore PA module →
-
For Internal Use Only: This table is global temporary table based on po_headers_all table. It is used for internal processing of data for PO Approval Submission Checks.
-
View: PA_CI_BASIC_CTL_V 12.2.2
APPS.PA_CI_BASIC_CTL_V·↳ FND_CURRENCIES_TL·↳ HZ_PARTIES·↳ PA_CI_TYPES_VL·Explore PA module →
-
View: PO_HEADERS_RFQQT_V 12.2.2
- Retrofitted
APPS.PO_HEADERS_RFQQT_V·↳ AP_TERMS·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
PO_CHANGE_REQUEST table stores the change requests for Purchase Orders, Releases and Requisitions submitted by Suppliers or Requesters
-
Stores the template information from which negotiations can be created
-
APPS.POS_PO_SUPPLIER_ORDERS_V·↳ AP_TERMS·↳ FND_CURRENCY·↳ FND_GLOBAL·Explore PO module →
-
View: ICX_PO_RFQ_HEADERS_V 12.1.1
Request for Quotations Header View
APPS.ICX_PO_RFQ_HEADERS_V·↳ AP_TERMS·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore ICX module →
-
Supplier Agreements View
APPS.ICX_PO_SUPPLIER_AGREEMENTS_V·↳ AP_TERMS·↳ FND_CURRENCY·↳ FND_GLOBAL·Explore ICX module →