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

VIEW: APPS.HR_FR_TERMINATION_V

Object Details
Object Name: HR_FR_TERMINATION_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
FIRST_NAME VARCHAR2 (150)
LAST_NAME VARCHAR2 (150) Yes
TITLE VARCHAR2 (30)
ESTABLISHMENT_NAME VARCHAR2 (240) Yes
SIRET VARCHAR2 (150)
NAF VARCHAR2 (150)
COMPANY_NAME VARCHAR2 (240) Yes
ADDRESS VARCHAR2 (4000)
COMPANY_ADDRESS VARCHAR2 (4000)
ESTABLISHMENT_ADDRESS VARCHAR2 (4000)
LAST_DAY_PAID VARCHAR2 (9)
PAYMENT_IN_WORDS VARCHAR2 (4000)
ASSIGNMENT_ID NUMBER (10) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
DATE_START DATE
Yes
PERIOD_OF_SERVICE_ID NUMBER (9) Yes
USER_PERSON_TYPE VARCHAR2 (0)
PERSON_ID NUMBER (10) Yes
FULL_NAME VARCHAR2 (4000)
Query Text

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


SELECT FIRST_NAME
,      LAST_NAME
,      TITLE
,      ESTABLISHMENT_NAME
,      SIRET
,      NAF
,      COMPANY_NAME
,      ADDRESS
,      COMPANY_ADDRESS
,      ESTABLISHMENT_ADDRESS
,      LAST_DAY_PAID
,      PAYMENT_IN_WORDS
,      ASSIGNMENT_ID
,      BUSINESS_GROUP_ID
,      DATE_START
,      PERIOD_OF_SERVICE_ID
,      USER_PERSON_TYPE
,      PERSON_ID
,      FULL_NAME
FROM APPS.HR_FR_TERMINATION_V;

Dependencies

[top of page]

APPS.HR_FR_TERMINATION_V references the following:

SchemaAPPS
PL/SQL PackageFND_DATE - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
SynonymHR_ORGANIZATION_INFORMATION
PL/SQL PackagePAY_CA_AMT_IN_WORDS - show dependent code
PL/SQL PackagePAY_FR_SETTLEMENT - show dependent code
SynonymPER_ADDRESSES
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
SynonymPER_PERIODS_OF_SERVICE

APPS.HR_FR_TERMINATION_V is not referenced by any database object