[Home] [Help] [Dependency Information]
Object Name: | PA_PROJECT_FUNDINGS# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PA_PROJECT_FUNDINGS_PROJECT_ID | NUMBER | (15) | ||
PROJECT_FUNDING_ID | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
AGREEMENT_ID | NUMBER | (15) | Yes | |
PROJECT_ID | NUMBER | (15) | Yes | |
TASK_ID | NUMBER | (15) | ||
BUDGET_TYPE_CODE | VARCHAR2 | (30) | Yes | |
ALLOCATED_AMOUNT | NUMBER | (22) | Yes | |
DATE_ALLOCATED | DATE | Yes | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
PM_FUNDING_REFERENCE | VARCHAR2 | (25) | ||
PM_PRODUCT_CODE | VARCHAR2 | (25) | ||
FUNDING_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJECT_RATE_TYPE | VARCHAR2 | (30) | ||
PROJECT_RATE_DATE | DATE | |||
PROJECT_EXCHANGE_RATE | NUMBER | |||
PROJECT_ALLOCATED_AMOUNT | NUMBER | (22) | ||
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJFUNC_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_RATE_DATE | DATE | |||
PROJFUNC_EXCHANGE_RATE | NUMBER | |||
PROJFUNC_ALLOCATED_AMOUNT | NUMBER | (22) | ||
INVPROC_CURRENCY_CODE | VARCHAR2 | (15) | ||
INVPROC_RATE_TYPE | VARCHAR2 | (30) | ||
INVPROC_RATE_DATE | DATE | |||
INVPROC_EXCHANGE_RATE | NUMBER | |||
INVPROC_ALLOCATED_AMOUNT | NUMBER | (22) | ||
REVPROC_CURRENCY_CODE | VARCHAR2 | (15) | ||
REVPROC_RATE_TYPE | VARCHAR2 | (30) | ||
REVPROC_RATE_DATE | DATE | |||
REVPROC_EXCHANGE_RATE | NUMBER | |||
REVPROC_ALLOCATED_AMOUNT | NUMBER | (22) | ||
FUNDING_CATEGORY | VARCHAR2 | (30) | ||
PJI_SUMMARIZED_FLAG | VARCHAR2 | (1) | ||
REVALUATION_THROUGH_DATE | DATE | |||
REVALUATION_RATE_DATE | DATE | |||
REVALUATION_PROJFUNC_RATE_TYPE | VARCHAR2 | (30) | ||
REVALUATION_PROJFUNC_RATE | NUMBER | |||
REVALUATION_INVPROC_RATE_TYPE | VARCHAR2 | (30) | ||
REVALUATION_INVPROC_RATE | NUMBER | |||
FUNDING_INV_APPLIED_AMOUNT | NUMBER | |||
FUNDING_INV_DUE_AMOUNT | NUMBER | |||
FUNDING_BACKLOG_AMOUNT | NUMBER | |||
PROJFUNC_REALIZED_GAINS_AMT | NUMBER | |||
PROJFUNC_REALIZED_LOSSES_AMT | NUMBER | |||
PROJFUNC_INV_APPLIED_AMOUNT | NUMBER | |||
PROJFUNC_INV_DUE_AMOUNT | NUMBER | |||
PROJFUNC_BACKLOG_AMOUNT | NUMBER | |||
NON_UPDATEABLE_FLAG | VARCHAR2 | (1) | ||
INVPROC_BACKLOG_AMOUNT | NUMBER | |||
FUNDING_REVAL_AMOUNT | NUMBER | |||
PROJFUNC_REVAL_AMOUNT | NUMBER | |||
PROJFUNC_REVALUED_AMOUNT | NUMBER | |||
INVPROC_REVAL_AMOUNT | NUMBER | |||
INVPROC_REVALUED_AMOUNT | NUMBER | |||
FUNDING_REVALUATION_FACTOR | NUMBER | |||
REQUEST_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
CI_ID | NUMBER | (15) | ||
SUBMIT_BASELINE_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT PA_PROJECT_FUNDINGS_PROJECT_ID
, PROJECT_FUNDING_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, AGREEMENT_ID
, PROJECT_ID
, TASK_ID
, BUDGET_TYPE_CODE
, ALLOCATED_AMOUNT
, DATE_ALLOCATED
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, PM_FUNDING_REFERENCE
, PM_PRODUCT_CODE
, FUNDING_CURRENCY_CODE
, PROJECT_CURRENCY_CODE
, PROJECT_RATE_TYPE
, PROJECT_RATE_DATE
, PROJECT_EXCHANGE_RATE
, PROJECT_ALLOCATED_AMOUNT
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_RATE_TYPE
, PROJFUNC_RATE_DATE
, PROJFUNC_EXCHANGE_RATE
, PROJFUNC_ALLOCATED_AMOUNT
, INVPROC_CURRENCY_CODE
, INVPROC_RATE_TYPE
, INVPROC_RATE_DATE
, INVPROC_EXCHANGE_RATE
, INVPROC_ALLOCATED_AMOUNT
, REVPROC_CURRENCY_CODE
, REVPROC_RATE_TYPE
, REVPROC_RATE_DATE
, REVPROC_EXCHANGE_RATE
, REVPROC_ALLOCATED_AMOUNT
, FUNDING_CATEGORY
, PJI_SUMMARIZED_FLAG
, REVALUATION_THROUGH_DATE
, REVALUATION_RATE_DATE
, REVALUATION_PROJFUNC_RATE_TYPE
, REVALUATION_PROJFUNC_RATE
, REVALUATION_INVPROC_RATE_TYPE
, REVALUATION_INVPROC_RATE
, FUNDING_INV_APPLIED_AMOUNT
, FUNDING_INV_DUE_AMOUNT
, FUNDING_BACKLOG_AMOUNT
, PROJFUNC_REALIZED_GAINS_AMT
, PROJFUNC_REALIZED_LOSSES_AMT
, PROJFUNC_INV_APPLIED_AMOUNT
, PROJFUNC_INV_DUE_AMOUNT
, PROJFUNC_BACKLOG_AMOUNT
, NON_UPDATEABLE_FLAG
, INVPROC_BACKLOG_AMOUNT
, FUNDING_REVAL_AMOUNT
, PROJFUNC_REVAL_AMOUNT
, PROJFUNC_REVALUED_AMOUNT
, INVPROC_REVAL_AMOUNT
, INVPROC_REVALUED_AMOUNT
, FUNDING_REVALUATION_FACTOR
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CI_ID
, SUBMIT_BASELINE_FLAG
FROM PA.PA_PROJECT_FUNDINGS#;
|
|
|