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]

VIEW: APPS.PSB_WORKSHEETS_V

Object Details

Object Name:	PSB_WORKSHEETS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PSB.PSB_WORKSHEETS_V
Subobject Name:
Status:	VALID

View Type

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.

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.PSB_WORKSHEETS_V references the following:

APPS: PSB_ALLOCRULE_SETS_V; PSB_BUDGET_CALENDARS; PSB_BUDGET_GROUPS; PSB_BUDGET_STAGE_SETS; PSB_CONSTRAINT_SETS_V; PSB_DATA_EXTRACTS; PSB_FLEX_MAPPING_SETS; PSB_GL_BUDGET_SETS; PSB_PARAMETER_SETS_V; PSB_WORKSHEETS

APPS.PSB_WORKSHEETS_V is referenced by following:

APPS: PSB_CONCURRENCY_CONTROL_PVT - show dependent code; PSB_DISTRIBUTE_WORKSHEET_PVT - show dependent code; PSB_POSITION_PAY_DISTR_PVT - show dependent code; PSB_SUBMIT_WORKSHEET_PVT - show dependent code; PSB_WORKSHEET - show dependent code; PSB_WS_ACCT1 - show dependent code; PSB_WS_ACCT2 - show dependent code; PSB_WS_POS1 - show dependent code; PSB_WS_POS2 - show dependent code; PSB_WS_POS3 - show dependent code