[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | HR_LOCATION_EXTRA_INFO1_DFV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| TYPE | VARCHAR2 | (30) | ||
| LOCATION_CODE | VARCHAR2 | (150) | ||
| COTR_OFFICE | VARCHAR2 | (150) | ||
| ISSUING_OFFICE | VARCHAR2 | (150) | ||
| PRO_ADMIN_OFFICE | VARCHAR2 | (150) | ||
| PAY_OFFICE | VARCHAR2 | (150) | ||
| REQ_OFFICE | VARCHAR2 | (150) | ||
| SBA_OFFICE | VARCHAR2 | (150) | ||
| INV_OFFICE | VARCHAR2 | (150) | ||
| ADMIN_OFFICE | VARCHAR2 | (150) | ||
| ASSIST_OFFICE | VARCHAR2 | (150) | ||
| BUNDESLAND | VARCHAR2 | (150) | ||
| PRODUCTION_UNIT_CODE | VARCHAR2 | (150) | ||
| YEAR_FILED | NUMBER | |||
| CONCURRENT_REQUEST_ID | VARCHAR2 | (150) | ||
| TOTMF | NUMBER | |||
| WHITEMALE | NUMBER | |||
| BLACKMALE | NUMBER | |||
| HOPMALE | NUMBER | |||
| ASIANMALE | NUMBER | |||
| AMERINDMALE | NUMBER | |||
| WHITEFEM | NUMBER | |||
| BLACKFEM | NUMBER | |||
| HOPFEMALE | NUMBER | |||
| ASIANFEMALE | NUMBER | |||
| AMERINDFEM | NUMBER | |||
| HLMALE | NUMBER | |||
| HLFEMALE | NUMBER | |||
| TMRMALE | NUMBER | |||
| TMRFEMALE | NUMBER | |||
| REPORTING_NAME | VARCHAR2 | (150) | ||
| UNIT_NUMBER | VARCHAR2 | (150) | ||
| APPRENTICES_EMPLOYED | VARCHAR2 | (150) | ||
| GOVERNMENT_CONTRACTOR | VARCHAR2 | (150) | ||
| REPORTED_PREVIOUSLY | VARCHAR2 | (150) | ||
| MAIN_ACTIVITIES__LINE_1_ | VARCHAR2 | (150) | ||
| MAIN_ACTIVITIES__LINE_2_ | VARCHAR2 | (150) | ||
| MAIN_ACTIVITIES__LINE_3_ | VARCHAR2 | (150) | ||
| MAIN_ACTIVITIES__LINE_4_ | VARCHAR2 | (150) | ||
| DUNS_NUMBER | VARCHAR2 | (150) | ||
| SIC_NUMBER | VARCHAR2 | (150) | ||
| NAICS_NUMBER | VARCHAR2 | (150) | ||
| FEIN_NUMBER | VARCHAR2 | (150) | ||
| HEADQUARTERS_ESTABLISHMENT | VARCHAR2 | (150) | ||
| DUTY_STATION_CODE | VARCHAR2 | (150) | ||
| DOCUMENT_TYPE | VARCHAR2 | (150) | ||
| ONLINE_DOC | VARCHAR2 | (150) | ||
| PAPER_DOC | VARCHAR2 | (150) | ||
| TEMPLATE | VARCHAR2 | (150) | ||
| XML_CODE | VARCHAR2 | (150) | ||
| EFFECTIVE_DATE | DATE | |||
| DISPLAY_RATE_DETAILS_SECTION | VARCHAR2 | (150) | ||
| COMPANY_NAME | VARCHAR2 | (150) | ||
| POSTAL_CODE | VARCHAR2 | (150) | ||
| TOWN_OR_CITY | VARCHAR2 | (150) | ||
| COUNTY | VARCHAR2 | (150) | ||
| MAILING_LOCATION_NAME | VARCHAR2 | (150) | ||
| MAILING_LOCATION_TYPE | VARCHAR2 | (150) | ||
| MAILING_STREET_NUMBER | VARCHAR2 | (150) | ||
| COUNTRY | VARCHAR2 | (150) | ||
| TELEPHONE | VARCHAR2 | (150) | ||
| FAX | VARCHAR2 | (150) | ||
| REPORTING_UNIT_NUMBER | NUMBER | |||
| TRADE_NAME | VARCHAR2 | (150) | ||
| WORK_SITE_DESCRIPTION | VARCHAR2 | (150) | ||
| COMMENT_CODE_1 | NUMBER | |||
| COMMENT_CODE_2 | NUMBER | |||
| COMMENT_CODE_3 | NUMBER | |||
| COMMENT_FREE_TXT | VARCHAR2 | (150) | ||
| HOUSE_NUMBER | VARCHAR2 | (150) | ||
| HOUSE_NUMBER_ADDITION | VARCHAR2 | (150) | ||
| STREET_NAME | VARCHAR2 | (150) | ||
| ADDRESS_LINE1 | VARCHAR2 | (150) | ||
| ADDRESS_LINE2 | VARCHAR2 | (150) | ||
| ADDRESS_LINE3 | VARCHAR2 | (150) | ||
| CITY | VARCHAR2 | (150) | ||
| PROVINCE | VARCHAR2 | (150) | ||
| PO_BOX_NUMBER | VARCHAR2 | (150) | ||
| CONTACT | VARCHAR2 | (150) | ||
| GEO_HIER_NODE | VARCHAR2 | (150) | ||
| DATE_FROM | DATE | |||
| DATE_TO | DATE | |||
| STREET_TYPE | VARCHAR2 | (150) | ||
| FLAT_NUMBER | VARCHAR2 | (150) | ||
| POST_CODE | VARCHAR2 | (150) | ||
| TOWN | VARCHAR2 | (150) | ||
| DISTRICT | VARCHAR2 | (150) | ||
| COMMUNITY | VARCHAR2 | (150) | ||
| POST | VARCHAR2 | (150) | ||
| MOBILE | VARCHAR2 | (150) | ||
| POST_BOX | VARCHAR2 | (150) | ||
| REPORTS_THROUGH_LEA | VARCHAR2 | (150) | ||
| ESTABLISHMENT_NUMBER | NUMBER | |||
| ESTABLISHMENT_NAME | VARCHAR2 | (150) | ||
| ESTABLISHMENT_TYPE | VARCHAR2 | (150) | ||
| SCHOOL_NUMBER | NUMBER | |||
| LEA_NUMBER | VARCHAR2 | (150) | ||
| ADDRESS_LINE_1 | VARCHAR2 | (150) | ||
| ADDRESS_LINE_2 | VARCHAR2 | (150) | ||
| ADDRESS_LINE_3 | VARCHAR2 | (150) | ||
| PAYPNT | VARCHAR2 | (150) | ||
| LOCATN | VARCHAR2 | (150) | ||
| ZIP_CODE | NUMBER | |||
| PLACE_OKATO_ | VARCHAR2 | (150) | ||
| REGION_DISTRICT | VARCHAR2 | (150) | ||
| STREET | VARCHAR2 | (150) | ||
| BUILDING | VARCHAR2 | (150) | ||
| OFFICE_NUMBER | VARCHAR2 | (150) | ||
| COST_CENTER | VARCHAR2 | (150) | ||
| DISPLAY_SSN_ON_EMPLOYEE_REPORT | VARCHAR2 | (150) | ||
| COMPLEX | VARCHAR2 | (150) | ||
| STREET_NUMBER | VARCHAR2 | (150) | ||
| STREET_OR_NAME_OF_FARM | VARCHAR2 | (150) | ||
| SUBURB_OR_DISTRICT | VARCHAR2 | (150) | ||
| CONCATENATED_SEGMENTS | VARCHAR2 | (2597) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, TYPE
, LOCATION_CODE
, COTR_OFFICE
, ISSUING_OFFICE
, PRO_ADMIN_OFFICE
, PAY_OFFICE
, REQ_OFFICE
, SBA_OFFICE
, INV_OFFICE
, ADMIN_OFFICE
, ASSIST_OFFICE
, BUNDESLAND
, PRODUCTION_UNIT_CODE
, YEAR_FILED
, CONCURRENT_REQUEST_ID
, TOTMF
, WHITEMALE
, BLACKMALE
, HOPMALE
, ASIANMALE
, AMERINDMALE
, WHITEFEM
, BLACKFEM
, HOPFEMALE
, ASIANFEMALE
, AMERINDFEM
, HLMALE
, HLFEMALE
, TMRMALE
, TMRFEMALE
, REPORTING_NAME
, UNIT_NUMBER
, APPRENTICES_EMPLOYED
, GOVERNMENT_CONTRACTOR
, REPORTED_PREVIOUSLY
, MAIN_ACTIVITIES__LINE_1_
, MAIN_ACTIVITIES__LINE_2_
, MAIN_ACTIVITIES__LINE_3_
, MAIN_ACTIVITIES__LINE_4_
, DUNS_NUMBER
, SIC_NUMBER
, NAICS_NUMBER
, FEIN_NUMBER
, HEADQUARTERS_ESTABLISHMENT
, DUTY_STATION_CODE
, DOCUMENT_TYPE
, ONLINE_DOC
, PAPER_DOC
, TEMPLATE
, XML_CODE
, EFFECTIVE_DATE
, DISPLAY_RATE_DETAILS_SECTION
, COMPANY_NAME
, POSTAL_CODE
, TOWN_OR_CITY
, COUNTY
, MAILING_LOCATION_NAME
, MAILING_LOCATION_TYPE
, MAILING_STREET_NUMBER
, COUNTRY
, TELEPHONE
, FAX
, REPORTING_UNIT_NUMBER
, TRADE_NAME
, WORK_SITE_DESCRIPTION
, COMMENT_CODE_1
, COMMENT_CODE_2
, COMMENT_CODE_3
, COMMENT_FREE_TXT
, HOUSE_NUMBER
, HOUSE_NUMBER_ADDITION
, STREET_NAME
, ADDRESS_LINE1
, ADDRESS_LINE2
, ADDRESS_LINE3
, CITY
, PROVINCE
, PO_BOX_NUMBER
, CONTACT
, GEO_HIER_NODE
, DATE_FROM
, DATE_TO
, STREET_TYPE
, FLAT_NUMBER
, POST_CODE
, TOWN
, DISTRICT
, COMMUNITY
, POST
, MOBILE
, POST_BOX
, REPORTS_THROUGH_LEA
, ESTABLISHMENT_NUMBER
, ESTABLISHMENT_NAME
, ESTABLISHMENT_TYPE
, SCHOOL_NUMBER
, LEA_NUMBER
, ADDRESS_LINE_1
, ADDRESS_LINE_2
, ADDRESS_LINE_3
, PAYPNT
, LOCATN
, ZIP_CODE
, PLACE_OKATO_
, REGION_DISTRICT
, STREET
, BUILDING
, OFFICE_NUMBER
, COST_CENTER
, DISPLAY_SSN_ON_EMPLOYEE_REPORT
, COMPLEX
, STREET_NUMBER
, STREET_OR_NAME_OF_FARM
, SUBURB_OR_DISTRICT
, CONCATENATED_SEGMENTS
FROM APPS.HR_LOCATION_EXTRA_INFO1_DFV;
APPS
FND_NUMBER
- show dependent code
HR_LOCATION_EXTRA_INFO
APPS.HR_LOCATION_EXTRA_INFO1_DFV is not referenced by any database object
|
|
|
|