Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - CHV Tables and Views

TABLE - PO.CHV_AUTHORIZATIONS

TABLE - PO.CHV_BUCKET_PATTERNS

TABLE - PO.CHV_CUM_ADJUSTMENTS

TABLE - PO.CHV_CUM_PERIODS

TABLE - PO.CHV_CUM_PERIOD_ITEMS

TABLE - PO.CHV_HISTORY_CUM_PERIODS

TABLE - PO.CHV_HISTORY_SCHEDULES

TABLE - PO.CHV_HORIZONTAL_SCHEDULES

TABLE - PO.CHV_ITEM_ORDERS

TABLE - PO.CHV_ORG_OPTIONS

TABLE - PO.CHV_PURGE_CUM_LIST

TABLE - PO.CHV_PURGE_SCHEDULE_LIST

TABLE - PO.CHV_SCHEDULE_HEADERS

TABLE - PO.CHV_SCHEDULE_ITEMS

TABLE - PO.CHV_SCHEDULE_ORGANIZATIONS

VIEW - APPS.CHV_AUTHORIZATIONS_V

VIEW - APPS.CHV_AUTHORIZATION_HEADERS_V

VIEW - APPS.CHV_BUCKET_PATTERNS_VAL_V

VIEW - APPS.CHV_CUM_ITEMS_HISTORY_V

VIEW - APPS.CHV_CUM_ITEMS_V

VIEW - APPS.CHV_HORIZ_BKT_SCHEDULES_V

VIEW - APPS.CHV_HORIZ_DATE_SCHEDULES_V

VIEW - APPS.CHV_HORIZ_QTY_SCHEDULES_V

VIEW - APPS.CHV_ITEM_ORDERS_V

VIEW - APPS.CHV_ORG_OPTIONS_V

VIEW - APPS.CHV_OWNERS_ALL_V

VIEW - APPS.CHV_PLANNERS_ALL_V

VIEW - APPS.CHV_PLANNERS_VAL_V

VIEW - APPS.CHV_RECEIVING_TRANSACTIONS_V

VIEW - APPS.CHV_SCHEDULERS_ALL_V

VIEW - APPS.CHV_SCHEDULERS_VAL_V

VIEW - APPS.CHV_SCHEDULE_HEADERS_ALL_V

VIEW - APPS.CHV_SCHEDULE_HEADERS_V

VIEW - APPS.CHV_SCHEDULE_HEADERS_VAL_V

VIEW - APPS.CHV_SCHEDULE_ITEMS_V

Table: CHV_AUTHORIZATIONS

Comments

CHV_AUTHORIZATIONS stores all references to authorizations within
Supplier Scheduling. For each reference type (e.g. the ASL or a
Schedule Item), a row is created for each authorization. For example,
if 4 authorization codes and associated time fences are assigned to an
item in the ASL, 4 rows for this ASL record are added to this table --
one for each authorization code.
CHV_AUTHORIZATIONS was designed to 1) facilitate the display of
authorizations to the user and 2) allow for extensibility in the event
that we decide to allow for more than authorizations.

Indexes

Columns

[top of page]

PO.CHV_AUTHORIZATIONS does not reference any database object

PO.CHV_AUTHORIZATIONS is referenced by following:

PO

VIEW - CHV_AUTHORIZATIONS#

[top of page]

Table: CHV_BUCKET_PATTERNS

Comments

CHV_BUCKET_PATTERNS holds user-defined, variable bucket patterns
comprised of days, weeks, months, and quarters.

Indexes

Columns

[top of page]

PO.CHV_BUCKET_PATTERNS does not reference any database object

PO.CHV_BUCKET_PATTERNS is referenced by following:

PO

VIEW - CHV_BUCKET_PATTERNS#

[top of page]

Table: CHV_CUM_ADJUSTMENTS

Comments

CHV_CUM_ADJUSTMENTS stores manual CUM adjustment information for all
ASL items whose ship-to organization is tracking CUMs.

Indexes

Columns

[top of page]

PO.CHV_CUM_ADJUSTMENTS does not reference any database object

PO.CHV_CUM_ADJUSTMENTS is referenced by following:

PO

VIEW - CHV_CUM_ADJUSTMENTS#

[top of page]

Table: CHV_CUM_PERIODS

Comments

CHV_CUM_PERIODS stores one row for every CUM period that is defined
for a ship-to organization that has CUM Management enabled in the
Supplier Scheduling Options window.

Indexes

Columns

[top of page]

PO.CHV_CUM_PERIODS does not reference any database object

PO.CHV_CUM_PERIODS is referenced by following:

PO

VIEW - CHV_CUM_PERIODS#

[top of page]

Table: CHV_CUM_PERIOD_ITEMS

Comments

Not currently used.

Indexes

Columns

[top of page]

PO.CHV_CUM_PERIOD_ITEMS does not reference any database object

PO.CHV_CUM_PERIOD_ITEMS is referenced by following:

PO

VIEW - CHV_CUM_PERIOD_ITEMS#

[top of page]

Table: CHV_HISTORY_CUM_PERIODS

Comments

Historical information of CUM periods deleted by the Purge routine
are stored in this table.

