[Home] [Help] [Dependency Information]

VIEW: APPS.HR_WORKSITE_V

Object Details

Object Name:	HR_WORKSITE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HR_WORKSITE_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

Query Text

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

SELECT MWS_TAX_UNIT_ID
,      MWS_BUSINESS_GROUP_ID
,      MWS_PRIMARY_WORKSITE_ORG_ID
,      MWS_SUI_ACCOUNT_NO
,      MWS_REPORTING_UNIT_NO
,      MWS_TRADE_NAME
,      MWS_WORKSITE_DESCRIPTION
,      MWS_COMMENT_CODE1
,      MWS_COMMENT_CODE2
,      MWS_COMMENTS
,      MWS_ADDRESS_LINE_1
,      MWS_ADDRESS_LINE_2
,      MWS_ADDRESS_LINE_3
,      MWS_CITY
,      MWS_STATE
,      MWS_ZIP_CODE
FROM APPS.HR_WORKSITE_V;

Dependencies

[top of page]

APPS

HR_GENERAL - show dependent code

HR_LOCATIONS

HR_ORGANIZATION_INFORMATION

HR_ORGANIZATION_UNITS

HR_SECURITY - show dependent code

APPS

PAY_MWS_MAGTAPE_REPORTING - show dependent code

PUBLIC

HR_WORKSITE_V