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


VIEW: APPS.PQH_CORPS_CAREER_PATHS_V

Object Details
Object Name: PQH_CORPS_CAREER_PATHS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPQH.PQH_CORPS_CAREER_PATHS_V
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
FROM_CORPS_NAME VARCHAR2 (240) Yes
FROM_CORPS_ID NUMBER (15) Yes
FROM_GRADE VARCHAR2 (4000)
FROM_GRADE_ID NUMBER

FROM_STEP VARCHAR2 (4000)
STARTING_GRADE_STEP_ID VARCHAR2 (255) Yes
FROM_SENIORITY VARCHAR2 (150)
FROM_SENIORITY_DESC VARCHAR2 (4000)
FROM_SENIORITY_UOM VARCHAR2 (150)
TO_CORPS_NAME VARCHAR2 (240) Yes
TO_CORPS_ID NUMBER (15) Yes
TO_SENIORITY VARCHAR2 (150)
TO_SENIORITY_UOM VARCHAR2 (150)
TO_SENIORITY_DESC VARCHAR2 (4000)
TO_GRADE VARCHAR2 (4000)
TO_STEP VARCHAR2 (4000)
TO_GRADE_ID NUMBER

ENDING_GRADE_STEP_ID VARCHAR2 (150)
NODE_ID NUMBER (15) Yes
OBJECT_VERSION_NUMBER NUMBER (9) Yes
Query Text

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


SELECT FROM_CORPS_NAME
,      FROM_CORPS_ID
,      FROM_GRADE
,      FROM_GRADE_ID
,      FROM_STEP
,      STARTING_GRADE_STEP_ID
,      FROM_SENIORITY
,      FROM_SENIORITY_DESC
,      FROM_SENIORITY_UOM
,      TO_CORPS_NAME
,      TO_CORPS_ID
,      TO_SENIORITY
,      TO_SENIORITY_UOM
,      TO_SENIORITY_DESC
,      TO_GRADE
,      TO_STEP
,      TO_GRADE_ID
,      ENDING_GRADE_STEP_ID
,      NODE_ID
,      OBJECT_VERSION_NUMBER
FROM APPS.PQH_CORPS_CAREER_PATHS_V;

Dependencies

[top of page]

APPS.PQH_CORPS_CAREER_PATHS_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
SynonymPER_GEN_HIERARCHY_NODES
PL/SQL PackagePQH_CORPS_COPY - show dependent code
SynonymPQH_CORPS_DEFINITIONS

APPS.PQH_CORPS_CAREER_PATHS_V is not referenced by any database object