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_WS_LINE_PERIOD_V

Object Details

Object Name:	PSB_WS_LINE_PERIOD_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PSB.PSB_WS_LINE_PERIOD_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
ACCOUNT_LINE_ID	NUMBER			Account line unique identifier
POSITION_ACCOUNT_FLAG	NUMBER			Flag indicates if position costs is distributed to this account
ACCOUNT_TYPE	VARCHAR2	(10)	Yes	General Ledger account type. A (Asset), L (Liability), O (Equity), R (Revenue), or E (Expense).
CODE_COMBINATION_ID	NUMBER	(20)	Yes	General Ledger code combination unique identifier
TEMPLATE_ID	NUMBER			General Ledger summary template unique identifier
SERVICE_PACKAGE_ID	NUMBER	(20)	Yes	Service package unique identifier
SERVICE_PACKAGE_NAME	VARCHAR2	(15)	Yes	Service package name
PRIORITY	NUMBER			Priority assigned to the service package
BUDGET_GROUP_ID	NUMBER		Yes	Budget group unique identifier
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), or E (Estimate).
ANNUAL_FTE	NUMBER			The full-time equivalency factor computed by annualizing the period full-time equivalencies
CURRENCY_CODE	VARCHAR2	(10)	Yes	Functional currency of the General Ledger Set of Books or Statistical. This indicates the currency of the YTD_AMOUNT.
SALARY_ACCOUNT_LINE	VARCHAR2	(1)		Flag indicates if salary is being charged to this account line
YTD_AMOUNT	NUMBER			The year to date amount
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 WORKSHEET_ID
,      ACCOUNT_LINE_ID
,      POSITION_ACCOUNT_FLAG
,      ACCOUNT_TYPE
,      CODE_COMBINATION_ID
,      TEMPLATE_ID
,      SERVICE_PACKAGE_ID
,      SERVICE_PACKAGE_NAME
,      PRIORITY
,      BUDGET_GROUP_ID
,      BUDGET_YEAR_ID
,      BALANCE_TYPE
,      ANNUAL_FTE
,      CURRENCY_CODE
,      SALARY_ACCOUNT_LINE
,      YTD_AMOUNT
,      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_LINE_PERIOD_V;

Dependencies

[top of page]

APPS.PSB_WS_LINE_PERIOD_V references the following:

APPS: GL_CODE_COMBINATIONS; PSB_SERVICE_PACKAGES; PSB_WS_ACCOUNT_LINES; PSB_WS_LINES; PSB_WS_MATRIX - show dependent code

APPS.PSB_WS_LINE_PERIOD_V is not referenced by any database object