Skip to content

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

VIEW: APPS.GHR_BREAKDOWN_V

Object Details
Object Name: GHR_BREAKDOWN_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGHR.GHR_BREAKDOWN_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
BREAKDOWN_CRITERIA_ID NUMBER (15)
Breakdown Criteria ID
FOR_CLAUSE VARCHAR2 (150)
For Clause
WITHIN_CLAUSE VARCHAR2 (150)
Within Clause
BY_CLAUSE VARCHAR2 (150)
By Clause
LINE CHAR (1)
LIne
TOTAL_ALL NUMBER

All Total
TOTAL_WOMEN NUMBER

Total Women
TOTAL_MEN NUMBER

Total Men
WHITE_WOMEN NUMBER

White Women
WHITE_MEN NUMBER

White Men
BLACK_WOMEN NUMBER

Black Women
BLACK_MEN NUMBER

Black Men
HISPANIC_WOMEN NUMBER

Hispanic Women
HISPANIC_MEN NUMBER

Hispanic Men
PAC_ISLANDER_WOMEN NUMBER

Pacific Islander Women
PAC_ISLANDER_MEN NUMBER

Pacific Islander Men
AMERINDIAN_ALASKAN_WOMEN NUMBER

American Indian Or Alaskan Women
AMERINDIAN_ALASKAN_MEN NUMBER

American Indian Or Alaskan Men
Query Text

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


SELECT BREAKDOWN_CRITERIA_ID
,      FOR_CLAUSE
,      WITHIN_CLAUSE
,      BY_CLAUSE
,      LINE
,      TOTAL_ALL
,      TOTAL_WOMEN
,      TOTAL_MEN
,      WHITE_WOMEN
,      WHITE_MEN
,      BLACK_WOMEN
,      BLACK_MEN
,      HISPANIC_WOMEN
,      HISPANIC_MEN
,      PAC_ISLANDER_WOMEN
,      PAC_ISLANDER_MEN
,      AMERINDIAN_ALASKAN_WOMEN
,      AMERINDIAN_ALASKAN_MEN
FROM APPS.GHR_BREAKDOWN_V;

Dependencies

[top of page]

APPS.GHR_BREAKDOWN_V references the following:

SchemaAPPS
SynonymGHR_BREAKDOWN_RESULTS
SchemaPUBLIC
SynonymDUAL
APPS.GHR_BREAKDOWN_V is referenced by following:

SchemaPUBLIC
SynonymGHR_BREAKDOWN_V