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

VIEW: APPS.PSB_WS_POSITION_PERIODS_V

Object Details
Object Name: PSB_WS_POSITION_PERIODS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPSB.PSB_WS_POSITION_PERIODS_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 Worksheet unique identifier.
NAME VARCHAR2 (80) Yes Name of the service package.
ELEMENT_SET_ID NUMBER (20)
POSITION_LINE_ID NUMBER

ACCOUNT_TYPE VARCHAR2 (10) Yes General Ledger Account type: A (Asset), L (Liability), O (Equity), R (Revenue), E (Expense).
ACCOUNT_LINE_ID NUMBER (20) Yes Account Line unqiue identifer.
CODE_COMBINATION_ID NUMBER (20) Yes General Ledger code combination unique identifier.
TEMPLATE_ID NUMBER

GL summary template unqiue identifier.
TEMPLATE_NAME VARCHAR2 (100)
Name of the template copied from GL summary templates.
SERVICE_PACKAGE_ID NUMBER (20) Yes Service Package unique identifier.
SERVICE_PACKAGE_NAME VARCHAR2 (15) Yes
PRIORITY NUMBER

Priority assigned to the service package.
BUDGET_YEAR_ID NUMBER (20) Yes Budget year unique identifier. The budget year for which this account line is assigned.
BALANCE_TYPE VARCHAR2 (1) Yes Balance type: B (Budget), A (Actual), E (Estimate).
ANNUAL_FTE NUMBER

The FTE factor computed by annualizing the period FTEs.
YTD_AMOUNT NUMBER

The year to date amount.
CURRENCY_CODE VARCHAR2 (10) Yes Functional currency of the General Ledger Set of Books or Statistical. This indicates the currency of the YTD_AMOUNT.
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.
PERIOD1_AMOUNT NUMBER

The amount allocated to periods in a budget year.
PERIOD2_AMOUNT NUMBER

The amount allocated to periods in a budget year.
PERIOD3_AMOUNT NUMBER

The amount allocated to periods in a budget year.
PERIOD4_AMOUNT NUMBER

The amount allocated to periods in a budget year.
PERIOD5_AMOUNT NUMBER

The amount allocated to periods in a budget year.
PERIOD6_AMOUNT NUMBER

The amount allocated to periods in a budget year.
PERIOD7_AMOUNT NUMBER

The amount allocated to periods in a budget year.
PERIOD8_AMOUNT NUMBER

The amount allocated to periods in a budget year.
PERIOD9_AMOUNT NUMBER

The amount allocated to periods in a budget year.
PERIOD10_AMOUNT NUMBER

The amount allocated to periods in a budget year.
PERIOD11_AMOUNT NUMBER

The amount allocated to periods in a budget year.
PERIOD12_AMOUNT NUMBER

The amount allocated to periods in a budget year.
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
Query Text

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


SELECT ROW_ID
,      WORKSHEET_ID
,      NAME
,      ELEMENT_SET_ID
,      POSITION_LINE_ID
,      ACCOUNT_TYPE
,      ACCOUNT_LINE_ID
,      CODE_COMBINATION_ID
,      TEMPLATE_ID
,      TEMPLATE_NAME
,      SERVICE_PACKAGE_ID
,      SERVICE_PACKAGE_NAME
,      PRIORITY
,      BUDGET_YEAR_ID
,      BALANCE_TYPE
,      ANNUAL_FTE
,      YTD_AMOUNT
,      CURRENCY_CODE
,      FREEZE_FLAG
,      VIEW_LINE_FLAG
,      SALARY_ACCOUNT_LINE
,      PERIOD1_AMOUNT
,      PERIOD2_AMOUNT
,      PERIOD3_AMOUNT
,      PERIOD4_AMOUNT
,      PERIOD5_AMOUNT
,      PERIOD6_AMOUNT
,      PERIOD7_AMOUNT
,      PERIOD8_AMOUNT
,      PERIOD9_AMOUNT
,      PERIOD10_AMOUNT
,      PERIOD11_AMOUNT
,      PERIOD12_AMOUNT
,      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
FROM APPS.PSB_WS_POSITION_PERIODS_V;

Dependencies

[top of page]

APPS.PSB_WS_POSITION_PERIODS_V references the following:

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

APPS.PSB_WS_POSITION_PERIODS_V is not referenced by any database object