[Home] [Help]
[Dependency Information]
| Object Name: | PSB_WS_ELEMENT_LINE_NAMES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | PSB.PSB_WS_ELEMENT_LINE_NAMES_V
|
| Subobject Name: | |
| Status: | VALID |
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.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ELEMENT_LINE_ID | NUMBER | (20) | Yes | |
| POSITION_LINE_ID | NUMBER | (20) | Yes | |
| BUDGET_YEAR_ID | NUMBER | (15) | Yes | |
| PAY_ELEMENT_ID | NUMBER | (20) | Yes | |
| CURRENCY_CODE | VARCHAR2 | (10) | Yes | |
| ELEMENT_COST | NUMBER | Yes | ||
| ELEMENT_SET_ID | VARCHAR2 | (40) | ||
| SERVICE_PACKAGE_ID | NUMBER | Yes | ||
| STAGE_SET_ID | NUMBER | Yes | ||
| START_STAGE_SEQ | NUMBER | Yes | ||
| CURRENT_STAGE_SEQ | NUMBER | Yes | ||
| END_STAGE_SEQ | NUMBER | |||
| PAY_ELEMENT_NAME | VARCHAR2 | (30) | Yes | |
| FOLLOW_SALARY | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT ELEMENT_LINE_ID
, POSITION_LINE_ID
, BUDGET_YEAR_ID
, PAY_ELEMENT_ID
, CURRENCY_CODE
, ELEMENT_COST
, ELEMENT_SET_ID
, SERVICE_PACKAGE_ID
, STAGE_SET_ID
, START_STAGE_SEQ
, CURRENT_STAGE_SEQ
, END_STAGE_SEQ
, PAY_ELEMENT_NAME
, FOLLOW_SALARY
FROM APPS.PSB_WS_ELEMENT_LINE_NAMES_V;
APPS
PSB_PAY_ELEMENTS
PSB_WS_ELEMENT_LINES
APPS.PSB_WS_ELEMENT_LINE_NAMES_V is not referenced by any database object
|
|
|
|