[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PSP_REPORT_DETAILS |
|---|---|
| Object Type: | TABLE |
| Owner: | PSP |
| FND Design Data: |  PSP.PSP_REPORT_DETAILS
|
| Subobject Name: | |
| Status: | VALID |
Contains detail level information for effort reports created before migrating to OA
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REPORT_DETAIL_ID | NUMBER | (15) | Yes | Report Detail Identifier |
| REQUEST_ID | NUMBER | (15) | Yes | Request Identifier |
| START_DATE | DATE | Yes | Start date | |
| END_DATE | DATE | Yes | End date | |
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Object Version Number | |
| TEMPLATE_ID | NUMBER | (15) | Yes | Effort report template identifier |
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Business Group Id |
| SET_OF_BOOKS_ID | NUMBER | (15) | Set of books id | |
| ATTRIBUTE1 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE2 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE3 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE4 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE5 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE6 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE7 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE8 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE9 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE10 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE11 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE12 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE13 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE14 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE15 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE16 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE17 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE18 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE19 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE20 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE21 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE22 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE23 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE24 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE25 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE26 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE27 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE28 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE29 | VARCHAR2 | (2000) | Stores additional attribute value | |
| ATTRIBUTE30 | VARCHAR2 | (2000) | Stores additional attribute value | |
| VALUE1 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE2 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE3 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE4 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE5 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE6 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE7 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE8 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE9 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE10 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE11 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE12 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE13 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE14 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE15 | VARCHAR2 | (240) | Stores Additional Number Value | |
| VALUE16 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE17 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE18 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE19 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE20 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE21 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE22 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE23 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE24 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE25 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE26 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE27 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE28 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE29 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| VALUE30 | VARCHAR2 | (2000) | Stores Additional Number Value | |
| LAST_UPDATE_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
| CREATION_DATE | DATE | Standard Who Column | ||
| CREATED_BY | NUMBER | (15) | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT REPORT_DETAIL_ID
, REQUEST_ID
, START_DATE
, END_DATE
, OBJECT_VERSION_NUMBER
, TEMPLATE_ID
, BUSINESS_GROUP_ID
, SET_OF_BOOKS_ID
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, VALUE1
, VALUE2
, VALUE3
, VALUE4
, VALUE5
, VALUE6
, VALUE7
, VALUE8
, VALUE9
, VALUE10
, VALUE11
, VALUE12
, VALUE13
, VALUE14
, VALUE15
, VALUE16
, VALUE17
, VALUE18
, VALUE19
, VALUE20
, VALUE21
, VALUE22
, VALUE23
, VALUE24
, VALUE25
, VALUE26
, VALUE27
, VALUE28
, VALUE29
, VALUE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM PSP.PSP_REPORT_DETAILS;
PSP.PSP_REPORT_DETAILS does not reference any database object
PSP.PSP_REPORT_DETAILS is referenced by following:
APPS
PSP_REPORT_DETAILS
PSP_REPORT_DETAILS_WHO
|
|
|
|