Indexes

Columns

[top of page]

PO.CHV_HISTORY_CUM_PERIODS does not reference any database object

PO.CHV_HISTORY_CUM_PERIODS is referenced by following:

PO

VIEW - CHV_HISTORY_CUM_PERIODS#

[top of page]

Table: CHV_HISTORY_SCHEDULES

Comments

Historical information about the schedules deleted
by the Purge routine are stored in this table.

Indexes

Columns

[top of page]

PO.CHV_HISTORY_SCHEDULES does not reference any database object

PO.CHV_HISTORY_SCHEDULES is referenced by following:

PO

VIEW - CHV_HISTORY_SCHEDULES#

[top of page]

Table: CHV_HORIZONTAL_SCHEDULES

Comments

CHV_HORIZONTAL_SCHEDULES stores the horizontal, bucketed
representation of schedule item orders. Designed for direct selection
into the Workbench and reports.

Indexes

Columns

[top of page]

PO.CHV_HORIZONTAL_SCHEDULES does not reference any database object

PO.CHV_HORIZONTAL_SCHEDULES is referenced by following:

PO

VIEW - CHV_HORIZONTAL_SCHEDULES#

[top of page]

Table: CHV_ITEM_ORDERS

Comments

CHV_ITEM_ORDERS stores the order information (unimplemented planned
orders, approved requisitions, and approved releases) for items
associated with supplier schedules. It has a child relationship to
CHV_SCHEDULE_ITEMS.

Indexes

Columns

[top of page]

PO.CHV_ITEM_ORDERS does not reference any database object

PO.CHV_ITEM_ORDERS is referenced by following:

PO

VIEW - CHV_ITEM_ORDERS#

[top of page]

Table: CHV_ORG_OPTIONS

Primary Key: CHV_ORG_OPTIONS_PK

1. ORGANIZATION_ID

Comments

CHV_ORG_OPTIONS stores Supplier Scheduling options and defaults for a
ship-to organization.

Indexes

Columns

[top of page]

PO.CHV_ORG_OPTIONS does not reference any database object

PO.CHV_ORG_OPTIONS is referenced by following:

PO

VIEW - CHV_ORG_OPTIONS#

[top of page]

Table: CHV_PURGE_CUM_LIST

Primary Key: CHV_PURGE_CUM_LIST_PK

1. CUM_PERIOD_ID

Comments

This table will be populated with a list of CUM periods
that are purge candidates. When the purge is confirmed, all the
CUM periods in the list and their associated schedules will be
deleted.

Indexes

Columns

[top of page]

PO.CHV_PURGE_CUM_LIST does not reference any database object

PO.CHV_PURGE_CUM_LIST is referenced by following:

PO

VIEW - CHV_PURGE_CUM_LIST#

[top of page]

Table: CHV_PURGE_SCHEDULE_LIST

Primary Key: CHV_PURGE_SCHEDULE_LIST_PK

1. SCHEDULE_ITEM_ID

Comments

This table will be populated with a list of planning and shipping
schedules that are purge candidates. When the purge is confirmed, the
schedules in this list and all its related records will be deleted.

Indexes

Columns

[top of page]

PO.CHV_PURGE_SCHEDULE_LIST does not reference any database object

PO.CHV_PURGE_SCHEDULE_LIST is referenced by following:

PO

VIEW - CHV_PURGE_SCHEDULE_LIST#

[top of page]

Table: CHV_SCHEDULE_HEADERS

Comments

CHV_SCHEDULE_HEADERS stores supplier and schedule header
information for every supplier schedule built, using either
AutoSchedule or the Supplier Scheduling Workbench.

Indexes

Columns

[top of page]

PO.CHV_SCHEDULE_HEADERS does not reference any database object

PO.CHV_SCHEDULE_HEADERS is referenced by following:

PO

VIEW - CHV_SCHEDULE_HEADERS#

[top of page]

Table: CHV_SCHEDULE_ITEMS

Comments

CHV_SCHEDULE_ITEMS stores the item detail information associated with
supplier schedules. It has a child relationship to
CHV_SCHEDULE_HEADERS.

Indexes

Columns

[top of page]

PO.CHV_SCHEDULE_ITEMS does not reference any database object

PO.CHV_SCHEDULE_ITEMS is referenced by following:

PO

VIEW - CHV_SCHEDULE_ITEMS#

[top of page]

Table: CHV_SCHEDULE_ORGANIZATIONS

Comments

CHV_SCHEDULE_ORGANIZATIONS stores temporary organizations
associated with a schedule. Once the schedule is built, the
information in this table is no longer needed

Indexes

Columns

[top of page]

PO.CHV_SCHEDULE_ORGANIZATIONS does not reference any database object

PO.CHV_SCHEDULE_ORGANIZATIONS is referenced by following:

PO

VIEW - CHV_SCHEDULE_ORGANIZATIONS#

[top of page]

View: CHV_AUTHORIZATIONS_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - CHV_AUTHORIZATIONS

PACKAGE - FND_GLOBAL

- PO_LOOKUP_CODES

APPS.CHV_AUTHORIZATIONS_V is not referenced by any database object

[top of page]

