DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.CHV_SCHEDULE_HEADERS_ALL_V

Object Details
Object Name: CHV_SCHEDULE_HEADERS_ALL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCHV.CHV_SCHEDULE_HEADERS_ALL_V
Subobject Name:
Status: VALID

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
SCHEDULE_NUM VARCHAR2 (20)
Schedule number
SCHEDULE_REVISION NUMBER

Schedule revision
SCHEDULE_ID NUMBER
Yes Schedule unique identifier
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
VENDOR_NAME VARCHAR2 (240)
Vendor name
VENDOR_SITE_CODE VARCHAR2 (15)
Site code name
SCHEDULE_HORIZON_START DATE
Yes Schedule horizon start date
SCHEDULE_TYPE VARCHAR2 (25) Yes Planning or Shipping schedule
SCHEDULE_TYPE_NAME VARCHAR2 (80)
Schedule type name
ORG_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SCHEDULE_NUM
,      SCHEDULE_REVISION
,      SCHEDULE_ID
,      ORGANIZATION_CODE
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      SCHEDULE_HORIZON_START
,      SCHEDULE_TYPE
,      SCHEDULE_TYPE_NAME
,      ORG_ID
FROM APPS.CHV_SCHEDULE_HEADERS_ALL_V;

Dependencies

[top of page]

APPS.CHV_SCHEDULE_HEADERS_ALL_V references the following:

SchemaAPPS
SynonymCHV_SCHEDULE_HEADERS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymMTL_PARAMETERS
ViewPO_LOOKUP_CODES
ViewPO_VENDORS
ViewPO_VENDOR_SITES

APPS.CHV_SCHEDULE_HEADERS_ALL_V is not referenced by any database object