[Home] [Help]
[Dependency Information]
| Object Name: | PQH_POSITION_ELEMENT_TYPES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | PQH.PQH_POSITION_ELEMENT_TYPES_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View for Reporting Purposes
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ELEMENT_NAME | VARCHAR2 | (80) | Element Name | |
| ELEMENT_TYPE_ID | NUMBER | (15) | Element Type Identifier | |
| POSITION_NAME | VARCHAR2 | (4000) | Position Name | |
| POSITION_ID | NUMBER | (15) | Position Identifier | |
| BUDGET_MEASUREMENT_TYPE | VARCHAR2 | (4000) | Budget Measurement Type | |
| BUDGET_UNIT_ID | NUMBER | (15) | Budget measurement Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ELEMENT_NAME
, ELEMENT_TYPE_ID
, POSITION_NAME
, POSITION_ID
, BUDGET_MEASUREMENT_TYPE
, BUDGET_UNIT_ID
FROM APPS.PQH_POSITION_ELEMENT_TYPES_V;
APPS
HR_GENERAL
- show dependent code
PAY_ELEMENT_TYPES
PQH_BUDGETS_V
PQH_BUDGET_DETAILS
PQH_BUDGET_ELEMENTS
PQH_BUDGET_PERIODS
PQH_BUDGET_SETS
PQH_BUDGET_VERSIONS
PQH_UTILITY
- show dependent code
PUBLIC
PQH_POSITION_ELEMENT_TYPES_V
|
|
|
|