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

VIEW: APPS.PER_PREVIOUS_JOBS1_DFV

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CONTEXT_VALUE VARCHAR2 (30)
TARIFF_CONTRACT VARCHAR2 (150)
GRADE VARCHAR2 (150)
LENGTH_OF_SERVICE VARCHAR2 (150)
REASON VARCHAR2 (150)
CORRECTION_FACTOR_IN_DAYS NUMBER

JOB_EXPERIENCE_CLASSIFICATION VARCHAR2 (150)
AGENT_TYPE VARCHAR2 (150)
CORPS VARCHAR2 (150)
STEP VARCHAR2 (150)
POSITION VARCHAR2 (150)
SENIORITY_MONTHS NUMBER

TYPE_OF_SERVICE VARCHAR2 (150)
TERRITORY_CONDITIONS VARCHAR2 (150)
SPECIAL_WORKING_CONDITIONS VARCHAR2 (150)
RECORD_OF_SERVICE_REASON VARCHAR2 (150)
RECORD_OF_SERVICE_REASON___ADD VARCHAR2 (150)
LONG_SERVICE_REASON VARCHAR2 (150)
LONG_SERVICE_REASON___ADD VARCHAR2 (150)
UNINTERRUPTED_SERVICE_RECORD VARCHAR2 (150)
CONCATENATED_SEGMENTS VARCHAR2 (1087)
Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      TARIFF_CONTRACT
,      GRADE
,      LENGTH_OF_SERVICE
,      REASON
,      CORRECTION_FACTOR_IN_DAYS
,      JOB_EXPERIENCE_CLASSIFICATION
,      AGENT_TYPE
,      CORPS
,      STEP
,      POSITION
,      SENIORITY_MONTHS
,      TYPE_OF_SERVICE
,      TERRITORY_CONDITIONS
,      SPECIAL_WORKING_CONDITIONS
,      RECORD_OF_SERVICE_REASON
,      RECORD_OF_SERVICE_REASON___ADD
,      LONG_SERVICE_REASON
,      LONG_SERVICE_REASON___ADD
,      UNINTERRUPTED_SERVICE_RECORD
,      CONCATENATED_SEGMENTS
FROM APPS.PER_PREVIOUS_JOBS1_DFV;

Dependencies

[top of page]

APPS.PER_PREVIOUS_JOBS1_DFV references the following:

SchemaAPPS
PL/SQL PackageFND_NUMBER - show dependent code
SynonymPER_PREVIOUS_JOBS

APPS.PER_PREVIOUS_JOBS1_DFV is not referenced by any database object