DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PSB_BUDGET_GROUPS_V

Object Details
Object Name: PSB_BUDGET_GROUPS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPSB.PSB_BUDGET_GROUPS_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)
BUDGET_GROUP_ID NUMBER (20)
NAME VARCHAR2 (80)
SHORT_NAME VARCHAR2 (20)
PARENT_BUDGET_GROUP_ID NUMBER (20)
PARENT_SHORT_NAME VARCHAR2 (20)
PARENT_NAME VARCHAR2 (80)
PARENT_EFFECTIVE_START_DATE DATE

PARENT_EFFECTIVE_END_DATE DATE

ROOT_BUDGET_GROUP VARCHAR2 (1)
ROOT_BUDGET_GROUP_ID NUMBER (20)
ROOT_SHORT_NAME VARCHAR2 (20)
ROOT_NAME VARCHAR2 (80)
ROOT_SET_OF_BOOKS_ID NUMBER

ROOT_SOB_NAME VARCHAR2 (30)
ROOT_CHART_OF_ACCOUNTS_ID NUMBER

ROOT_CURRENCY_CODE VARCHAR2 (15)
ROOT_FREEZE_HIERARCHY_FLAG VARCHAR2 (1)
ROOT_REQUEST_ID NUMBER

ROOT_BUSINESS_GROUP_ID NUMBER

PS_ACCOUNT_POSITION_SET_ID NUMBER (15)
PS_NAME VARCHAR2 (100)
NPS_ACCOUNT_POSITION_SET_ID NUMBER (15)
NPS_NAME VARCHAR2 (100)
BUDGET_GROUP_CATEGORY_SET_ID NUMBER (15)
CATEGORY_SET_NAME VARCHAR2 (30)
EFFECTIVE_START_DATE DATE

EFFECTIVE_END_DATE DATE

FREEZE_HIERARCHY_FLAG VARCHAR2 (1)
DESCRIPTION VARCHAR2 (240)
SET_OF_BOOKS_ID NUMBER (15)
SOB_NAME VARCHAR2 (30)
CHART_OF_ACCOUNTS_ID NUMBER

CURRENCY_CODE VARCHAR2 (15)
BUSINESS_GROUP_ID NUMBER (15)
NUM_PROPOSED_YEARS NUMBER

NARRATIVE_DESCRIPTION VARCHAR2 (2000)
BUDGET_GROUP_TYPE VARCHAR2 (1)
REQUEST_ID NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

SEGMENT1_TYPE NUMBER (15)
SEGMENT2_TYPE NUMBER (15)
SEGMENT3_TYPE NUMBER (15)
SEGMENT4_TYPE NUMBER (15)
SEGMENT5_TYPE NUMBER (15)
SEGMENT6_TYPE NUMBER (15)
SEGMENT7_TYPE NUMBER (15)
SEGMENT8_TYPE NUMBER (15)
SEGMENT9_TYPE NUMBER (15)
SEGMENT10_TYPE NUMBER (15)
SEGMENT11_TYPE NUMBER (15)
SEGMENT12_TYPE NUMBER (15)
SEGMENT13_TYPE NUMBER (15)
SEGMENT14_TYPE NUMBER (15)
SEGMENT15_TYPE NUMBER (15)
SEGMENT16_TYPE NUMBER (15)
SEGMENT17_TYPE NUMBER (15)
SEGMENT18_TYPE NUMBER (15)
SEGMENT19_TYPE NUMBER (15)
SEGMENT20_TYPE NUMBER (15)
SEGMENT21_TYPE NUMBER (15)
SEGMENT22_TYPE NUMBER (15)
SEGMENT23_TYPE NUMBER (15)
SEGMENT24_TYPE NUMBER (15)
SEGMENT25_TYPE NUMBER (15)
SEGMENT26_TYPE NUMBER (15)
SEGMENT27_TYPE NUMBER (15)
SEGMENT28_TYPE NUMBER (15)
SEGMENT29_TYPE NUMBER (15)
SEGMENT30_TYPE NUMBER (15)
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)
ORGANIZATION_ID NUMBER (15)
ORGANIZATION_NAME VARCHAR2 (240)
HR Organization NAme.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      BUDGET_GROUP_ID
,      NAME
,      SHORT_NAME
,      PARENT_BUDGET_GROUP_ID
,      PARENT_SHORT_NAME
,      PARENT_NAME
,      PARENT_EFFECTIVE_START_DATE
,      PARENT_EFFECTIVE_END_DATE
,      ROOT_BUDGET_GROUP
,      ROOT_BUDGET_GROUP_ID
,      ROOT_SHORT_NAME
,      ROOT_NAME
,      ROOT_SET_OF_BOOKS_ID
,      ROOT_SOB_NAME
,      ROOT_CHART_OF_ACCOUNTS_ID
,      ROOT_CURRENCY_CODE
,      ROOT_FREEZE_HIERARCHY_FLAG
,      ROOT_REQUEST_ID
,      ROOT_BUSINESS_GROUP_ID
,      PS_ACCOUNT_POSITION_SET_ID
,      PS_NAME
,      NPS_ACCOUNT_POSITION_SET_ID
,      NPS_NAME
,      BUDGET_GROUP_CATEGORY_SET_ID
,      CATEGORY_SET_NAME
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      FREEZE_HIERARCHY_FLAG
,      DESCRIPTION
,      SET_OF_BOOKS_ID
,      SOB_NAME
,      CHART_OF_ACCOUNTS_ID
,      CURRENCY_CODE
,      BUSINESS_GROUP_ID
,      NUM_PROPOSED_YEARS
,      NARRATIVE_DESCRIPTION
,      BUDGET_GROUP_TYPE
,      REQUEST_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      SEGMENT1_TYPE
,      SEGMENT2_TYPE
,      SEGMENT3_TYPE
,      SEGMENT4_TYPE
,      SEGMENT5_TYPE
,      SEGMENT6_TYPE
,      SEGMENT7_TYPE
,      SEGMENT8_TYPE
,      SEGMENT9_TYPE
,      SEGMENT10_TYPE
,      SEGMENT11_TYPE
,      SEGMENT12_TYPE
,      SEGMENT13_TYPE
,      SEGMENT14_TYPE
,      SEGMENT15_TYPE
,      SEGMENT16_TYPE
,      SEGMENT17_TYPE
,      SEGMENT18_TYPE
,      SEGMENT19_TYPE
,      SEGMENT20_TYPE
,      SEGMENT21_TYPE
,      SEGMENT22_TYPE
,      SEGMENT23_TYPE
,      SEGMENT24_TYPE
,      SEGMENT25_TYPE
,      SEGMENT26_TYPE
,      SEGMENT27_TYPE
,      SEGMENT28_TYPE
,      SEGMENT29_TYPE
,      SEGMENT30_TYPE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      CONTEXT
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
FROM APPS.PSB_BUDGET_GROUPS_V;

Dependencies

[top of page]

APPS.PSB_BUDGET_GROUPS_V references the following:

SchemaAPPS
ViewGL_SETS_OF_BOOKS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymPSB_ACCOUNT_POSITION_SETS
SynonymPSB_BUDGET_GROUPS
SynonymPSB_BUDGET_STAGE_SETS
APPS.PSB_BUDGET_GROUPS_V is referenced by following:

SchemaAPPS
Package BodyPSB_BUDGET_GROUPS_PVT - show dependent code
Package BodyPSB_BUDGET_REVISIONS_PVT - show dependent code
Package BodyPSB_COMMITMENTS_PVT - show dependent code
Package BodyPSB_EXCEL_PVT - show dependent code
Package BodyPSB_GL_INTERFACE_PVT - show dependent code
Package BodyPSB_POSITIONS_PVT - show dependent code
Package BodyPSB_POSITION_CONTROL_PVT - show dependent code
Package BodyPSB_POSITION_PAY_DISTR_PVT - show dependent code
Package BodyPSB_PSBOTGLR_XMLP_PKG - show dependent code
Package BodyPSB_PSBRPFHP_XMLP_PKG - show dependent code
Package BodyPSB_PSBRPPSA_XMLP_PKG - show dependent code
Package BodyPSB_PSBRPVPR_XMLP_PKG - show dependent code
Package BodyPSB_VALIDATE_ACCT_PVT - show dependent code
Package BodyPSB_WORKSHEET - show dependent code
Package BodyPSB_WORKSHEET_CONSOLIDATE - show dependent code
Package BodyPSB_WS_ACCT2 - show dependent code
ViewPSB_WS_DISTRIBUTE_RULE_LINES_V
Package BodyPSB_WS_POS1 - show dependent code
Package BodyPSB_WS_POS2 - show dependent code
Package BodyPSB_WS_POS3 - show dependent code
ViewPSB_WS_SUMMARY_V