[Home] [Help] [Dependency Information]
Object Name: | PSBBV_BUDGET_WORKSHEETS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSB.PSBBV_BUDGET_WORKSHEETS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
PSBBV_BUDGET_WORKSHEETS displays worksheet information.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKSHEET_NAME | VARCHAR2 | (80) | Yes | Worksheet name |
_LA:WORKSHEET_TYPE | CHAR | (58) | Worksheet type. Values are Distributed or Non-Distributed. | |
WORKSHEET_DESCRIPTION | VARCHAR2 | (2000) | Worksheet description | |
CURRENT_STAGE_SEQ | NUMBER | (15) | Yes | Sequence of the stage in the stage set. STAGE_SET_ID + CURRENT_STAGE_SEQ uniquely identifies a stage. Current stage of the worksheet. |
BUDGET_BY_POSITION | VARCHAR2 | (1) | Indicates if worksheet includes position budgets | |
NUM_PROPOSED_YEARS | NUMBER | Number of years for which budget estimates have to be created. Number cannot be greater than the number of proposed years in the calendar. Number can be overridden at the budget group level. | ||
NUM_YEARS_TO_ALLOCATE | NUMBER | Number of years for which the yearly budget estimates have to be allocated to periods within the year | ||
ROUNDING_FACTOR | NUMBER | Rounding factor to be used for amounts | ||
GL_CUTOFF_PERIOD | DATE | Cutoff date for extraction of actual balances from General Ledger for current budget year | ||
USE_REVISED_ELEMENT_RATES | VARCHAR2 | (1) | Indicates whether the revised element rates should be used for worksheet creation | |
INCLUDE_TRANSLATED_BALANCE | VARCHAR2 | (1) | Indicates whether to extract translated balances from General Ledger | |
INCLUDE_ADJUSTMENT_PERIODS | VARCHAR2 | (1) | Indicates whether to extract balances from adjusting periods in General Ledger | |
INCLUDE_STAT_BALANCE | VARCHAR2 | (1) | Indicates whether to extract statistical amounts from General Ledger | |
DATE_SUBMITTED | DATE | Date worksheet submitted for approval | ||
SUBMITTED_BY | NUMBER | (15) | User unique identifier. User submitting worksheet for approval. | |
WORKSHEET_ID | NUMBER | (20) | Yes | Worksheet unique identifier |
BUDGET_GROUP_ID | NUMBER | (20) | Yes | Budget group unique identifier. Budget group for which worksheet was created. |
BUDGET_CALENDAR_ID | NUMBER | (20) | Yes | Budget calendar unique identifier. Calendar used to create worksheet. |
STAGE_SET_ID | NUMBER | (15) | Yes | Stage set unique identifier. Worksheet can progress through the stages in this stage set. |
GLOBAL_WORKSHEET_ID | NUMBER | (15) | Global worksheet unique identifier. Global worksheet from which local worksheet was created. | |
GL_BUDGET_SET_ID | NUMBER | (20) | General Ledger budget set unique identifier | |
GL_BUDGET_VERSION_ID | NUMBER | (20) | General Ledger budget version unique identifier. Budget version from which budget amounts are extracted. If budgetary control is used in General Ledger, then the budget amounts are extracted from the funding budget for the account. | |
DATA_EXTRACT_ID | NUMBER | (20) | Data extract unique identifier. Data extract that is used for position related information. | |
PARAMETER_SET_ID | NUMBER | (20) | Parameter set unique identifier used for creating this worksheet | |
CONSTRAINT_SET_ID | NUMBER | (20) | Constraint set unique identifier used for validating this worksheet | |
ALLOCRULE_SET_ID | NUMBER | (15) | Allocation rule set unique identifier used for allocating this worksheet | |
FREEZE_FLAG | VARCHAR2 | (1) | Indicates if worksheet is frozen | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT WORKSHEET_NAME
, _LA:WORKSHEET_TYPE
, WORKSHEET_DESCRIPTION
, CURRENT_STAGE_SEQ
, BUDGET_BY_POSITION
, NUM_PROPOSED_YEARS
, NUM_YEARS_TO_ALLOCATE
, ROUNDING_FACTOR
, GL_CUTOFF_PERIOD
, USE_REVISED_ELEMENT_RATES
, INCLUDE_TRANSLATED_BALANCE
, INCLUDE_ADJUSTMENT_PERIODS
, INCLUDE_STAT_BALANCE
, DATE_SUBMITTED
, SUBMITTED_BY
, WORKSHEET_ID
, BUDGET_GROUP_ID
, BUDGET_CALENDAR_ID
, STAGE_SET_ID
, GLOBAL_WORKSHEET_ID
, GL_BUDGET_SET_ID
, GL_BUDGET_VERSION_ID
, DATA_EXTRACT_ID
, PARAMETER_SET_ID
, CONSTRAINT_SET_ID
, ALLOCRULE_SET_ID
, FREEZE_FLAG
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
FROM APPS.PSBBV_BUDGET_WORKSHEETS;
APPS.PSBBV_BUDGET_WORKSHEETS is not referenced by any database object
|
|
|