[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PQH_COPY_ENTITY_ATTRIBS_DFV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| CONTEXT_VALUE | VARCHAR2 | (30) | ||
| NAME | VARCHAR2 | (2000) | ||
| JOB | VARCHAR2 | (255) | ||
| ORGANIZATION | VARCHAR2 | (2000) | ||
| BUSINESS_GROUP | VARCHAR2 | (255) | ||
| HIRING_STATUS | VARCHAR2 | (255) | ||
| LOCATION | VARCHAR2 | (255) | ||
| START_DATE | DATE | |||
| HEAD_COUNT | NUMBER | |||
| DATE_END | DATE | |||
| STATUS | VARCHAR2 | (255) | ||
| SUCCESSOR_POSITION | VARCHAR2 | (255) | ||
| EFFECTIVE_DATE | DATE | |||
| SUPERVISOR | VARCHAR2 | (255) | ||
| SUPERVISOR_POSITION | VARCHAR2 | (255) | ||
| EARLIEST_HIRE_DATE | DATE | |||
| FILL_BY_DATE | DATE | |||
| FTE | NUMBER | |||
| GRADE | VARCHAR2 | (2000) | ||
| POSITION_STATUS | VARCHAR2 | (255) | ||
| PERMANENT_FLAG | VARCHAR2 | (255) | ||
| PERMIT_RECRUITING | VARCHAR2 | (2000) | ||
| POSITION_TYPE | VARCHAR2 | (255) | ||
| WORKING_HRS | NUMBER | |||
| FREQUENCY | VARCHAR2 | (255) | ||
| BARGAINING_UNIT | VARCHAR2 | (2000) | ||
| HIRING_PROPOSED_END_DATE | DATE | |||
| POSITION | VARCHAR2 | (255) | ||
| GRADE_LADDER | VARCHAR2 | (2000) | ||
| PAYROLL | VARCHAR2 | (255) | ||
| ASSIGNMENT_STATUS | VARCHAR2 | (2000) | ||
| EMPLOYMENT_CATEGORY | VARCHAR2 | (2000) | ||
| SUPERVISOR_ASSIGNMENT | VARCHAR2 | (2000) | ||
| MANAGER | VARCHAR2 | (255) | ||
| SALARY_BASIS | VARCHAR2 | (255) | ||
| WORKING_HOURS | NUMBER | |||
| WORKING_FREQUENCY | VARCHAR2 | (2000) | ||
| START_TIME | VARCHAR2 | (2000) | ||
| FINISH_TIME | VARCHAR2 | (255) | ||
| HOURLY_SALARIED | VARCHAR2 | (2000) | ||
| UNION_MEMBER | VARCHAR2 | (255) | ||
| SUPPLIER_NAME | VARCHAR2 | (2000) | ||
| SUPPLIER_SITE | VARCHAR2 | (2000) | ||
| SALARY_REVIEW_PERIOD | NUMBER | |||
| SALARY_REVIEW_FREQUENCY | VARCHAR2 | (255) | ||
| PERFORMANCE_REVIEW_PERIOD | NUMBER | |||
| PERFORMANCE_REVIEW_FREQUENCY | VARCHAR2 | (2000) | ||
| CHANGE_REASON | VARCHAR2 | (2000) | ||
| PROJECTED_END_DATE | DATE | |||
| ORGANIZATION_HIERARCHY | VARCHAR2 | (255) | ||
| ORG_HIERARCHY_NODE | VARCHAR2 | (255) | ||
| JOB_LIKE | VARCHAR2 | (255) | ||
| POSITION_LIKE | VARCHAR2 | (255) | ||
| POSITION_HIERARCHY | VARCHAR2 | (255) | ||
| POSITION_HIERARCHY_NODE | VARCHAR2 | (255) | ||
| GRADE_LIKE | VARCHAR2 | (255) | ||
| GRADE_LADDER_LIKE | VARCHAR2 | (2000) | ||
| PAYROLL_NAME | VARCHAR2 | (255) | ||
| PRIMARY_ASSIGNMENT | VARCHAR2 | (255) | ||
| ASSIGNMENT_CATEGORY | VARCHAR2 | (2000) | ||
| MANAGER_FLAG | VARCHAR2 | (255) | ||
| USER_PERSON_TYPE | VARCHAR2 | (255) | ||
| HIRE_DATE | DATE | |||
| INTERNAL_ADDRESS | VARCHAR2 | (255) | ||
| COLLECTIVE_AGREEMENT | VARCHAR2 | (2000) | ||
| ESTABLISHMENT | VARCHAR2 | (255) | ||
| HIERARCHY_NODE | VARCHAR2 | (255) | ||
| POSITION_NODE | VARCHAR2 | (255) | ||
| SYSTEM_PERSON_TYPE | VARCHAR2 | (255) | ||
| LATEST_HIRE_DATE | DATE | |||
| ESTABLISHMENT_ID | VARCHAR2 | (2000) | ||
| HOURLY_SALARIED_CODE | VARCHAR2 | (2000) | ||
| INTERNAL_ADDRESS_LINE | VARCHAR2 | (2000) | ||
| RECRUITMENT_ACTIVITY | VARCHAR2 | (255) | ||
| VACANCY | VARCHAR2 | (255) | ||
| PROJECTED_HIRE_DATE | DATE | |||
| RECRUITER | VARCHAR2 | (255) | ||
| REFERRED_BY | VARCHAR2 | (255) | ||
| RECRUITMENT_SOURCE_TYPE | VARCHAR2 | (255) | ||
| SOURCE_ORGANIZATION | VARCHAR2 | (255) | ||
| BARGAIN_UNIT | VARCHAR2 | (255) | ||
| HEADCOUNT | NUMBER | |||
| CONCATENATED_SEGMENTS | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CONTEXT_VALUE
, NAME
, JOB
, ORGANIZATION
, BUSINESS_GROUP
, HIRING_STATUS
, LOCATION
, START_DATE
, HEAD_COUNT
, DATE_END
, STATUS
, SUCCESSOR_POSITION
, EFFECTIVE_DATE
, SUPERVISOR
, SUPERVISOR_POSITION
, EARLIEST_HIRE_DATE
, FILL_BY_DATE
, FTE
, GRADE
, POSITION_STATUS
, PERMANENT_FLAG
, PERMIT_RECRUITING
, POSITION_TYPE
, WORKING_HRS
, FREQUENCY
, BARGAINING_UNIT
, HIRING_PROPOSED_END_DATE
, POSITION
, GRADE_LADDER
, PAYROLL
, ASSIGNMENT_STATUS
, EMPLOYMENT_CATEGORY
, SUPERVISOR_ASSIGNMENT
, MANAGER
, SALARY_BASIS
, WORKING_HOURS
, WORKING_FREQUENCY
, START_TIME
, FINISH_TIME
, HOURLY_SALARIED
, UNION_MEMBER
, SUPPLIER_NAME
, SUPPLIER_SITE
, SALARY_REVIEW_PERIOD
, SALARY_REVIEW_FREQUENCY
, PERFORMANCE_REVIEW_PERIOD
, PERFORMANCE_REVIEW_FREQUENCY
, CHANGE_REASON
, PROJECTED_END_DATE
, ORGANIZATION_HIERARCHY
, ORG_HIERARCHY_NODE
, JOB_LIKE
, POSITION_LIKE
, POSITION_HIERARCHY
, POSITION_HIERARCHY_NODE
, GRADE_LIKE
, GRADE_LADDER_LIKE
, PAYROLL_NAME
, PRIMARY_ASSIGNMENT
, ASSIGNMENT_CATEGORY
, MANAGER_FLAG
, USER_PERSON_TYPE
, HIRE_DATE
, INTERNAL_ADDRESS
, COLLECTIVE_AGREEMENT
, ESTABLISHMENT
, HIERARCHY_NODE
, POSITION_NODE
, SYSTEM_PERSON_TYPE
, LATEST_HIRE_DATE
, ESTABLISHMENT_ID
, HOURLY_SALARIED_CODE
, INTERNAL_ADDRESS_LINE
, RECRUITMENT_ACTIVITY
, VACANCY
, PROJECTED_HIRE_DATE
, RECRUITER
, REFERRED_BY
, RECRUITMENT_SOURCE_TYPE
, SOURCE_ORGANIZATION
, BARGAIN_UNIT
, HEADCOUNT
, CONCATENATED_SEGMENTS
FROM APPS.PQH_COPY_ENTITY_ATTRIBS_DFV;
APPS
FND_NUMBER
- show dependent code
PQH_COPY_ENTITY_ATTRIBS
APPS.PQH_COPY_ENTITY_ATTRIBS_DFV is not referenced by any database object
|
|
|
|