[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CHV_HORIZONTAL_SCHEDULES |
|---|---|
| Object Type: | TABLE |
| Owner: | PO |
| FND Design Data: |  CHV.CHV_HORIZONTAL_SCHEDULES
|
| Subobject Name: | |
| Status: | VALID |
CHV_HORIZONTAL_SCHEDULES stores the horizontal, bucketed
representation of schedule item orders. Designed for direct selection
into the Workbench and reports.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| CHV_HORIZONTAL_SCHEDULES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 SCHEDULE_ID
|
| CHV_HORIZONTAL_SCHEDULES_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SCHEDULE_ITEM_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SCHEDULE_ID | NUMBER | Yes | Schedule header unique identifier | |
| SCHEDULE_ITEM_ID | NUMBER | Yes | Schedule item unique identifier | |
| ROW_SELECT_ORDER | NUMBER | Yes | Sequence order for display: BUCKET_DESCRIPTOR, BUCKET_START_DATE, RELEASE_QUANTITY, FORECAST_QUANTITY, TOTAL_QUANTITY, CUM_QUANTITY, BUCKET_END_DATE | |
| ROW_TYPE | VARCHAR2 | (25) | Yes | Record type options: RELEASE_QUANTITY, FORECAST_QUANTITY, CUM_QUANTITY, TOTAL_QUANTITY, BUCKET_DESCRIPTOR, BUCKET_START_DATE, BUCKET_END_DATE |
| 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 | |
| COLUMN1 | VARCHAR2 | (25) | Bucket value | |
| COLUMN2 | VARCHAR2 | (25) | Bucket value | |
| COLUMN3 | VARCHAR2 | (25) | Bucket value | |
| COLUMN4 | VARCHAR2 | (25) | Bucket value | |
| COLUMN5 | VARCHAR2 | (25) | Bucket value | |
| COLUMN6 | VARCHAR2 | (25) | Bucket value | |
| COLUMN7 | VARCHAR2 | (25) | Bucket value | |
| COLUMN8 | VARCHAR2 | (25) | Bucket value | |
| COLUMN9 | VARCHAR2 | (25) | Bucket value | |
| COLUMN10 | VARCHAR2 | (25) | Bucket value | |
| COLUMN11 | VARCHAR2 | (25) | Bucket value | |
| COLUMN12 | VARCHAR2 | (25) | Bucket value | |
| COLUMN13 | VARCHAR2 | (25) | Bucket value | |
| COLUMN14 | VARCHAR2 | (25) | Bucket value | |
| COLUMN15 | VARCHAR2 | (25) | Bucket value | |
| COLUMN16 | VARCHAR2 | (25) | Bucket value | |
| COLUMN17 | VARCHAR2 | (25) | Bucket value | |
| COLUMN18 | VARCHAR2 | (25) | Bucket value | |
| COLUMN19 | VARCHAR2 | (25) | Bucket value | |
| COLUMN20 | VARCHAR2 | (25) | Bucket value | |
| COLUMN21 | VARCHAR2 | (25) | Bucket value | |
| COLUMN22 | VARCHAR2 | (25) | Bucket value | |
| COLUMN23 | VARCHAR2 | (25) | Bucket value | |
| COLUMN24 | VARCHAR2 | (25) | Bucket value | |
| COLUMN25 | VARCHAR2 | (25) | Bucket value | |
| COLUMN26 | VARCHAR2 | (25) | Bucket value | |
| COLUMN27 | VARCHAR2 | (25) | Bucket value | |
| COLUMN28 | VARCHAR2 | (25) | Bucket value | |
| COLUMN29 | VARCHAR2 | (25) | Bucket value | |
| COLUMN30 | VARCHAR2 | (25) | Bucket value | |
| COLUMN31 | VARCHAR2 | (25) | Bucket value | |
| COLUMN32 | VARCHAR2 | (25) | Bucket value | |
| COLUMN33 | VARCHAR2 | (25) | Bucket value | |
| COLUMN34 | VARCHAR2 | (25) | Bucket value | |
| COLUMN35 | VARCHAR2 | (25) | Bucket value | |
| COLUMN36 | VARCHAR2 | (25) | Bucket value | |
| COLUMN37 | VARCHAR2 | (25) | Bucket value | |
| COLUMN38 | VARCHAR2 | (25) | Bucket value | |
| COLUMN39 | VARCHAR2 | (25) | Bucket value | |
| COLUMN40 | VARCHAR2 | (25) | Bucket value | |
| COLUMN41 | VARCHAR2 | (25) | Bucket value | |
| COLUMN42 | VARCHAR2 | (25) | Bucket value | |
| COLUMN43 | VARCHAR2 | (25) | Bucket value | |
| COLUMN44 | VARCHAR2 | (25) | Bucket value | |
| COLUMN45 | VARCHAR2 | (25) | Bucket value | |
| COLUMN46 | VARCHAR2 | (25) | Bucket value | |
| COLUMN47 | VARCHAR2 | (25) | Bucket value | |
| COLUMN48 | VARCHAR2 | (25) | Bucket value | |
| COLUMN49 | VARCHAR2 | (25) | Bucket value | |
| COLUMN50 | VARCHAR2 | (25) | Bucket value | |
| COLUMN51 | VARCHAR2 | (25) | Bucket value | |
| COLUMN52 | VARCHAR2 | (25) | Bucket value | |
| COLUMN53 | VARCHAR2 | (25) | Bucket value | |
| COLUMN54 | VARCHAR2 | (25) | Bucket value | |
| COLUMN55 | VARCHAR2 | (25) | Bucket value | |
| COLUMN56 | VARCHAR2 | (25) | Bucket value | |
| COLUMN57 | VARCHAR2 | (25) | Bucket value | |
| COLUMN58 | VARCHAR2 | (25) | Bucket value | |
| COLUMN59 | VARCHAR2 | (25) | Bucket value | |
| COLUMN60 | VARCHAR2 | (25) | Bucket value | |
| 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 |
Cut, paste (and edit) the following text to query this object:
SELECT SCHEDULE_ID
, SCHEDULE_ITEM_ID
, ROW_SELECT_ORDER
, ROW_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, COLUMN1
, COLUMN2
, COLUMN3
, COLUMN4
, COLUMN5
, COLUMN6
, COLUMN7
, COLUMN8
, COLUMN9
, COLUMN10
, COLUMN11
, COLUMN12
, COLUMN13
, COLUMN14
, COLUMN15
, COLUMN16
, COLUMN17
, COLUMN18
, COLUMN19
, COLUMN20
, COLUMN21
, COLUMN22
, COLUMN23
, COLUMN24
, COLUMN25
, COLUMN26
, COLUMN27
, COLUMN28
, COLUMN29
, COLUMN30
, COLUMN31
, COLUMN32
, COLUMN33
, COLUMN34
, COLUMN35
, COLUMN36
, COLUMN37
, COLUMN38
, COLUMN39
, COLUMN40
, COLUMN41
, COLUMN42
, COLUMN43
, COLUMN44
, COLUMN45
, COLUMN46
, COLUMN47
, COLUMN48
, COLUMN49
, COLUMN50
, COLUMN51
, COLUMN52
, COLUMN53
, COLUMN54
, COLUMN55
, COLUMN56
, COLUMN57
, COLUMN58
, COLUMN59
, COLUMN60
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM PO.CHV_HORIZONTAL_SCHEDULES;
PO.CHV_HORIZONTAL_SCHEDULES does not reference any database object
PO.CHV_HORIZONTAL_SCHEDULES is referenced by following:
PO
CHV_HORIZONTAL_SCHEDULES#
|
|
|
|