[Home] [Help] [Dependency Information]
Object Name: | PA_BUDGETARY_CONTROL_OPTIONS# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_TYPE | VARCHAR2 | (30) | ||
PROJECT_ID | NUMBER | (15) | ||
PROJECT_TYPE_ORG_ID | NUMBER | (15) | ||
BUDGET_TYPE_CODE | VARCHAR2 | (30) | Yes | |
BALANCE_TYPE | VARCHAR2 | (1) | ||
EXTERNAL_BUDGET_CODE | VARCHAR2 | (30) | ||
GL_BUDGET_VERSION_ID | NUMBER | (15) | ||
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
BDGT_CNTRL_FLAG | VARCHAR2 | (1) | Yes | |
AMOUNT_TYPE | VARCHAR2 | (15) | ||
BOUNDARY_CODE | VARCHAR2 | (15) | ||
FUND_CONTROL_LEVEL_PROJECT | VARCHAR2 | (1) | ||
FUND_CONTROL_LEVEL_TASK | VARCHAR2 | (1) | ||
FUND_CONTROL_LEVEL_RES_GRP | VARCHAR2 | (1) | ||
FUND_CONTROL_LEVEL_RES | VARCHAR2 | (1) | ||
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) | ||
YR_END_ROLLOVER_YEAR | NUMBER | |||
YR_END_ROLLOVER_AMOUNT | NUMBER | |||
YR_END_ROLLOVER_FLAG | VARCHAR2 | (1) | ||
YR_END_ROLLOVER_MESSAGE | VARCHAR2 | (200) | ||
REQUEST_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_TYPE
, PROJECT_ID
, PROJECT_TYPE_ORG_ID
, BUDGET_TYPE_CODE
, BALANCE_TYPE
, EXTERNAL_BUDGET_CODE
, GL_BUDGET_VERSION_ID
, ENCUMBRANCE_TYPE_ID
, BDGT_CNTRL_FLAG
, AMOUNT_TYPE
, BOUNDARY_CODE
, FUND_CONTROL_LEVEL_PROJECT
, FUND_CONTROL_LEVEL_TASK
, FUND_CONTROL_LEVEL_RES_GRP
, FUND_CONTROL_LEVEL_RES
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, YR_END_ROLLOVER_YEAR
, YR_END_ROLLOVER_AMOUNT
, YR_END_ROLLOVER_FLAG
, YR_END_ROLLOVER_MESSAGE
, REQUEST_ID
FROM PA.PA_BUDGETARY_CONTROL_OPTIONS#;
|
|
|