[Home] [Help] [Dependency Information]
Object Name: | PSBFV_BUDGET_WORKSHEETS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSB.PSBFV_BUDGET_WORKSHEETS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
PSBFV_BUDGET_WORKSHEETS displays worksheet information.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKSHEET_NAME | VARCHAR2 | (80) | Yes | Worksheet name |
BUDGET_GROUP_NAME | VARCHAR2 | (80) | Yes | Budget group name |
BUDGET_CALENDAR_NAME | VARCHAR2 | (30) | Yes | Budget calendar used while creating worksheet |
STAGE_SET_NAME | VARCHAR2 | (100) | Yes | Budget stage name |
DATA_EXTRACT_NAME | VARCHAR2 | (30) | Data extract name | |
PARAMETER_SET_NAME | VARCHAR2 | (80) | Name of parameter set used for creating worksheet | |
CONSTRAINT_SET_NAME | VARCHAR2 | (80) | Name of constraint set used for validating worksheet | |
ALLOCRULE_SET_NAME | VARCHAR2 | (80) | Allocation set name | |
_LA:WORKSHEET_TYPE | CHAR | (58) | Worksheet type. Values are Distributed or Non-Distributed. | |
WORKSHEET_DESCRIPTION | VARCHAR2 | (2000) | Worksheet description | |
CURRENT_STAGE_SEG | NUMBER | (15) | Yes | Sequence of the stage in the stage set. STAGE_SET_ID + CURRENT_STAGE_SEQ uniquely identifies a stage. This is the current stage of the worksheet. |
_DF | CHAR | (25) | Descriptive Flexfield column | |
USE_REVISED_ELEMENT_RATES | VARCHAR2 | (1) | Indicates whether revised element rates should be used for worksheet creation | |
BUDGET_BY_POSITION | VARCHAR2 | (1) | Indicates if worksheet includes position budgets | |
INCLUDE_TRANSLATED_BALANCE | VARCHAR2 | (1) | Indicates whether to extract translated balances from the 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 the General Ledger | |
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 | ||
GL_CUTOFF_PERIOD | DATE | Cutoff date for extraction of actual balances from General Ledger for current budget year | ||
ROUNDING_FACTOR | NUMBER | Rounding factor to be used for amounts | ||
GL_BUDGET_VERSION_NAME | VARCHAR2 | (15) | General Ledger budget version name | |
GL_BUDGET_SET_NAME | VARCHAR2 | (80) | General Ledger budget set name | |
DATE_SUBMITTED | DATE | Date worksheet submitted for approval | ||
SUBMITTED_BY | NUMBER | (15) | User unique identifier. User submitting the worksheet for approval. | |
FREEZE_FLAG | VARCHAR2 | (1) | Indicates if worksheet is frozen | |
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 stages in this stage set. |
GLOBAL_WORKSHEET_ID | NUMBER | (15) | Global worksheet unique identifier. Global worksheet from which local worksheet was created. | |
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. | |
GL_BUDGET_SET_ID | NUMBER | (20) | General Ledger budget set unique identifier | |
DATA_EXTRACT_ID | NUMBER | (20) | Data extract unique identifier. Data extract used for position-related information. | |
PARAMETER_SET_ID | NUMBER | (20) | Parameter set unique identifier used for creating worksheet | |
CONSTRAINT_SET_ID | NUMBER | (20) | Constraint set unique identifier used for validating worksheet | |
ALLOCRULE_SET_ID | NUMBER | (15) | Allocation rule set unique identifier used for allocating worksheet | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT WORKSHEET_NAME
, BUDGET_GROUP_NAME
, BUDGET_CALENDAR_NAME
, STAGE_SET_NAME
, DATA_EXTRACT_NAME
, PARAMETER_SET_NAME
, CONSTRAINT_SET_NAME
, ALLOCRULE_SET_NAME
, _LA:WORKSHEET_TYPE
, WORKSHEET_DESCRIPTION
, CURRENT_STAGE_SEG
, _DF
, USE_REVISED_ELEMENT_RATES
, BUDGET_BY_POSITION
, INCLUDE_TRANSLATED_BALANCE
, INCLUDE_ADJUSTMENT_PERIODS
, INCLUDE_STAT_BALANCE
, NUM_PROPOSED_YEARS
, NUM_YEARS_TO_ALLOCATE
, GL_CUTOFF_PERIOD
, ROUNDING_FACTOR
, GL_BUDGET_VERSION_NAME
, GL_BUDGET_SET_NAME
, DATE_SUBMITTED
, SUBMITTED_BY
, FREEZE_FLAG
, WORKSHEET_ID
, BUDGET_GROUP_ID
, BUDGET_CALENDAR_ID
, STAGE_SET_ID
, GLOBAL_WORKSHEET_ID
, GL_BUDGET_VERSION_ID
, GL_BUDGET_SET_ID
, DATA_EXTRACT_ID
, PARAMETER_SET_ID
, CONSTRAINT_SET_ID
, ALLOCRULE_SET_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
FROM APPS.PSBFV_BUDGET_WORKSHEETS;
APPS.PSBFV_BUDGET_WORKSHEETS is not referenced by any database object
|
|
|