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

VIEW: APPS.PSB_WS_ELEMENT_LINES_V

Object Details
Object Name: PSB_WS_ELEMENT_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPSB.PSB_WS_ELEMENT_LINES_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
POSITION_LINE_ID NUMBER (20) Yes
SERVICE_PACKAGE_ID NUMBER
Yes
SERVICE_PACKAGE_NAME VARCHAR2 (15)
PAY_ELEMENT_ID NUMBER (20) Yes
ELEMENT_NAME VARCHAR2 (30) Yes
COLUMN1 NUMBER

COLUMN2 NUMBER

COLUMN3 NUMBER

COLUMN4 NUMBER

COLUMN5 NUMBER

COLUMN6 NUMBER

COLUMN7 NUMBER

COLUMN8 NUMBER

COLUMN9 NUMBER

COLUMN10 NUMBER

COLUMN11 NUMBER

COLUMN12 NUMBER

Query Text

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


SELECT POSITION_LINE_ID
,      SERVICE_PACKAGE_ID
,      SERVICE_PACKAGE_NAME
,      PAY_ELEMENT_ID
,      ELEMENT_NAME
,      COLUMN1
,      COLUMN2
,      COLUMN3
,      COLUMN4
,      COLUMN5
,      COLUMN6
,      COLUMN7
,      COLUMN8
,      COLUMN9
,      COLUMN10
,      COLUMN11
,      COLUMN12
FROM APPS.PSB_WS_ELEMENT_LINES_V;

Dependencies

[top of page]

APPS.PSB_WS_ELEMENT_LINES_V references the following:

SchemaAPPS
SynonymPSB_BUDGET_PERIODS
SynonymPSB_BUDGET_YEAR_TYPES
SynonymPSB_PAY_ELEMENTS
SynonymPSB_SERVICE_PACKAGES
SynonymPSB_WS_ELEMENT_LINES
PL/SQL PackagePSB_WS_ELEMENT_SETUP - show dependent code
PL/SQL PackagePSB_WS_MATRIX - show dependent code

APPS.PSB_WS_ELEMENT_LINES_V is not referenced by any database object