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

VIEW: APPS.HR_FR_WORK_CERT_JOBS_V

Object Details
Object Name: HR_FR_WORK_CERT_JOBS_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
FULL_NAME VARCHAR2 (240)
ESTABLISHMENT_NAME VARCHAR2 (240) Yes
COMPANY_NAME VARCHAR2 (240) Yes
SIRET VARCHAR2 (150)
NAF VARCHAR2 (150)
EMPLOYEE_ADDRESS VARCHAR2 (4000)
COMPANY_ADDRESS VARCHAR2 (4000)
ESTABLISHMENT_ADDRESS VARCHAR2 (4000)
ASSIGNMENT_ID NUMBER (10) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
PERSON_ID NUMBER (10) Yes
DATE_START DATE
Yes
LAST_DAY_PAID VARCHAR2 (9)
PERIOD_OF_SERVICE_ID NUMBER (9) Yes
CONCATENATED_JOB_DETAILS VARCHAR2 (4000)
Query Text

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


SELECT FIRST_NAME
,      LAST_NAME
,      FULL_NAME
,      ESTABLISHMENT_NAME
,      COMPANY_NAME
,      SIRET
,      NAF
,      EMPLOYEE_ADDRESS
,      COMPANY_ADDRESS
,      ESTABLISHMENT_ADDRESS
,      ASSIGNMENT_ID
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      DATE_START
,      LAST_DAY_PAID
,      PERIOD_OF_SERVICE_ID
,      CONCATENATED_JOB_DETAILS
FROM APPS.HR_FR_WORK_CERT_JOBS_V;

Dependencies

[top of page]

APPS.HR_FR_WORK_CERT_JOBS_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_FR_SETTLEMENT - show dependent code
SynonymPER_ADDRESSES
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
PL/SQL PackagePER_FR_WORK_CERT - show dependent code
SynonymPER_PERIODS_OF_SERVICE
APPS.HR_FR_WORK_CERT_JOBS_V is referenced by following:

SchemaAPPS
ViewHR_FR_WORK_CERT_V