eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: PSP.PSP_EFF_REPORT_DETAILS#

Object Details

Object Name:	PSP_EFF_REPORT_DETAILS#
Object Type:	VIEW
Owner:	PSP
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
EFFORT_REPORT_DETAIL_ID	NUMBER	(15)	Yes
EFFORT_REPORT_ID	NUMBER	(15)	Yes
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes
ASSIGNMENT_ID	NUMBER	(15)
ASSIGNMENT_NUMBER	VARCHAR2	(30)
GL_SUM_CRITERIA_SEGMENT_NAME	VARCHAR2	(2000)
GL_SEGMENT1	VARCHAR2	(25)
GL_SEGMENT2	VARCHAR2	(25)
GL_SEGMENT3	VARCHAR2	(25)
GL_SEGMENT4	VARCHAR2	(25)
GL_SEGMENT5	VARCHAR2	(25)
GL_SEGMENT6	VARCHAR2	(25)
GL_SEGMENT7	VARCHAR2	(25)
GL_SEGMENT8	VARCHAR2	(25)
GL_SEGMENT9	VARCHAR2	(25)
GL_SEGMENT10	VARCHAR2	(25)
GL_SEGMENT11	VARCHAR2	(25)
GL_SEGMENT12	VARCHAR2	(25)
GL_SEGMENT13	VARCHAR2	(25)
GL_SEGMENT14	VARCHAR2	(25)
GL_SEGMENT15	VARCHAR2	(25)
GL_SEGMENT16	VARCHAR2	(25)
GL_SEGMENT17	VARCHAR2	(25)
GL_SEGMENT18	VARCHAR2	(25)
GL_SEGMENT19	VARCHAR2	(25)
GL_SEGMENT20	VARCHAR2	(25)
GL_SEGMENT21	VARCHAR2	(25)
GL_SEGMENT22	VARCHAR2	(25)
GL_SEGMENT23	VARCHAR2	(25)
GL_SEGMENT24	VARCHAR2	(25)
GL_SEGMENT25	VARCHAR2	(25)
GL_SEGMENT26	VARCHAR2	(25)
GL_SEGMENT27	VARCHAR2	(25)
GL_SEGMENT28	VARCHAR2	(25)
GL_SEGMENT29	VARCHAR2	(25)
GL_SEGMENT30	VARCHAR2	(25)
PROJECT_ID	NUMBER	(15)
PROJECT_NUMBER	VARCHAR2	(25)
PROJECT_NAME	VARCHAR2	(30)
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)
EXP_ORG_NAME	VARCHAR2	(240)
EXPENDITURE_TYPE	VARCHAR2	(30)
TASK_ID	NUMBER	(15)
TASK_NUMBER	VARCHAR2	(25)
TASK_NAME	VARCHAR2	(30)
AWARD_ID	NUMBER	(15)
AWARD_NUMBER	VARCHAR2	(240)
AWARD_SHORT_NAME	VARCHAR2	(30)
ACTUAL_SALARY_AMT	NUMBER		Yes
PAYROLL_PERCENT	NUMBER		Yes
PROPOSED_SALARY_AMT	NUMBER
PROPOSED_EFFORT_PERCENT	NUMBER
COMMITTED_COST_SHARE	NUMBER
SCHEDULE_START_DATE	DATE
SCHEDULE_END_DATE	DATE
AME_TRANSACTION_ID	VARCHAR2	(50)
INVESTIGATOR_NAME	VARCHAR2	(240)
INVESTIGATOR_PERSON_ID	NUMBER	(15)
INVESTIGATOR_ORG_NAME	VARCHAR2	(240)
INVESTIGATOR_PRIMARY_ORG_ID	NUMBER	(15)
VALUE1	NUMBER
VALUE2	NUMBER
VALUE3	NUMBER
VALUE4	NUMBER
VALUE5	NUMBER
VALUE6	NUMBER
VALUE7	NUMBER
VALUE8	NUMBER
VALUE9	NUMBER
VALUE10	NUMBER
ATTRIBUTE1	VARCHAR2	(1000)
ATTRIBUTE2	VARCHAR2	(1000)
ATTRIBUTE3	VARCHAR2	(1000)
ATTRIBUTE4	VARCHAR2	(1000)
ATTRIBUTE5	VARCHAR2	(1000)
ATTRIBUTE6	VARCHAR2	(1000)
ATTRIBUTE7	VARCHAR2	(1000)
ATTRIBUTE8	VARCHAR2	(1000)
ATTRIBUTE9	VARCHAR2	(1000)
ATTRIBUTE10	VARCHAR2	(1000)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes
GROUPING_CATEGORY	VARCHAR2	(30)

Query Text

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


SELECT EFFORT_REPORT_DETAIL_ID
,      EFFORT_REPORT_ID
,      OBJECT_VERSION_NUMBER
,      ASSIGNMENT_ID
,      ASSIGNMENT_NUMBER
,      GL_SUM_CRITERIA_SEGMENT_NAME
,      GL_SEGMENT1
,      GL_SEGMENT2
,      GL_SEGMENT3
,      GL_SEGMENT4
,      GL_SEGMENT5
,      GL_SEGMENT6
,      GL_SEGMENT7
,      GL_SEGMENT8
,      GL_SEGMENT9
,      GL_SEGMENT10
,      GL_SEGMENT11
,      GL_SEGMENT12
,      GL_SEGMENT13
,      GL_SEGMENT14
,      GL_SEGMENT15
,      GL_SEGMENT16
,      GL_SEGMENT17
,      GL_SEGMENT18
,      GL_SEGMENT19
,      GL_SEGMENT20
,      GL_SEGMENT21
,      GL_SEGMENT22
,      GL_SEGMENT23
,      GL_SEGMENT24
,      GL_SEGMENT25
,      GL_SEGMENT26
,      GL_SEGMENT27
,      GL_SEGMENT28
,      GL_SEGMENT29
,      GL_SEGMENT30
,      PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      EXPENDITURE_ORGANIZATION_ID
,      EXP_ORG_NAME
,      EXPENDITURE_TYPE
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      AWARD_ID
,      AWARD_NUMBER
,      AWARD_SHORT_NAME
,      ACTUAL_SALARY_AMT
,      PAYROLL_PERCENT
,      PROPOSED_SALARY_AMT
,      PROPOSED_EFFORT_PERCENT
,      COMMITTED_COST_SHARE
,      SCHEDULE_START_DATE
,      SCHEDULE_END_DATE
,      AME_TRANSACTION_ID
,      INVESTIGATOR_NAME
,      INVESTIGATOR_PERSON_ID
,      INVESTIGATOR_ORG_NAME
,      INVESTIGATOR_PRIMARY_ORG_ID
,      VALUE1
,      VALUE2
,      VALUE3
,      VALUE4
,      VALUE5
,      VALUE6
,      VALUE7
,      VALUE8
,      VALUE9
,      VALUE10
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      GROUPING_CATEGORY
FROM PSP.PSP_EFF_REPORT_DETAILS#;

Dependencies

[top of page]

PSP.PSP_EFF_REPORT_DETAILS# references the following:

PSP: PSP_EFF_REPORT_DETAILS

PSP.PSP_EFF_REPORT_DETAILS# is referenced by following:

APPS: PSP_EFF_REPORT_DETAILS; PSP_EFF_REPORT_DETAILS_WHO