View: CHV_AUTHORIZATION_HEADERS_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - CHV_AUTHORIZATIONS

SYNONYM - CHV_SCHEDULE_HEADERS

SYNONYM - CHV_SCHEDULE_ITEMS

PACKAGE - FND_GLOBAL

- PO_LOOKUP_CODES

APPS.CHV_AUTHORIZATION_HEADERS_V is not referenced by any database object

[top of page]

View: CHV_BUCKET_PATTERNS_VAL_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - CHV_BUCKET_PATTERNS

PACKAGE - FND_GLOBAL

- PO_LOOKUP_CODES

APPS.CHV_BUCKET_PATTERNS_VAL_V is not referenced by any database object

[top of page]

View: CHV_CUM_ITEMS_HISTORY_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - CHV_CUM_PERIODS

PACKAGE - CHV_INQ_SV2

PACKAGE - FND_GLOBAL

PACKAGE - FND_PROFILE

PACKAGE - HR_GENERAL

PACKAGE - HR_PERSON_NAME

PACKAGE - HR_SECURITY

VIEW - PO_VENDORS

- PO_VENDOR_SITES

- MTL_SYSTEM_ITEMS_KFV

- HR_EMPLOYEES

- PO_ASL_ATTRIBUTES_VAL_V

APPS.CHV_CUM_ITEMS_HISTORY_V is not referenced by any database object

[top of page]

View: CHV_CUM_ITEMS_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - CHV_CUM_PERIODS

PACKAGE - CHV_INQ_SV

PACKAGE - FND_GLOBAL

PACKAGE - HR_GENERAL

PACKAGE - HR_SECURITY

SYNONYM - PO_ASL_ATTRIBUTES

VIEW - PO_VENDORS

- MTL_SYSTEM_ITEMS_KFV

- ORG_ORGANIZATION_DEFINITIONS

- PO_VENDOR_SITES

APPS.CHV_CUM_ITEMS_V is not referenced by any database object

[top of page]

View: CHV_HORIZ_BKT_SCHEDULES_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - CHV_HORIZONTAL_SCHEDULES

PACKAGE - CHV_INQ_SV

APPS.CHV_HORIZ_BKT_SCHEDULES_V is not referenced by any database object

[top of page]

View: CHV_HORIZ_DATE_SCHEDULES_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - CHV_HORIZONTAL_SCHEDULES

APPS.CHV_HORIZ_DATE_SCHEDULES_V is not referenced by any database object

[top of page]

View: CHV_HORIZ_QTY_SCHEDULES_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - CHV_HORIZONTAL_SCHEDULES

APPS.CHV_HORIZ_QTY_SCHEDULES_V is not referenced by any database object

[top of page]

View: CHV_ITEM_ORDERS_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - CHV_ITEM_ORDERS

SYNONYM - CHV_SCHEDULE_ITEMS

PACKAGE - FND_GLOBAL

SYNONYM - PO_HEADERS_ALL

SYNONYM - PO_LINES_ALL

SYNONYM - PO_LINE_LOCATIONS

SYNONYM - PO_RELEASES_ALL

SYNONYM - PO_REQUISITION_HEADERS_ALL

SYNONYM - PO_REQUISITION_LINES

- PO_DOCUMENT_TYPES

- PO_LOOKUP_CODES

APPS.CHV_ITEM_ORDERS_V is not referenced by any database object

[top of page]

View: CHV_ORG_OPTIONS_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - CHV_BUCKET_PATTERNS

SYNONYM - CHV_ORG_OPTIONS

PACKAGE - FND_GLOBAL

PACKAGE - HR_GENERAL

PACKAGE - HR_SECURITY

SYNONYM - MRP_DESIGNATORS

SYNONYM - MRP_PLANS

SYNONYM - MTL_PARAMETERS

- PO_LOOKUP_CODES

- HR_ORGANIZATION_UNITS

APPS.CHV_ORG_OPTIONS_V is not referenced by any database object

[top of page]

View: CHV_OWNERS_ALL_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - CHV_SCHEDULE_HEADERS

PACKAGE - FND_PROFILE

PACKAGE - HR_GENERAL

PACKAGE - HR_PERSON_NAME

PACKAGE - HR_SECURITY

- HR_EMPLOYEES_CURRENT_V

APPS.CHV_OWNERS_ALL_V is not referenced by any database object

[top of page]

View: CHV_PLANNERS_ALL_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

PACKAGE - FND_PROFILE

PACKAGE - HR_GENERAL

PACKAGE - HR_PERSON_NAME

PACKAGE - HR_SECURITY

SYNONYM - MTL_PLANNERS

- HR_EMPLOYEES_CURRENT_V

APPS.CHV_PLANNERS_ALL_V is not referenced by any database object

[top of page]

View: CHV_PLANNERS_VAL_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

PACKAGE - FND_PROFILE

PACKAGE - HR_GENERAL

PACKAGE - HR_PERSON_NAME

PACKAGE - HR_SECURITY

SYNONYM - MTL_PLANNERS

- HR_EMPLOYEES_CURRENT_V

APPS.CHV_PLANNERS_VAL_V is not referenced by any database object