Results for “confirm_date”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CHV_SCHEDULE_HEADERS_VAL_V is a validation view owned by the APPS schema in Oracle E-Business Suite, defined within the CHV (Supplier Scheduling) product family. It is documented as a retrofitted object, meaning its definition was migrated to conform to later release standards across the 12.1.1 and 12.2.2 code lines. The view presents a consolidated, grouped picture of supplier schedule headers that have reached the CONFIRMED status, joining each header to its vendor, vendor site, inventory organization, and schedule type lookup description.
Because the view filters on CSH.SCHEDULE_STATUS = 'CONFIRMED', it exposes only authoritative, supplier-acknowledged schedules rather than draft or pending revisions. Its role is primarily reporting and validation: it supplies a single denormalized row per schedule so that downstream forms, concurrent programs, or integration extracts do not have to repeat the multi-table join logic. The presence of CONFIRM_DATE and SCHEDULE_REVISION as aggregated columns makes the view particularly relevant to queries that track when a schedule was confirmed and which revision it represents.
Underlying Base Objects
The view is defined over the following documented base objects:
- CHV_SCHEDULE_HEADERS (synonym) — the driving table, providing schedule ID, number, revision, type, status, horizon start, vendor and vendor site identifiers, and organization identifier.
- CHV_SCHEDULE_ITEMS (synonym) — joined on SCHEDULE_ID and used to derive the inventory organization through CSI.ORGANIZATION_ID.
- MTL_PARAMETERS (synonym) — supplies the ORGANIZATION_CODE for the organization carried on the schedule items.
- PO_VENDORS (view) — provides VENDOR_NAME for the header's VENDOR_ID.
- PO_VENDOR_SITES (view) — provides VENDOR_SITE_CODE for the header's VENDOR_SITE_ID.
- PO_LOOKUP_CODES (view) — resolves SCHEDULE_TYPE to its DISPLAYED_FIELD, exposed as SCHEDULE_TYPE_NAME, using LOOKUP_TYPE = 'SCHEDULE_TYPE'.
The documented reference list also includes FND_GLOBAL (package), which supports multi-organization security context during execution. The join structure is inner throughout, so a schedule row only appears when a matching vendor, vendor site, organization parameter record, and schedule type lookup all exist.
Key Columns
- CONFIRM_DATE — the maximum confirmation date across the rows aggregated under each schedule; commonly the target column when searching for "confirm_date".
- SCHEDULE_REVISION — the maximum schedule revision, indicating the highest revision level for the grouped schedule.
- SCHEDULE_ID, SCHEDULE_NUM — the internal key and user-facing identifier of the schedule header.
- VENDOR_NAME, VENDOR_SITE_CODE — supplier and supplier site descriptive values.
- ORGANIZATION_CODE — inventory organization code derived from MTL_PARAMETERS.
- MULTI_ORG_FLAG — a DECODE expression returning 'Y' when CSH.ORGANIZATION_ID is null and 'N' otherwise, indicating whether the schedule is defined across multiple organizations.
- SCHEDULE_HORIZON_START — the start of the scheduling horizon for the header.
- SCHEDULE_TYPE, SCHEDULE_TYPE_NAME — the lookup code and its displayed description.
Common Use Cases and Queries
Typical use cases include confirmed-schedule reporting, supplier acknowledgement tracking, and identifying the latest confirmation timestamp per schedule. The following query returns confirmed schedules with their confirmation dates:
- SELECT schedule_num, vendor_name, vendor_site_code, schedule_revision, confirm_date, schedule_type_name FROM chv_schedule_headers_val_v WHERE confirm_date IS NOT NULL ORDER BY confirm_date DESC;
- SELECT schedule_num, confirm_date FROM chv_schedule_headers_val_v WHERE confirm_date >= :p_from_date AND confirm_date < :p_to_date;
- SELECT organization_code, COUNT(*) FROM chv_schedule_headers_val_v GROUP BY organization_code;
Because CONFIRM_DATE and SCHEDULE_REVISION are produced by MAX aggregates and the outer query groups by schedule ID, vendor, site, organization, horizon start, and schedule type, results reflect one row per logical confirmed schedule. Consumers should therefore avoid expecting item-level or distribution-level detail from this view and instead join back to CHV_SCHEDULE_HEADERS or CHV_SCHEDULE_ITEMS when line-level granularity is required.
-
- Retrofitted
APPS.CHV_SCHEDULE_HEADERS_VAL_V·↳ CHV_SCHEDULE_HEADERS·↳ CHV_SCHEDULE_ITEMS·↳ FND_GLOBAL·Explore CHV module →
-
- Retrofitted
APPS.CHV_SCHEDULE_HEADERS_VAL_V·↳ CHV_SCHEDULE_HEADERS·↳ CHV_SCHEDULE_ITEMS·↳ FND_GLOBAL·Explore CHV module →
-
APPS.WSH_NEW_DELIVERIES_OB_GRP_V·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
View: WSH_SHIPPING_DETAILS_V 12.1.1
APPS.WSH_SHIPPING_DETAILS_V·↳ HR_LOCATIONS_ALL·↳ OE_INSTALL·↳ OE_ORDER_HEADERS_ALL·Explore OE module →
-
View: WSH_SHIPPING_DETAILS_V 12.2.2
APPS.WSH_SHIPPING_DETAILS_V·↳ HR_LOCATIONS_ALL·↳ OE_INSTALL·↳ OE_ORDER_HEADERS_ALL·Explore OE module →
-
Used to select schedule and vendor info for shipment schedules.
APPS.POS_SHIP_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore POS module →
-
View: CHV_SCHEDULE_HEADERS_V 12.2.2
- Retrofitted
APPS.CHV_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore CHV module →
-
APPS.POS_CHV_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore PO module →
-
This table stores the payment information about payment made to TCS authority.
-
Schedule headers table
-
This table stores the payment information about payment made to TCS authority.
-
used to select the schedule and vendor info
APPS.POS_CHV_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore POS module →
-
Schedule headers table
-
Used to select schedule and vendor info for planning schedules.
APPS.ICX_PLAN_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore ICX module →
-
Used to select schedule and vendor info for shipment schedules.
APPS.ICX_SHIP_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore ICX module →
-
View: WSH_DLVB_DLVY_V 12.1.1
APPS.WSH_DLVB_DLVY_V·↳ WSH_DELIVERY_ASSIGNMENTS_V·↳ WSH_LOOKUPS·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
View: WSH_SHIPPING_DETAILS_V 12.2.2
APPS.WSH_SHIPPING_DETAILS_V·↳ HR_LOCATIONS_ALL·↳ OE_INSTALL·↳ OE_ORDER_HEADERS_ALL·Explore WSH module →
-
View: WSH_SHIPPING_DETAILS_V 12.1.1
APPS.WSH_SHIPPING_DETAILS_V·↳ HR_LOCATIONS_ALL·↳ OE_INSTALL·↳ OE_ORDER_HEADERS_ALL·Explore WSH module →
-
View: WSH_TRIP_DELIVERIES_V 12.1.1
APPS.WSH_TRIP_DELIVERIES_V·↳ WSH_DELIVERY_LEGS·↳ WSH_NEW_DELIVERIES_V·↳ WSH_TRIPS·Explore WSH module →
-
View: WSH_TRIP_DELIVERIES_V 12.2.2
APPS.WSH_TRIP_DELIVERIES_V·↳ WSH_DELIVERY_LEGS·↳ WSH_NEW_DELIVERIES_V·↳ WSH_TRIPS·Explore WSH module →
-
APPS.WSH_NEW_DELIVERIES_OB_GRP_V·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
Deliveries
-
View: WSHBV_DELIVERIES 12.2.2
APPS.WSHBV_DELIVERIES·↳ WSH_LOCATIONS·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
View: WSH_STOP_DELIVERIES_V 12.1.1
APPS.WSH_STOP_DELIVERIES_V·↳ WSH_DELIVERY_LEGS·↳ WSH_NEW_DELIVERIES_V·↳ WSH_TRIP_STOPS·Explore WSH module →
-
View: WSHBV_DELIVERIES 12.1.1
APPS.WSHBV_DELIVERIES·↳ WSH_LOCATIONS·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
Used to select schedule and vendor info for planning schedules.
APPS.ICX_PLAN_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore ICX module →
-
APPS.POS_CHV_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore PO module →
-
View: WSHFV_DELIVERIES 12.2.2
Full BIS Business View for Deliveries.
APPS.WSHFV_DELIVERIES·↳ HR_ALL_ORGANIZATION_UNITS·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore WSH module →
-
Used to select schedule and vendor info for planning schedules.
APPS.POS_PLAN_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore POS module →
-
View: CHV_SCHEDULE_HEADERS_V 12.1.1
- Retrofitted
APPS.CHV_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore CHV module →
-
Used to select schedule and vendor info for shipment schedules.
APPS.ICX_SHIP_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore ICX module →
-
Deliveries
-
View: WSHFV_DELIVERIES 12.1.1
Full BIS Business View for Deliveries.
APPS.WSHFV_DELIVERIES·↳ HR_ALL_ORGANIZATION_UNITS·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore WSH module →
-
View: WSH_NEW_DELIVERIES_V 12.2.2
APPS.WSH_NEW_DELIVERIES_V·↳ WSH_LOOKUPS·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
View: WSH_DLVB_DLVY_V 12.2.2
APPS.WSH_DLVB_DLVY_V·↳ WSH_DELIVERY_ASSIGNMENTS_V·↳ WSH_LOOKUPS·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
View: WSH_NEW_DELIVERIES_V 12.1.1
APPS.WSH_NEW_DELIVERIES_V·↳ WSH_LOOKUPS·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
APPS.JAI_OM_WSH_DELIVERIES_V·↳ WSH_DELIVERY_ASSIGNMENTS·↳ WSH_DELIVERY_DETAILS·↳ WSH_NEW_DELIVERIES·Explore JA module →
-
View: WSH_STOP_DELIVERIES_V 12.2.2
APPS.WSH_STOP_DELIVERIES_V·↳ WSH_DELIVERY_LEGS·↳ WSH_NEW_DELIVERIES_V·↳ WSH_TRIP_STOPS·Explore WSH module →
-
Deliveries Interface Table
-
Deliveries Interface Table
-
VIEW: APPS.WSHBV_DELIVERIES 12.1.1