[Home] [Help] [Dependency Information]
Object Name: | PSB_WORKSHEETS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSB.PSB_WORKSHEETS_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
WORKSHEET_ID | NUMBER | (20) | Yes | |
BUDGET_GROUP_ID | NUMBER | (20) | Yes | |
BUDGET_GROUP_NAME | VARCHAR2 | (20) | Yes | |
BUDGET_CALENDAR_ID | NUMBER | (20) | Yes | |
BUDGET_CALENDAR_NAME | VARCHAR2 | (30) | Yes | |
WORKSHEET_TYPE | VARCHAR2 | (1) | Yes | |
NAME | VARCHAR2 | (80) | Yes | |
DESCRIPTION | VARCHAR2 | (2000) | ||
FREEZE_FLAG | VARCHAR2 | (1) | ||
STAGE_SET_ID | NUMBER | (15) | Yes | |
CURRENT_STAGE_SEQ | NUMBER | (15) | Yes | |
GLOBAL_WORKSHEET_FLAG | VARCHAR2 | (1) | ||
GLOBAL_WORKSHEET_ID | NUMBER | (15) | ||
GLOBAL_WORKSHEET_OPTION | VARCHAR2 | (1) | ||
LOCAL_COPY_FLAG | VARCHAR2 | (1) | ||
COPY_OF_WORKSHEET_ID | NUMBER | (20) | ||
ROUNDING_FACTOR | NUMBER | |||
BUDGET_BY_POSITION | VARCHAR2 | (1) | ||
USE_REVISED_ELEMENT_RATES | VARCHAR2 | (1) | This column is obsoleted | |
NUM_PROPOSED_YEARS | NUMBER | |||
NUM_YEARS_TO_ALLOCATE | NUMBER | |||
GL_CUTOFF_PERIOD | DATE | |||
BUDGET_VERSION_ID | NUMBER | (20) | ||
GL_BUDGET_SET_ID | NUMBER | (20) | GL Budget Set identifier. | |
GL_BUDGET_SET_NAME | VARCHAR2 | (80) | GL Budget Set Name. | |
INCLUDE_STAT_BALANCE | VARCHAR2 | (1) | ||
INCLUDE_TRANSLATED_BALANCE | VARCHAR2 | (1) | ||
INCLUDE_ADJUSTMENT_PERIODS | VARCHAR2 | (1) | ||
DATE_SUBMITTED | DATE | |||
SUBMITTED_BY | NUMBER | (15) | ||
DATA_EXTRACT_ID | NUMBER | (20) | ||
DATA_EXTRACT_NAME | VARCHAR2 | (30) | ||
GLOBAL_DATA_EXTRACT_ID | NUMBER | (20) | ||
PARAMETER_SET_ID | NUMBER | (20) | ||
PARAMETER_SET_NAME | VARCHAR2 | (80) | ||
GLOBAL_PARAMETER_SET_ID | NUMBER | (20) | ||
CONSTRAINT_SET_ID | NUMBER | (20) | ||
CONSTRAINT_SET_NAME | VARCHAR2 | (80) | ||
GLOBAL_CONSTRAINT_SET_ID | NUMBER | (20) | ||
ALLOCRULE_SET_ID | NUMBER | (15) | ||
ALLOCRULE_SET_NAME | VARCHAR2 | (80) | ||
GLOBAL_ALLOCRULE_SET_ID | NUMBER | (15) | ||
WS_CREATION_COMPLETE | VARCHAR2 | (1) | ||
CREATE_NON_POS_LINE_ITEMS | VARCHAR2 | (1) | Indicates if line items need to be created for non-position budget | |
APPLY_ELEMENT_PARAMETERS | VARCHAR2 | (1) | Indicates if element parameters need to be applied for position budget | |
APPLY_POSITION_PARAMETERS | VARCHAR2 | (1) | Indicates if position parameters need to be applied for position budget | |
CREATE_POSITIONS | VARCHAR2 | (1) | Create positions for the budget | |
CREATE_SUMMARY_TOTALS | VARCHAR2 | (1) | Indicates if rollup totals are to be camputed | |
APPLY_CONSTRAINTS | VARCHAR2 | (1) | Indicates if the constraints are to applied | |
FLEX_MAPPING_SET_ID | NUMBER | (15) | Flex Mapping Set Id for mapping flexfields | |
FLEX_MAPPING_SET_NAME | VARCHAR2 | (30) | Set Name for the Flex Mapping Set Id | |
INCLUDE_GL_COMMIT_BALANCE | VARCHAR2 | (1) | Indicates if General Ledger commitment balances are to be added for worksheet creation | |
INCLUDE_GL_OBLIG_BALANCE | VARCHAR2 | (1) | Indicates if General Ledger obligation balances are to be added for worksheet creation | |
INCLUDE_GL_OTHER_BALANCE | VARCHAR2 | (1) | Indicates if General Ledger other balances are to be added for worksheet creation | |
INCLUDE_CBC_COMMIT_BALANCE | VARCHAR2 | (1) | Indicates if commitment balances should be extracted from Commitment Budgetary Control system. | |
INCLUDE_CBC_OBLIG_BALANCE | VARCHAR2 | (1) | Indicates if obligation balances should be extracted from Commitment Budgetary Control system. | |
INCLUDE_CBC_BUDGET_BALANCE | VARCHAR2 | (1) | Indicates if budget balances should be extracted from Commitment Budgetary Control system. | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
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) | ||
CONTEXT | VARCHAR2 | (30) | ||
FEDERAL_WS_FLAG | VARCHAR2 | (1) | ||
INCLUDE_GL_FORWARD_BALANCE | VARCHAR2 | (1) | Include GL Forward Balance. 'Y' indicates that worksheet will bring carry forward balances in GL into PSB for Budget and Encumbrances |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, WORKSHEET_ID
, BUDGET_GROUP_ID
, BUDGET_GROUP_NAME
, BUDGET_CALENDAR_ID
, BUDGET_CALENDAR_NAME
, WORKSHEET_TYPE
, NAME
, DESCRIPTION
, FREEZE_FLAG
, STAGE_SET_ID
, CURRENT_STAGE_SEQ
, GLOBAL_WORKSHEET_FLAG
, GLOBAL_WORKSHEET_ID
, GLOBAL_WORKSHEET_OPTION
, LOCAL_COPY_FLAG
, COPY_OF_WORKSHEET_ID
, ROUNDING_FACTOR
, BUDGET_BY_POSITION
, USE_REVISED_ELEMENT_RATES
, NUM_PROPOSED_YEARS
, NUM_YEARS_TO_ALLOCATE
, GL_CUTOFF_PERIOD
, BUDGET_VERSION_ID
, GL_BUDGET_SET_ID
, GL_BUDGET_SET_NAME
, INCLUDE_STAT_BALANCE
, INCLUDE_TRANSLATED_BALANCE
, INCLUDE_ADJUSTMENT_PERIODS
, DATE_SUBMITTED
, SUBMITTED_BY
, DATA_EXTRACT_ID
, DATA_EXTRACT_NAME
, GLOBAL_DATA_EXTRACT_ID
, PARAMETER_SET_ID
, PARAMETER_SET_NAME
, GLOBAL_PARAMETER_SET_ID
, CONSTRAINT_SET_ID
, CONSTRAINT_SET_NAME
, GLOBAL_CONSTRAINT_SET_ID
, ALLOCRULE_SET_ID
, ALLOCRULE_SET_NAME
, GLOBAL_ALLOCRULE_SET_ID
, WS_CREATION_COMPLETE
, CREATE_NON_POS_LINE_ITEMS
, APPLY_ELEMENT_PARAMETERS
, APPLY_POSITION_PARAMETERS
, CREATE_POSITIONS
, CREATE_SUMMARY_TOTALS
, APPLY_CONSTRAINTS
, FLEX_MAPPING_SET_ID
, FLEX_MAPPING_SET_NAME
, INCLUDE_GL_COMMIT_BALANCE
, INCLUDE_GL_OBLIG_BALANCE
, INCLUDE_GL_OTHER_BALANCE
, INCLUDE_CBC_COMMIT_BALANCE
, INCLUDE_CBC_OBLIG_BALANCE
, INCLUDE_CBC_BUDGET_BALANCE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, CONTEXT
, FEDERAL_WS_FLAG
, INCLUDE_GL_FORWARD_BALANCE
FROM APPS.PSB_WORKSHEETS_V;
|
|
|