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

VIEW: APPS.POS_CHV_SCHEDULE_ITEMS_V

Object Details
Object Name: POS_CHV_SCHEDULE_ITEMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POS_CHV_SCHEDULE_ITEMS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


POS_CHV_SCHEDULE_ITEMS_V is one of the views used to select schedule related info


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier
SCHEDULE_ID NUMBER
Yes Schedule Identifier
SCHEDULE_ITEM_ID NUMBER
Yes Schedule Item Identifier
SCHEDULE_REVISION NUMBER

Schedule Revision
SHIP_TO_ORGANIZATION_ID NUMBER
Yes Ship-To Organization Identifier
SHIP_TO_ORGANIZATION_CODE VARCHAR2 (3)
Ship-To Organization Code
SHIP_TO_ORGANIZATION_NAME VARCHAR2 (240)
Ship-To Organization Name
ITEM_ID NUMBER
Yes Item 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
MAX_ORDER_QUANTITY NUMBER

Maximum Order Quantity
FIXED_LOT_MULTIPLIER NUMBER

Fixed Lot Multiplier
ITEM_PLANNING_METHOD VARCHAR2 (25)
Item Planning Method
ENABLE_AUTHORIZATIONS_FLAG VARCHAR2 (1)
Enable Authorization Flag
SCHEDULER_ID NUMBER

Scheduler Identifier
SCHEDULER_NAME VARCHAR2 (240)
Scheduler Name
BUYER_ID NUMBER (9)
Buyer Identifier
BUYER_NAME VARCHAR2 (240)
Buyer Name
PO_HEADER_ID NUMBER

PO Header Identifier
OLDEST_AGREEMENT_NUM VARCHAR2 (20)
Oldest Agreement Number
EFFECTIVE_TO_DATE DATE

Effective-To Date
PO_LINE_ID NUMBER

PO Line Identifier
OLDEST_AGREEMENT_LINE_NUM NUMBER

Oldest Agreement Line Number
REBUILD_FLAG VARCHAR2 (1)
Rebuild Flag
ITEM_CONFIRM_STATUS VARCHAR2 (25)
Item Confirm Status
ITEM_CONFIRM_STATUS_NAME VARCHAR2 (80)
Item Confirm Status Name
STARTING_CUM_QUANTITY NUMBER

Starting Cumulative Quantity
STARTING_AUTH_QUANTITY NUMBER

Starting Auth Quantity
STARTING_CUM_QTY_PRIMARY NUMBER

Staring Cumulative Primary Quantity
STARTING_AUTH_QTY_PRIMARY NUMBER

Staring Auth Primary Quantity
PURCHASING_UNIT_OF_MEASURE VARCHAR2 (25)
Purchasing Unit of Measure
PRIMARY_UNIT_OF_MEASURE VARCHAR2 (25)
Primary Unit of Measure
LAST_RECEIPT_TRANSACTION_ID NUMBER

Last Receipt Transaction Identifier
RECEIPT_DATE DATE

Receipt Date
RECEIPT_QUANTITY NUMBER

Receipt Quantity
RECEIPT_NUM VARCHAR2 (30)
Receipt Number
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
flexfield 1
ATTRIBUTE2 VARCHAR2 (150)
flexfield 2
ATTRIBUTE3 VARCHAR2 (150)
flexfield 3
ATTRIBUTE4 VARCHAR2 (150)
flexfield 4
ATTRIBUTE5 VARCHAR2 (150)
flexfield 5
ATTRIBUTE6 VARCHAR2 (150)
flexfield 6
ATTRIBUTE7 VARCHAR2 (150)
flexfield 7
ATTRIBUTE8 VARCHAR2 (150)
flexfield 8
ATTRIBUTE9 VARCHAR2 (150)
flexfield 9
ATTRIBUTE10 VARCHAR2 (150)
flexfield 10
ATTRIBUTE11 VARCHAR2 (150)
flexfield 11
ATTRIBUTE12 VARCHAR2 (150)
flexfield 12
ATTRIBUTE13 VARCHAR2 (150)
flexfield 13
ATTRIBUTE14 VARCHAR2 (150)
flexfield 14
ATTRIBUTE15 VARCHAR2 (150)
flexfield 15
LAST_UPDATE_DATE DATE
Yes Last Update Date
LAST_UPDATED_BY NUMBER
Yes Last Updated By
CREATION_DATE DATE
Yes Creation Date
CREATED_BY NUMBER
Yes Created By
LAST_UPDATE_LOGIN NUMBER

Last Update Login
REQUEST_ID NUMBER

Request Identifier
PROGRAM_APPLICATION_ID NUMBER

Program Application Identifier
PROGRAM_ID NUMBER

Progarm Identifier
PROGRAM_UPDATE_DATE DATE

Progarm Update Date
ITEM_PURGE_STATUS VARCHAR2 (25)
Item Purge Status
DOCUMENT_TYPE_DSP VARCHAR2 (80)
Document Type DSP
VENDOR_PRODUCT_NUM VARCHAR2 (25)
Vendor Product Number
SHIPMENT_HEADER_ID NUMBER

Shipment Header Identifier
SCHEDULE_NUM VARCHAR2 (20)
Schedule Number
Query Text

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


SELECT ROW_ID
,      SCHEDULE_ID
,      SCHEDULE_ITEM_ID
,      SCHEDULE_REVISION
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_ORGANIZATION_CODE
,      SHIP_TO_ORGANIZATION_NAME
,      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
,      RECEIPT_DATE
,      RECEIPT_QUANTITY
,      RECEIPT_NUM
,      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
,      DOCUMENT_TYPE_DSP
,      VENDOR_PRODUCT_NUM
,      SHIPMENT_HEADER_ID
,      SCHEDULE_NUM
FROM APPS.POS_CHV_SCHEDULE_ITEMS_V;

Dependencies

[top of page]

APPS.POS_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_SECURITY - show dependent code
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_SYSTEM_ITEMS_KFV
ViewORG_ORGANIZATION_DEFINITIONS
SynonymPER_ALL_PEOPLE_F
SynonymPO_APPROVED_SUPPLIER_LIST
SynonymPO_ASL_ATTRIBUTES
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
ViewPO_LOOKUP_CODES
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_TRANSACTIONS

APPS.POS_CHV_SCHEDULE_ITEMS_V is not referenced by any database object