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


VIEW: APPS.HR_TAX_UNITS_V

Object Details
Object Name: HR_TAX_UNITS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_TAX_UNITS_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
TAX_UNIT_ID NUMBER (15) Yes
BUSINESS_GROUP_ID NUMBER


NAME VARCHAR2 (240) Yes
DATE_FROM DATE
Yes
DATE_TO DATE


TYPE VARCHAR2 (30)

INTERNAL_ADDRESS_LINE VARCHAR2 (80)

COMMENTS LONG (0)

LOCATION_ID NUMBER (15)

EMPLOYER_IDENTIFICATION_NUMBER VARCHAR2 (150)

EEO1_IDENTIFICATION_NUMBER VARCHAR2 (150)

VETS100_COMPANY_NUMBER VARCHAR2 (150)

DUN_AND_BRADSTREET_NUMBER VARCHAR2 (150)

EEO1_REPORTING_NAME VARCHAR2 (150)

VETS100_REPORTING_NAME VARCHAR2 (150)

AFFILIATED_FLAG VARCHAR2 (150)

GOVERNMENT_CONTRACTOR_FLAG VARCHAR2 (150)

W2_TRANSMITTER VARCHAR2 (150)

SQWL_TRANSMITTER VARCHAR2 (150)

US_1099R_TRANSMITTER VARCHAR2 (150)
US_1099R_TRANSMITTER_CODE VARCHAR2 (150)
US_1099R_BUREAU_FLAG VARCHAR2 (150)
US_1099R_COMBINED_FILING_FLAG VARCHAR2 (150)
ADDRESS_LINE_1 VARCHAR2 (240)

ADDRESS_LINE_2 VARCHAR2 (240)

ADDRESS_LINE_3 VARCHAR2 (240)

TOWN_OR_CITY VARCHAR2 (30)

STATE_CODE VARCHAR2 (120)

ZIP_CODE VARCHAR2 (30)

COUNTRY_CODE VARCHAR2 (60)

MWS_TRANSMITTER VARCHAR2 (150)
MWS_TITLE VARCHAR2 (150)
MWS_TELEPHONE_NO VARCHAR2 (150)
MWS_TRADE_NAME VARCHAR2 (150)
MWS_TAPE_MEDIUM VARCHAR2 (150)
MWS_TAPE_DENSITY VARCHAR2 (150)
MWS_HEADER_LABEL VARCHAR2 (150)
MWS_STATE VARCHAR2 (150)
MWS_STATE_UI_ACCOUNT VARCHAR2 (150)
AUTOMATE_SUI_WAGE_CREDIT VARCHAR2 (150)
Query Text

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


SELECT TAX_UNIT_ID
,      BUSINESS_GROUP_ID
,      NAME
,      DATE_FROM
,      DATE_TO
,      TYPE
,      INTERNAL_ADDRESS_LINE
,      COMMENTS
,      LOCATION_ID
,      EMPLOYER_IDENTIFICATION_NUMBER
,      EEO1_IDENTIFICATION_NUMBER
,      VETS100_COMPANY_NUMBER
,      DUN_AND_BRADSTREET_NUMBER
,      EEO1_REPORTING_NAME
,      VETS100_REPORTING_NAME
,      AFFILIATED_FLAG
,      GOVERNMENT_CONTRACTOR_FLAG
,      W2_TRANSMITTER
,      SQWL_TRANSMITTER
,      US_1099R_TRANSMITTER
,      US_1099R_TRANSMITTER_CODE
,      US_1099R_BUREAU_FLAG
,      US_1099R_COMBINED_FILING_FLAG
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      TOWN_OR_CITY
,      STATE_CODE
,      ZIP_CODE
,      COUNTRY_CODE
,      MWS_TRANSMITTER
,      MWS_TITLE
,      MWS_TELEPHONE_NO
,      MWS_TRADE_NAME
,      MWS_TAPE_MEDIUM
,      MWS_TAPE_DENSITY
,      MWS_HEADER_LABEL
,      MWS_STATE
,      MWS_STATE_UI_ACCOUNT
,      AUTOMATE_SUI_WAGE_CREDIT
FROM APPS.HR_TAX_UNITS_V;

Dependencies

[top of page]

APPS.HR_TAX_UNITS_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
SynonymHR_ORGANIZATION_INFORMATION
APPS.HR_TAX_UNITS_V is referenced by following:

SchemaAPPS
Package BodyBEN_BATCH_UTILS - show dependent code
Package BodyBEN_EXTRACT_SEED - show dependent code
Package BodyBEN_PLAN_DESIGN_TXNS_API - show dependent code
Package BodyBEN_XCV_BUS - show dependent code
Package BodyGHR_SF52_DO_UPDATE - show dependent code
Package BodyHR_PUMP_GET - show dependent code
Package BodyHR_SCL_FLEX - show dependent code
Package BodyPAY_AU_BAL_UPLOAD - show dependent code
Package BodyPAY_BALANCE_UPLOAD - show dependent code
Package BodyPAY_CA_BAL_UPLOAD - show dependent code
Package BodyPAY_CN_BAL_UPLOAD - show dependent code
Package BodyPAY_HK_BAL_UPLOAD - show dependent code
PL/SQL PackagePAY_MWS_MAGTAPE_REPORTING - show dependent code
Package BodyPAY_PAYRPVPR_XMLP_PKG - show dependent code
Package BodyPAY_SG_BAL_UPLOAD - show dependent code
ViewPAY_US_CONTRIBUTION_HISTORY_V
ViewPAY_US_GTN_TAX_UNITS_V
Package BodyPAY_US_INDIANA - show dependent code
Package BodyPAY_US_LOC_CHANGE - show dependent code
Package BodyPAY_US_MAGTAPE_REPORTING - show dependent code
PL/SQL PackagePAY_US_MAGW2_REPORTING - show dependent code
Package BodyPAY_WF_PKG - show dependent code
ViewPER_MM_ASSIGNMENTS_V
Package BodyPER_PERCACEI_XMLP_PKG - show dependent code
PL/SQL PackagePER_US_VETC_TAP - show dependent code
Package BodyTRR_ENGINE_PKG - show dependent code
SchemaPUBLIC
SynonymHR_TAX_UNITS_V