[Home] [Help]
[Dependency Information]
Object Name: | HRFV_TRANSFERS_OUT |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view shows internal transfers of employees from one organization to another. The
assignment information relates to the organization out of which the
employee has transferred.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
PERSON_NAME | VARCHAR2 | (240) | ||
BUDGET_MEASUREMENT_TYPE | VARCHAR2 | (4000) | ||
BUDGET_MEASUREMENT_CODE | VARCHAR2 | (30) | Yes | |
TRANSFER_OUT_DATE | DATE | |||
ASSIGNMENT_NUMBER | VARCHAR2 | (30) | ||
EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
PERSON_TYPE | VARCHAR2 | (80) | Yes | |
EMPLOYEE_PERSON_TYPE | VARCHAR2 | (4000) | ||
USER_CONCAT_PERSON_TYPE | VARCHAR2 | (4000) | ||
EMPLOYMENT_CATEGORY | VARCHAR2 | (4000) | ||
NEW_ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | |
ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | |
GRADE_NAME | VARCHAR2 | (240) | ||
JOB_NAME | VARCHAR2 | (700) | ||
POSITION_NAME | VARCHAR2 | (240) | ||
LOCATION_NAME | VARCHAR2 | (60) | ||
SYSTEM_PERSON_TYPE_CODE | VARCHAR2 | (30) | Yes | |
ASSIGNMENT_ID | NUMBER | (10) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
GRADE_ID | NUMBER | (15) | ||
JOB_ID | NUMBER | (15) | ||
ORGANIZATION_ID | NUMBER | (15) | Yes | |
PERSON_ID | NUMBER | (10) | Yes | |
POSITION_ID | NUMBER | (15) | ||
TRANSFER_ORGANIZATION_ID | NUMBER | (15) | Yes | |
PERSON_TYPE_ID | NUMBER | (15) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_NAME
, PERSON_NAME
, BUDGET_MEASUREMENT_TYPE
, BUDGET_MEASUREMENT_CODE
, TRANSFER_OUT_DATE
, ASSIGNMENT_NUMBER
, EMPLOYEE_NUMBER
, PERSON_TYPE
, EMPLOYEE_PERSON_TYPE
, USER_CONCAT_PERSON_TYPE
, EMPLOYMENT_CATEGORY
, NEW_ORGANIZATION_NAME
, ORGANIZATION_NAME
, GRADE_NAME
, JOB_NAME
, POSITION_NAME
, LOCATION_NAME
, SYSTEM_PERSON_TYPE_CODE
, ASSIGNMENT_ID
, BUSINESS_GROUP_ID
, GRADE_ID
, JOB_ID
, ORGANIZATION_ID
, PERSON_ID
, POSITION_ID
, TRANSFER_ORGANIZATION_ID
, PERSON_TYPE_ID
FROM APPS.HRFV_TRANSFERS_OUT;
APPS.HRFV_TRANSFERS_OUT is not referenced by any database object
|
|
|