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.EDW_HR_PERM_ASSIGN_LCV

Object Details

Object Name:	EDW_HR_PERM_ASSIGN_LCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	HRI.EDW_HR_PERM_ASSIGN_LCV
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length
ASSIGNMENT_PK	VARCHAR2	(126)
ALL_FK	CHAR	(3)
SPRVSR_LVL1_FK	VARCHAR2	(155)
NAME	VARCHAR2	(491)
PERSON_DP	VARCHAR2	(491)
BUSINESS_GROUP	VARCHAR2	(240)
PERSON_NUM	VARCHAR2	(30)
FULL_NAME	VARCHAR2	(240)
LAST_NAME	VARCHAR2	(150)
START_DATE	DATE
END_DATE	DATE
EMPLOYEE_FLAG	VARCHAR2	(4000)
APPLICANT_FLAG	VARCHAR2	(4000)
BUYER_FLAG	VARCHAR2	(4000)
PLANNER_FLAG	VARCHAR2	(4000)
SALES_REP_FLAG	VARCHAR2	(4000)
SYS_GEN_FLAG	VARCHAR2	(4000)
INSTANCE	VARCHAR2	(30)
PERSON_ID	NUMBER
SALESREP_ID	NUMBER
PLANNER_CODE	VARCHAR2	(10)
ORGANIZATION_ID	NUMBER
EFFECTIVE_START_DATE	DATE
EFFECTIVE_END_DATE	DATE
FIRST_NAME	VARCHAR2	(150)
MIDDLE_NAMES	VARCHAR2	(60)
PREVIOUS_LAST_NAME	VARCHAR2	(150)
KNOWN_AS	VARCHAR2	(80)
TITLE	VARCHAR2	(4000)
NAME_SUFFIX	VARCHAR2	(30)
NAME_PREFIX	VARCHAR2	(30)
EMAIL_ADDRESS	VARCHAR2	(240)
MARITAL_STATUS	VARCHAR2	(4000)
REHIRE_RCMMNDTN	VARCHAR2	(4000)
CRRSPNDNC_LANGUAGE	VARCHAR2	(30)
DATE_EMP_DATA_VRFD	DATE
DISABILITY_FLAG	VARCHAR2	(4000)
RESUME_UPDATED_DATE	DATE
RESUME_EXISTS	VARCHAR2	(4000)
GENDER	VARCHAR2	(4000)
INTERNAL_LOCATION	VARCHAR2	(45)
MAILSTOP	VARCHAR2	(45)
FAST_PATH_EMPLOYEE	VARCHAR2	(4000)
NATIONAL_IDENTIFIER	VARCHAR2	(30)
DATE_OF_BIRTH	DATE
FTE_CAPACITY	NUMBER
STUDENT_STATUS	VARCHAR2	(4000)
TOWN_OF_BIRTH	VARCHAR2	(90)
REGION_OF_BIRTH	VARCHAR2	(90)
COUNTRY_OF_BIRTH	VARCHAR2	(80)
NATIONALITY	VARCHAR2	(4000)
GLOBAL_PERSON_ID	VARCHAR2	(30)
CREATION_DATE	DATE
LAST_UPDATE_DATE	DATE
USER_ATTRIBUTE1	VARCHAR2	(0)
USER_ATTRIBUTE2	VARCHAR2	(0)
USER_ATTRIBUTE3	VARCHAR2	(0)
USER_ATTRIBUTE4	VARCHAR2	(0)
USER_ATTRIBUTE5	VARCHAR2	(0)

Query Text

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


SELECT ASSIGNMENT_PK
,      ALL_FK
,      SPRVSR_LVL1_FK
,      NAME
,      PERSON_DP
,      BUSINESS_GROUP
,      PERSON_NUM
,      FULL_NAME
,      LAST_NAME
,      START_DATE
,      END_DATE
,      EMPLOYEE_FLAG
,      APPLICANT_FLAG
,      BUYER_FLAG
,      PLANNER_FLAG
,      SALES_REP_FLAG
,      SYS_GEN_FLAG
,      INSTANCE
,      PERSON_ID
,      SALESREP_ID
,      PLANNER_CODE
,      ORGANIZATION_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      FIRST_NAME
,      MIDDLE_NAMES
,      PREVIOUS_LAST_NAME
,      KNOWN_AS
,      TITLE
,      NAME_SUFFIX
,      NAME_PREFIX
,      EMAIL_ADDRESS
,      MARITAL_STATUS
,      REHIRE_RCMMNDTN
,      CRRSPNDNC_LANGUAGE
,      DATE_EMP_DATA_VRFD
,      DISABILITY_FLAG
,      RESUME_UPDATED_DATE
,      RESUME_EXISTS
,      GENDER
,      INTERNAL_LOCATION
,      MAILSTOP
,      FAST_PATH_EMPLOYEE
,      NATIONAL_IDENTIFIER
,      DATE_OF_BIRTH
,      FTE_CAPACITY
,      STUDENT_STATUS
,      TOWN_OF_BIRTH
,      REGION_OF_BIRTH
,      COUNTRY_OF_BIRTH
,      NATIONALITY
,      GLOBAL_PERSON_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
FROM APPS.EDW_HR_PERM_ASSIGN_LCV;

Dependencies

[top of page]

APPS.EDW_HR_PERM_ASSIGN_LCV references the following:

APPS: EDWBV_HR_PERM_ASSIGN_LCV; HRI_EDW_DIM_PERSON - show dependent code; HR_GENERAL - show dependent code

APPS.EDW_HR_PERM_ASSIGN_LCV is referenced by following:

APPS: HRI_EDW_DIM_SIZING - show dependent code