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

Description: Authorizations table

[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

Description: Bucket patterns table

[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

Description: CUM adjustments table

[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

Description: CUM periods table

[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

Description: Obsolete

[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

Description: Table containing historical information of CUM periods

[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

Description: Table containing historical information of schedules

[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

Description: Horizontal schedule table

[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

Description: Item orders table

[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

Description: Organization options table
Primary Key: CHV_ORG_OPTIONS_PK
  1. ORGANIZATION_ID

[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

Description: CUM periods candidates for purge table
Primary Key: CHV_PURGE_CUM_LIST_PK
  1. CUM_PERIOD_ID

[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

Description: Supplier schedule candidates for purge table
Primary Key: CHV_PURGE_SCHEDULE_LIST_PK
  1. SCHEDULE_ITEM_ID

[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

Description: Schedule headers table

[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

Description: Schedule items table

[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

Description: Schedule organizations table

[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

[top of page]

APPS.CHV_AUTHORIZATIONS_V references the following:

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

[top of page]

APPS.CHV_AUTHORIZATION_HEADERS_V references the following:

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

[top of page]

APPS.CHV_BUCKET_PATTERNS_VAL_V references the following:

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

[top of page]

APPS.CHV_CUM_ITEMS_HISTORY_V references the following:

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

[top of page]

APPS.CHV_CUM_ITEMS_V references the following:

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

[top of page]

APPS.CHV_HORIZ_BKT_SCHEDULES_V references the following:

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

[top of page]

APPS.CHV_HORIZ_DATE_SCHEDULES_V references the following:

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

[top of page]

APPS.CHV_HORIZ_QTY_SCHEDULES_V references the following:

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

[top of page]

APPS.CHV_ITEM_ORDERS_V references the following:

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

[top of page]

APPS.CHV_ORG_OPTIONS_V references the following:

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

[top of page]

APPS.CHV_OWNERS_ALL_V references the following:

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

[top of page]

APPS.CHV_PLANNERS_ALL_V references the following:

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

[top of page]

APPS.CHV_PLANNERS_VAL_V references the following:

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

[top of page]

View: CHV_RECEIVING_TRANSACTIONS_V

[top of page]

APPS.CHV_RECEIVING_TRANSACTIONS_V references the following:

APPS
SYNONYM - CHV_CUM_ADJUSTMENTS
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - PO_HEADERS
SYNONYM - RCV_SHIPMENT_HEADERS
SYNONYM - RCV_SHIPMENT_LINES
SYNONYM - RCV_TRANSACTIONS
- PO_LOOKUP_CODES
- HR_EMPLOYEES

APPS.CHV_RECEIVING_TRANSACTIONS_V is not referenced by any database object

[top of page]

View: CHV_SCHEDULERS_ALL_V

[top of page]

APPS.CHV_SCHEDULERS_ALL_V references the following:

APPS
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - PO_ASL_ATTRIBUTES
- HR_EMPLOYEES_CURRENT_V

APPS.CHV_SCHEDULERS_ALL_V is not referenced by any database object

[top of page]

View: CHV_SCHEDULERS_VAL_V

[top of page]

APPS.CHV_SCHEDULERS_VAL_V references the following:

APPS
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
- HR_EMPLOYEES_CURRENT_V
- PO_ASL_ATTRIBUTES_VAL_V

APPS.CHV_SCHEDULERS_VAL_V is not referenced by any database object

[top of page]

View: CHV_SCHEDULE_HEADERS_ALL_V

[top of page]

APPS.CHV_SCHEDULE_HEADERS_ALL_V references the following:

APPS
SYNONYM - CHV_SCHEDULE_HEADERS
PACKAGE - FND_GLOBAL
SYNONYM - MTL_PARAMETERS
VIEW - PO_VENDORS
- PO_LOOKUP_CODES
- PO_VENDOR_SITES

APPS.CHV_SCHEDULE_HEADERS_ALL_V is not referenced by any database object

[top of page]

View: CHV_SCHEDULE_HEADERS_V

[top of page]

APPS.CHV_SCHEDULE_HEADERS_V references the following:

APPS
SYNONYM - CHV_BUCKET_PATTERNS
SYNONYM - CHV_SCHEDULE_HEADERS
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - MTL_PARAMETERS
VIEW - PO_VENDORS
- PO_VENDOR_SITES
- HR_EMPLOYEES
- PO_LOOKUP_CODES

APPS.CHV_SCHEDULE_HEADERS_V is not referenced by any database object

[top of page]

View: CHV_SCHEDULE_HEADERS_VAL_V

[top of page]

APPS.CHV_SCHEDULE_HEADERS_VAL_V references the following:

APPS
SYNONYM - CHV_SCHEDULE_HEADERS
SYNONYM - CHV_SCHEDULE_ITEMS
PACKAGE - FND_GLOBAL
SYNONYM - MTL_PARAMETERS
VIEW - PO_VENDORS
- PO_VENDOR_SITES
- PO_LOOKUP_CODES

APPS.CHV_SCHEDULE_HEADERS_VAL_V is not referenced by any database object

[top of page]

View: CHV_SCHEDULE_ITEMS_V

[top of page]

APPS.CHV_SCHEDULE_ITEMS_V references the following:

APPS
PACKAGE - CHV_INQ_SV
SYNONYM - CHV_SCHEDULE_HEADERS
SYNONYM - CHV_SCHEDULE_ITEMS
PACKAGE - FND_GLOBAL
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - PO_ASL_ATTRIBUTES
SYNONYM - PO_HEADERS
SYNONYM - PO_LINES_ALL
- PO_LOOKUP_CODES
- PER_PEOPLE_F
- MTL_SYSTEM_ITEMS_KFV

APPS.CHV_SCHEDULE_ITEMS_V is not referenced by any database object

[top of page]



Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract