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

VIEW: APPS.PSB_WS_LINE_YEAR_V

Object Details
Object Name: PSB_WS_LINE_YEAR_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPSB.PSB_WS_LINE_YEAR_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
WORKSHEET_ID NUMBER (20) Yes Worksheet unique identifier
WORKSHEET_NAME VARCHAR2 (15)
Account line identifier for the column
PARENT_BUDGET_GROUP_ID NUMBER (20) Yes Unique identifier of the parent budget group for the current budget group
PARENT_BUDGET_GROUP_NAME VARCHAR2 (15)
Name of the budget group which is parent for current budget group
BUDGET_GROUP_ID NUMBER
Yes Budget group unique identifier. The budget group to which this account belongs.
ACCOUNT_TYPE VARCHAR2 (10) Yes General Ledger account type. A (Asset), L (Liability), O (Equity), R (Revenue), or E (Expense).
TEMPLATE_ID NUMBER

General Ledger summary template unique identifier
TEMPLATE_NAME VARCHAR2 (15)
Name of the template copied from General Ledger summary templates
CODE_COMBINATION_ID NUMBER (20) Yes General Ledger code combination unique identifier
SERVICE_PACKAGE_ID NUMBER (20) Yes Service package unique identifier
SERVICE_PACKAGE_NAME VARCHAR2 (15)
Service package name
PRIORITY NUMBER

Priority assigned to the service package
FREEZE_FLAG VARCHAR2 (1)
Flag indicates if the account line is frozen in the worksheet
VIEW_LINE_FLAG VARCHAR2 (1)
Flag indicates if the account line can be viewed in the worksheet
SALARY_ACCOUNT_LINE VARCHAR2 (1)
Flag indicates if salary is being charged to this account line
CURRENCY_CODE VARCHAR2 (10) Yes Functional currency of the General Ledger Set of Books or Statistical. This indicates the currency of the YTD_AMOUNT.
SEGMENT1 VARCHAR2 (25)
Key Flexfield segment
SEGMENT2 VARCHAR2 (25)
Key Flexfield segment
SEGMENT3 VARCHAR2 (25)
Key Flexfield segment
SEGMENT4 VARCHAR2 (25)
Key Flexfield segment
SEGMENT5 VARCHAR2 (25)
Key Flexfield segment
SEGMENT6 VARCHAR2 (25)
Key Flexfield segment
SEGMENT7 VARCHAR2 (25)
Key Flexfield segment
SEGMENT8 VARCHAR2 (25)
Key Flexfield segment
SEGMENT9 VARCHAR2 (25)
Key Flexfield segment
SEGMENT10 VARCHAR2 (25)
Key Flexfield segment
SEGMENT11 VARCHAR2 (25)
Key Flexfield segment
SEGMENT12 VARCHAR2 (25)
Key Flexfield segment
SEGMENT13 VARCHAR2 (25)
Key Flexfield segment
SEGMENT14 VARCHAR2 (25)
Key Flexfield segment
SEGMENT15 VARCHAR2 (25)
Key Flexfield segment
SEGMENT16 VARCHAR2 (25)
Key Flexfield segment
SEGMENT17 VARCHAR2 (25)
Key Flexfield segment
SEGMENT18 VARCHAR2 (25)
Key Flexfield segment
SEGMENT19 VARCHAR2 (25)
Key Flexfield segment
SEGMENT20 VARCHAR2 (25)
Key Flexfield segment
SEGMENT21 VARCHAR2 (25)
Key Flexfield segment
SEGMENT22 VARCHAR2 (25)
Key Flexfield segment
SEGMENT23 VARCHAR2 (25)
Key Flexfield segment
SEGMENT24 VARCHAR2 (25)
Key Flexfield segment
SEGMENT25 VARCHAR2 (25)
Key Flexfield segment
SEGMENT26 VARCHAR2 (25)
Key Flexfield segment
SEGMENT27 VARCHAR2 (25)
Key Flexfield segment
SEGMENT28 VARCHAR2 (25)
Key Flexfield segment
SEGMENT29 VARCHAR2 (25)
Key Flexfield segment
SEGMENT30 VARCHAR2 (25)
Key Flexfield segment
COLUMN1_ID NUMBER

Account line identifier for the column
COLUMN1 NUMBER

Year balance amount
COLUMN2_ID NUMBER

Account line identifier for the column
COLUMN2 NUMBER

Year balance amount
COLUMN3_ID NUMBER

Account line identifier for the column
COLUMN3 NUMBER

Year balance amount
COLUMN4_ID NUMBER

Account line identifier for the column
COLUMN4 NUMBER

Year balance amount
COLUMN5_ID NUMBER

Account line identifier for the column
COLUMN5 NUMBER

Year balance amount
COLUMN6_ID NUMBER

Account line identifier for the column
COLUMN6 NUMBER

Year balance amount
COLUMN7_ID NUMBER

Account line identifier for the column
COLUMN7 NUMBER

Year balance amount
COLUMN8_ID NUMBER

Account line identifier for the column
COLUMN8 NUMBER

Year balance amount
COLUMN9_ID NUMBER

Account line identifier for the column
COLUMN9 NUMBER

Year balance amount
COLUMN10_ID NUMBER

Account line identifier for the column
COLUMN10 NUMBER

Year balance amount
COLUMN11_ID NUMBER

Account line identifier for the column
COLUMN11 NUMBER

Year balance amount
COLUMN12_ID NUMBER

Account line identifier for the column
COLUMN12 NUMBER

Year balance amount
Query Text

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


SELECT WORKSHEET_ID
,      WORKSHEET_NAME
,      PARENT_BUDGET_GROUP_ID
,      PARENT_BUDGET_GROUP_NAME
,      BUDGET_GROUP_ID
,      ACCOUNT_TYPE
,      TEMPLATE_ID
,      TEMPLATE_NAME
,      CODE_COMBINATION_ID
,      SERVICE_PACKAGE_ID
,      SERVICE_PACKAGE_NAME
,      PRIORITY
,      FREEZE_FLAG
,      VIEW_LINE_FLAG
,      SALARY_ACCOUNT_LINE
,      CURRENCY_CODE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      COLUMN1_ID
,      COLUMN1
,      COLUMN2_ID
,      COLUMN2
,      COLUMN3_ID
,      COLUMN3
,      COLUMN4_ID
,      COLUMN4
,      COLUMN5_ID
,      COLUMN5
,      COLUMN6_ID
,      COLUMN6
,      COLUMN7_ID
,      COLUMN7
,      COLUMN8_ID
,      COLUMN8
,      COLUMN9_ID
,      COLUMN9
,      COLUMN10_ID
,      COLUMN10
,      COLUMN11_ID
,      COLUMN11
,      COLUMN12_ID
,      COLUMN12
FROM APPS.PSB_WS_LINE_YEAR_V;

Dependencies

[top of page]

APPS.PSB_WS_LINE_YEAR_V references the following:

SchemaAPPS
SynonymGL_CODE_COMBINATIONS
SynonymPSB_BUDGET_GROUPS
SynonymPSB_SERVICE_PACKAGES
SynonymPSB_SUMMARY_TEMPLATES
SynonymPSB_WORKSHEETS
SynonymPSB_WS_ACCOUNT_LINES
SynonymPSB_WS_LINES
PL/SQL PackagePSB_WS_MATRIX - show dependent code

APPS.PSB_WS_LINE_YEAR_V is not referenced by any database object