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]

TABLE: PA.PA_BUDGETARY_CONTROL_OPTIONS

Object Details

Object Name:	PA_BUDGETARY_CONTROL_OPTIONS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_BUDGETARY_CONTROL_OPTIONS
Subobject Name:
Status:	VALID

pa_budgetary_control_options stores all the default budgetary control levels and time intervals

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_BDGTRY_CONTROL_OPTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJECT_ID BUDGET_TYPE_CODE PROJECT_TYPE PROJECT_TYPE_ORG_ID
PA_BDGTRY_CONTROL_OPTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXTERNAL_BUDGET_CODE BDGT_CNTRL_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_TYPE	VARCHAR2	(30)		Indicates the project type for which the budgetary controls are created.
PROJECT_ID	NUMBER	(15)		Indicates the project Identifier for which these options are set. This should be null when the options are set for a project Type.
PROJECT_TYPE_ORG_ID	NUMBER	(15)		The operating unit of the project type
BUDGET_TYPE_CODE	VARCHAR2	(30)	Yes	Budget type to be used for the Budget Integration
BALANCE_TYPE	VARCHAR2	(1)		Indicates the balance type to be used for integration with the Non Project budget.
EXTERNAL_BUDGET_CODE	VARCHAR2	(30)		Specifies the external budget to be used for budget integration. Valid values are GL Budget (GL) , CBC Budget (CC).
GL_BUDGET_VERSION_ID	NUMBER	(15)		Specifies the GL Budget to be used if the balance type specified is Budget
ENCUMBRANCE_TYPE_ID	NUMBER	(15)		Internal Id that specifies the type of encumbrance to be used for integration if the balance type specified is Encumbrance
BDGT_CNTRL_FLAG	VARCHAR2	(1)	Yes	Specifies if this budget type is to be used for project budgetary controls. Valid values are Yes (Y) or No (N)
AMOUNT_TYPE	VARCHAR2	(15)		Indicates how the start date will be calculated using these budgetary control
BOUNDARY_CODE	VARCHAR2	(15)		Indicates how the end date will be calculated using these budgetary control
FUND_CONTROL_LEVEL_PROJECT	VARCHAR2	(1)		The type of funds control for the project level
FUND_CONTROL_LEVEL_TASK	VARCHAR2	(1)		The type of funds control for the task level
FUND_CONTROL_LEVEL_RES_GRP	VARCHAR2	(1)		The type of funds control for the resource group level
FUND_CONTROL_LEVEL_RES	VARCHAR2	(1)		The type of funds control for the resource level
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
YR_END_ROLLOVER_YEAR	NUMBER			Year End Budget Rollover Fiscal Year
YR_END_ROLLOVER_AMOUNT	NUMBER			Year End Budget Rollover Amount
YR_END_ROLLOVER_FLAG	VARCHAR2	(1)		End Rollover Flag. Valid values are S-Success, E-Exception
YR_END_ROLLOVER_MESSAGE	VARCHAR2	(200)		Message code stamped that was occured due to the Year End Budger Rollover Process
REQUEST_ID	NUMBER			Request Id of the concurrent program

Query Text

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;

Dependencies

[top of page]

PA.PA_BUDGETARY_CONTROL_OPTIONS does not reference any database object

PA.PA_BUDGETARY_CONTROL_OPTIONS is referenced by following:

PA: PA_BUDGETARY_CONTROL_OPTIONS#