[Home] [Help] [Dependency Information]

VIEW: APPS.FA_EMP_ASSET_WEB_V

Object Details

Object Name:	FA_EMP_ASSET_WEB_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OFA.FA_EMP_ASSET_WEB_V
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

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

SELECT DISTRIBUTION_ID
,      BOOK_TYPE_CODE
,      UNITS_ASSIGNED
,      CODE_COMBINATION_ID
,      LOCATION_ID
,      TRANSACTION_HEADER_ID_IN
,      DIST_DATE_EFFECTIVE
,      DIST_DATE_INEFFECTIVE
,      ASSIGNED_TO
,      TRANSACTION_HEADER_ID_OUT
,      TRANSACTION_UNITS
,      RETIREMENT_ID
,      PERSON_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      PERSON_TYPE_ID
,      LAST_NAME
,      START_DATE
,      APPLICANT_NUMBER
,      COMMENT_ID
,      CURRENT_APPLICANT_FLAG
,      CURRENT_EMP_OR_APL_FLAG
,      CURRENT_EMPLOYEE_FLAG
,      DATE_EMPLOYEE_DATA_VERIFIED
,      DATE_OF_BIRTH
,      EMAIL_ADDRESS
,      EMPLOYEE_NUMBER
,      EXPENSE_CHECK_SEND_TO_ADDRESS
,      FIRST_NAME
,      FULL_NAME
,      KNOWN_AS
,      MARITAL_STATUS
,      MIDDLE_NAMES
,      NATIONALITY
,      NATIONAL_IDENTIFIER
,      PREVIOUS_LAST_NAME
,      REGISTERED_DISABLED_FLAG
,      SEX
,      TITLE
,      VENDOR_ID
,      WORK_TELEPHONE
,      PER_INFORMATION_CATEGORY
,      PER_INFORMATION1
,      PER_INFORMATION2
,      PER_INFORMATION3
,      PER_INFORMATION4
,      PER_INFORMATION5
,      PER_INFORMATION6
,      PER_INFORMATION7
,      PER_INFORMATION8
,      PER_INFORMATION9
,      PER_INFORMATION10
,      PER_INFORMATION11
,      PER_INFORMATION12
,      PER_INFORMATION13
,      PER_INFORMATION14
,      PER_INFORMATION15
,      PER_INFORMATION16
,      PER_INFORMATION17
,      PER_INFORMATION18
,      PER_INFORMATION19
,      PER_INFORMATION20
,      ASSET_ID
,      ASSET_NUMBER
,      ASSET_KEY_CCID
,      CURRENT_UNITS
,      ASSET_TYPE
,      TAG_NUMBER
,      ASSET_DESCRIPTION
,      ASSET_CATEGORY_ID
,      PARENT_ASSET_ID
,      MANUFACTURER_NAME
,      SERIAL_NUMBER
,      MODEL_NUMBER
,      PROPERTY_TYPE_CODE
,      PROPERTY_1245_1250_CODE
,      IN_USE_FLAG
,      OWNED_LEASED
,      NEW_USED
,      UNIT_ADJUSTMENT_FLAG
,      ADD_COST_JE_FLAG
,      LEASE_ID
,      CATEGORY_TYPE
,      CAPITALIZE_FLAG
,      ASSET_KEY
,      CATEGORY
,      LOC_CONC_SEGMENTS
,      ACCT_CONC_SEGMENTS
FROM APPS.FA_EMP_ASSET_WEB_V;

Dependencies

[top of page]

APPS

FA_ADDITIONS

FA_ASSET_KEYWORDS

FA_CATEGORIES

FA_CATEGORIES_B_KFV

FA_DISTRIBUTION_HISTORY

FA_LOCATIONS_KFV

GL_CODE_COMBINATIONS_KFV

HR_SECURITY - show dependent code

PER_ALL_PEOPLE_F

APPS.FA_EMP_ASSET_WEB_V is not referenced by any database object