eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.CHV_SCHEDULE_HEADERS_V

Object Details

Object Name:	CHV_SCHEDULE_HEADERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CHV.CHV_SCHEDULE_HEADERS_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
ROW_ID	ROWID	(10)		Rowid
SCHEDULE_ID	NUMBER		Yes	Schedule unique identifier
VENDOR_ID	NUMBER		Yes	Supplier unique identifier
VENDOR_NAME	VARCHAR2	(240)		Vendor name
HOLD_FLAG	VARCHAR2	(1)		Indicates whether the vendor is on purchase hold or not
VENDOR_SITE_ID	NUMBER		Yes	Supplier site unique identifier
VENDOR_SITE_CODE	VARCHAR2	(15)		Site code name
BATCH_ID	NUMBER		Yes	Batch unique identifier
SCHEDULE_TYPE	VARCHAR2	(25)	Yes	Planning or Shipping schedule
SCHEDULE_TYPE_NAME	VARCHAR2	(80)		Schedule type name
SCHEDULE_SUBTYPE	VARCHAR2	(25)	Yes	Type of planning or shipping schedule
SCHEDULE_SUBTYPE_NAME	VARCHAR2	(80)		Schedule subtype name
SCHEDULE_NUM	VARCHAR2	(20)		Schedule number
SCHEDULE_REVISION	NUMBER			Schedule revision
SCHEDULE_HORIZON_START	DATE		Yes	Schedule horizon start date
SCHEDULE_HORIZON_END	DATE		Yes	Schedule horizon end date
SCHEDULE_OWNER_ID	NUMBER		Yes	Employee who created schedule
SCHEDULE_OWNER_NAME	VARCHAR2	(240)		Schedule owner (employee) name
BUCKET_PATTERN_ID	NUMBER		Yes	Bucket pattern unique identifier
BUCKET_PATTERN_NAME	VARCHAR2	(25)	Yes	Bucket pattern name
BUCKET_PATTERN_DESCRIPTION	VARCHAR2	(80)		Bucket pattern description
SHIP_TO_ORGANIZATION_ID	NUMBER			Ship-to organization unique identifier
SHIP_TO_ORGANIZATION_CODE	VARCHAR2	(3)		Ship-to organization code
CONFIRM_DATE	DATE			Confirmed date
PRINT_COUNT	NUMBER			Print count
LAST_PRINT_DATE	DATE			Last print date
EDI_COUNT	NUMBER			EDI count
LAST_EDI_DATE	DATE			Last edi date
MPS_SCHEDULE_DESIGNATOR	VARCHAR2	(10)		MPS plan name
MRP_COMPILE_DESIGNATOR	VARCHAR2	(10)		MRP plan name
DRP_COMPILE_DESIGNATOR	VARCHAR2	(10)		DRP plan name
SCHEDULE_STATUS	VARCHAR2	(25)		Confimed status
SCHEDULE_STATUS_NAME	VARCHAR2	(80)		Status of the schedule
INQUIRY_FLAG	VARCHAR2	(1)		Simiulation schedule
INCLUDE_FUTURE_RELEASE_FLAG	VARCHAR2	(1)		Indicates if future releases should be included in the schedule
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
ORG_ID	NUMBER

Query Text

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


SELECT ROW_ID
,      SCHEDULE_ID
,      VENDOR_ID
,      VENDOR_NAME
,      HOLD_FLAG
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      BATCH_ID
,      SCHEDULE_TYPE
,      SCHEDULE_TYPE_NAME
,      SCHEDULE_SUBTYPE
,      SCHEDULE_SUBTYPE_NAME
,      SCHEDULE_NUM
,      SCHEDULE_REVISION
,      SCHEDULE_HORIZON_START
,      SCHEDULE_HORIZON_END
,      SCHEDULE_OWNER_ID
,      SCHEDULE_OWNER_NAME
,      BUCKET_PATTERN_ID
,      BUCKET_PATTERN_NAME
,      BUCKET_PATTERN_DESCRIPTION
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_ORGANIZATION_CODE
,      CONFIRM_DATE
,      PRINT_COUNT
,      LAST_PRINT_DATE
,      EDI_COUNT
,      LAST_EDI_DATE
,      MPS_SCHEDULE_DESIGNATOR
,      MRP_COMPILE_DESIGNATOR
,      DRP_COMPILE_DESIGNATOR
,      SCHEDULE_STATUS
,      SCHEDULE_STATUS_NAME
,      INQUIRY_FLAG
,      INCLUDE_FUTURE_RELEASE_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
FROM APPS.CHV_SCHEDULE_HEADERS_V;

Dependencies

[top of page]

APPS.CHV_SCHEDULE_HEADERS_V references the following:

APPS: CHV_BUCKET_PATTERNS; CHV_SCHEDULE_HEADERS; FND_GLOBAL - show dependent code; FND_PROFILE - show dependent code; HR_EMPLOYEES; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; MTL_PARAMETERS; PO_LOOKUP_CODES; PO_VENDORS; PO_VENDOR_SITES

APPS.CHV_SCHEDULE_HEADERS_V is not referenced by any database object