[Home] [Help] [Dependency Information]
Object Name: | POS_PLAN_SCHEDULE_HEADERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Used to select schedule and vendor info for planning schedules.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier | |
SCHEDULE_ID | NUMBER | Yes | Schedule Identifier | |
VENDOR_ID | NUMBER | Yes | Vendor Identifier | |
VENDOR_NAME | VARCHAR2 | (240) | Vendor Name | |
VENDOR_NUMBER | VARCHAR2 | (30) | Yes | Vendor Number |
HOLD_FLAG | VARCHAR2 | (1) | Hold Flag | |
VENDOR_SITE_ID | NUMBER | Yes | Vendor Site Identifier | |
VENDOR_SITE_CODE | VARCHAR2 | (15) | Yes | Vendor Site Code |
BATCH_ID | NUMBER | Yes | Batch Identifier | |
SCHEDULE_TYPE | VARCHAR2 | (25) | Yes | Schedule Type |
SCHEDULE_TYPE_NAME | VARCHAR2 | (80) | Schedule Type Name | |
SCHEDULE_SUBTYPE | VARCHAR2 | (25) | Yes | Schedule sub_type |
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 | |
SCHEDULE_HORIZON_END | DATE | Yes | Schedule Horizon End | |
SCHEDULE_OWNER_ID | NUMBER | Yes | Schedule Owner Identifier | |
SCHEDULE_OWNER_NAME | VARCHAR2 | (240) | Schedule Owner Name | |
BUCKET_PATTERN_ID | NUMBER | Yes | Bucket Pattern 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 Identifier | ||
SHIP_TO_ORGANIZATION_CODE | VARCHAR2 | (3) | Ship-To Organization Code | |
SHIP_TO_ORGANIZATION_NAME | VARCHAR2 | (240) | Ship-To Organization Name | |
CONFIRM_DATE | DATE | Confirm 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 Schedule Designator | |
MRP_COMPILE_DESIGNATOR | VARCHAR2 | (10) | MRP Compile Designator | |
DRP_COMPILE_DESIGNATOR | VARCHAR2 | (10) | DRP Compile Designator | |
SCHEDULE_STATUS | VARCHAR2 | (25) | Schedule Status | |
SCHEDULE_STATUS_NAME | VARCHAR2 | (80) | Schedule Status Name | |
INQUIRY_FLAG | VARCHAR2 | (1) | Inquiry Flag | |
INCLUDE_FUTURE_RELEASE_FLAG | VARCHAR2 | (1) | Include Future Release Flag | |
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 | Program Identifier | ||
PROGRAM_UPDATE_DATE | DATE | Program Update Date |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, SCHEDULE_ID
, VENDOR_ID
, VENDOR_NAME
, VENDOR_NUMBER
, 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
, SHIP_TO_ORGANIZATION_NAME
, 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
FROM APPS.POS_PLAN_SCHEDULE_HEADERS_V;
APPS.POS_PLAN_SCHEDULE_HEADERS_V is not referenced by any database object
|
|
|