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

VIEW: APPS.HRI_TO_WMV_CNT_X_V

Object Details
Object Name: HRI_TO_WMV_CNT_X_V
Object Type: VIEW
Owner: APPS
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 Mandatory Comments
PRIMARY_ASG_INDICATOR NUMBER

ASG_INDICATOR NUMBER

WMV NUMBER

WMT_CODE VARCHAR2 (30) Yes
ASSIGNMENT_ID NUMBER (10) Yes
PERSON_ID NUMBER (10) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
ORGANIZATION_ID NUMBER (15) Yes
GEO_AREA_CODE VARCHAR2 (60) Yes
GEO_COUNTRY_CODE VARCHAR2 (100) Yes
GEO_REGION_CODE VARCHAR2 (252) Yes
LOCATION_ID NUMBER

JOB_ID NUMBER

GRADE_ID NUMBER

POSITION_ID NUMBER

ASSIGNMENT_STATUS_TYPE_ID NUMBER (9) Yes
ASSIGNMENT_TYPE_CODE VARCHAR2 (1) Yes
PER_SYSTEM_STATUS_CODE VARCHAR2 (30)
PAY_SYSTEM_STATUS_CODE VARCHAR2 (1)
Query Text

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


SELECT PRIMARY_ASG_INDICATOR
,      ASG_INDICATOR
,      WMV
,      WMT_CODE
,      ASSIGNMENT_ID
,      PERSON_ID
,      BUSINESS_GROUP_ID
,      ORGANIZATION_ID
,      GEO_AREA_CODE
,      GEO_COUNTRY_CODE
,      GEO_REGION_CODE
,      LOCATION_ID
,      JOB_ID
,      GRADE_ID
,      POSITION_ID
,      ASSIGNMENT_STATUS_TYPE_ID
,      ASSIGNMENT_TYPE_CODE
,      PER_SYSTEM_STATUS_CODE
,      PAY_SYSTEM_STATUS_CODE
FROM APPS.HRI_TO_WMV_CNT_X_V;

Dependencies

[top of page]

APPS.HRI_TO_WMV_CNT_X_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewHRI_CL_WMT_X_V
SynonymHRI_CS_GEO_LOCHR_CT
ViewHRI_MD_WMV_X_V
PL/SQL PackageHR_API - show dependent code
PL/SQL PackageHR_BIS - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
APPS.HRI_TO_WMV_CNT_X_V is referenced by following:

SchemaPUBLIC
SynonymHRI_TO_WMV_CNT_X_V