[Home] [Help] [Dependency Information]
Object Name: | PA_SUMMARY_PROJECT_FUNDINGS# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGREEMENT_ID | NUMBER | (15) | Yes | |
PROJECT_ID | NUMBER | (15) | Yes | |
TASK_ID | NUMBER | (15) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | Yes | ||
TOTAL_UNBASELINED_AMOUNT | NUMBER | (22) | Yes | |
TOTAL_BASELINED_AMOUNT | NUMBER | (22) | ||
TOTAL_ACCRUED_AMOUNT | NUMBER | (22) | ||
TOTAL_BILLED_AMOUNT | NUMBER | (22) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
REQUEST_ID | NUMBER | (15) | ||
FUNDING_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJECT_UNBASELINED_AMOUNT | NUMBER | (22) | ||
PROJECT_BASELINED_AMOUNT | NUMBER | (22) | ||
PROJECT_ACCRUED_AMOUNT | NUMBER | (22) | ||
PROJECT_BILLED_AMOUNT | NUMBER | (22) | ||
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJFUNC_UNBASELINED_AMOUNT | NUMBER | (22) | ||
PROJFUNC_BASELINED_AMOUNT | NUMBER | (22) | ||
PROJFUNC_ACCRUED_AMOUNT | NUMBER | (22) | ||
PROJFUNC_BILLED_AMOUNT | NUMBER | (22) | ||
INVPROC_CURRENCY_CODE | VARCHAR2 | (15) | ||
INVPROC_UNBASELINED_AMOUNT | NUMBER | (22) | ||
INVPROC_BASELINED_AMOUNT | NUMBER | (22) | ||
INVPROC_BILLED_AMOUNT | NUMBER | (22) | ||
REVPROC_CURRENCY_CODE | VARCHAR2 | (15) | ||
REVPROC_UNBASELINED_AMOUNT | NUMBER | (22) | ||
REVPROC_BASELINED_AMOUNT | NUMBER | (22) | ||
REVPROC_ACCRUED_AMOUNT | NUMBER | (22) | ||
PROJFUNC_REALIZED_GAINS_AMT | NUMBER | |||
PROJFUNC_REALIZED_LOSSES_AMT | NUMBER | |||
REVAL_REJECTION_CODE | VARCHAR2 | (30) | ||
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
GLOBAL_ATTRIBUTE1 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE2 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE3 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE4 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE5 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE6 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE7 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE8 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE9 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE10 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE11 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE12 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE13 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE14 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE15 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE16 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE17 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE18 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE19 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE20 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE21 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE22 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE23 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE24 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE25 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE26 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE27 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE28 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE29 | VARCHAR2 | (240) | ||
GLOBAL_ATTRIBUTE30 | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT AGREEMENT_ID
, PROJECT_ID
, TASK_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, TOTAL_UNBASELINED_AMOUNT
, TOTAL_BASELINED_AMOUNT
, TOTAL_ACCRUED_AMOUNT
, TOTAL_BILLED_AMOUNT
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, FUNDING_CURRENCY_CODE
, PROJECT_CURRENCY_CODE
, PROJECT_UNBASELINED_AMOUNT
, PROJECT_BASELINED_AMOUNT
, PROJECT_ACCRUED_AMOUNT
, PROJECT_BILLED_AMOUNT
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_UNBASELINED_AMOUNT
, PROJFUNC_BASELINED_AMOUNT
, PROJFUNC_ACCRUED_AMOUNT
, PROJFUNC_BILLED_AMOUNT
, INVPROC_CURRENCY_CODE
, INVPROC_UNBASELINED_AMOUNT
, INVPROC_BASELINED_AMOUNT
, INVPROC_BILLED_AMOUNT
, REVPROC_CURRENCY_CODE
, REVPROC_UNBASELINED_AMOUNT
, REVPROC_BASELINED_AMOUNT
, REVPROC_ACCRUED_AMOUNT
, PROJFUNC_REALIZED_GAINS_AMT
, PROJFUNC_REALIZED_LOSSES_AMT
, REVAL_REJECTION_CODE
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE21
, GLOBAL_ATTRIBUTE22
, GLOBAL_ATTRIBUTE23
, GLOBAL_ATTRIBUTE24
, GLOBAL_ATTRIBUTE25
, GLOBAL_ATTRIBUTE26
, GLOBAL_ATTRIBUTE27
, GLOBAL_ATTRIBUTE28
, GLOBAL_ATTRIBUTE29
, GLOBAL_ATTRIBUTE30
FROM PA.PA_SUMMARY_PROJECT_FUNDINGS#;
|
|
|