[Home] [Help] [Dependency Information]
Object Name: | PQH_CORPS_CAREER_PATHS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PQH.PQH_CORPS_CAREER_PATHS_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
APPS.PQH_CORPS_CAREER_PATHS_V is not referenced by any database object
|
|
|