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

VIEW: APPS.CHV_SCHEDULE_ITEMS_V

Object Details
Object Name: CHV_SCHEDULE_ITEMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCHV.CHV_SCHEDULE_ITEMS_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
SCHEDULE_ITEM_ID NUMBER
Yes Schedule item unique identifier
SHIP_TO_ORGANIZATION_ID NUMBER
Yes Ship-to organization unique identifier
SHIP_TO_ORGANIZATION_CODE VARCHAR2 (3)
Ship-to organization code
ITEM_ID NUMBER
Yes Item unique identifier
ITEM_NUMBER VARCHAR2 (40)
Item number
ITEM_DESCRIPTION VARCHAR2 (240)
Item description
LEAD_TIME NUMBER

Lead time
MIN_ORDER_QUANTITY NUMBER

Minimum order quantity for a quotation line
MAX_ORDER_QUANTITY NUMBER

Maximum order quantity for a quotation line
FIXED_LOT_MULTIPLIER NUMBER

Fixed lot size multiplier
ITEM_PLANNING_METHOD VARCHAR2 (25)
Item planning method when schedule was built
ENABLE_AUTHORIZATIONS_FLAG VARCHAR2 (1)
Authorizations enabled
SCHEDULER_ID NUMBER

Scheduler
SCHEDULER_NAME VARCHAR2 (240)
Employee who created schedule
BUYER_ID NUMBER (9)
Buyer unique identifier
BUYER_NAME VARCHAR2 (240)
Buyer name
PO_HEADER_ID NUMBER

Document header unique identifier
OLDEST_AGREEMENT_NUM VARCHAR2 (20)
Oldest open supply agreement document number
EFFECTIVE_TO_DATE DATE

Effective date of oldest open supply agreement
PO_LINE_ID NUMBER

Document line unique identifier
OLDEST_AGREEMENT_LINE_NUM NUMBER

Oldest open supply agreement line number
REBUILD_FLAG VARCHAR2 (1)
Item marked for rebuild
ITEM_CONFIRM_STATUS VARCHAR2 (25)
Item confirmation status
ITEM_CONFIRM_STATUS_NAME VARCHAR2 (80)
Schedule item confirmation status
STARTING_CUM_QUANTITY NUMBER

CUM at schedule generation in purchasing uom
STARTING_AUTH_QUANTITY NUMBER

Past due quantity plus CUM to-date in purchasing uom
STARTING_CUM_QTY_PRIMARY NUMBER

CUM at schedule generation in primary uom
STARTING_AUTH_QTY_PRIMARY NUMBER

Past due quantity plus CUM period to-date in primary uom
PURCHASING_UNIT_OF_MEASURE VARCHAR2 (25)
Supplier unit of measure
PRIMARY_UNIT_OF_MEASURE VARCHAR2 (25)
Primary stocking unit of measure for the item in the current organization
LAST_RECEIPT_TRANSACTION_ID NUMBER

Last receipt transaction at schedule generation
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
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
ITEM_PURGE_STATUS VARCHAR2 (25)
ORG_ID NUMBER

Query Text

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


SELECT ROW_ID
,      SCHEDULE_ID
,      SCHEDULE_ITEM_ID
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_ORGANIZATION_CODE
,      ITEM_ID
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      LEAD_TIME
,      MIN_ORDER_QUANTITY
,      MAX_ORDER_QUANTITY
,      FIXED_LOT_MULTIPLIER
,      ITEM_PLANNING_METHOD
,      ENABLE_AUTHORIZATIONS_FLAG
,      SCHEDULER_ID
,      SCHEDULER_NAME
,      BUYER_ID
,      BUYER_NAME
,      PO_HEADER_ID
,      OLDEST_AGREEMENT_NUM
,      EFFECTIVE_TO_DATE
,      PO_LINE_ID
,      OLDEST_AGREEMENT_LINE_NUM
,      REBUILD_FLAG
,      ITEM_CONFIRM_STATUS
,      ITEM_CONFIRM_STATUS_NAME
,      STARTING_CUM_QUANTITY
,      STARTING_AUTH_QUANTITY
,      STARTING_CUM_QTY_PRIMARY
,      STARTING_AUTH_QTY_PRIMARY
,      PURCHASING_UNIT_OF_MEASURE
,      PRIMARY_UNIT_OF_MEASURE
,      LAST_RECEIPT_TRANSACTION_ID
,      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
,      ITEM_PURGE_STATUS
,      ORG_ID
FROM APPS.CHV_SCHEDULE_ITEMS_V;

Dependencies

[top of page]

APPS.CHV_SCHEDULE_ITEMS_V references the following:

SchemaAPPS
PL/SQL PackageCHV_INQ_SV - show dependent code
SynonymCHV_SCHEDULE_HEADERS
SynonymCHV_SCHEDULE_ITEMS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_SYSTEM_ITEMS_KFV
ViewPER_PEOPLE_F
SynonymPO_ASL_ATTRIBUTES
SynonymPO_HEADERS
SynonymPO_LINES_ALL
ViewPO_LOOKUP_CODES

APPS.CHV_SCHEDULE_ITEMS_V is not referenced by any database object