eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [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

Name	Datatype	Length
DISTRIBUTION_ID	NUMBER	(15)
BOOK_TYPE_CODE	VARCHAR2	(15)
UNITS_ASSIGNED	NUMBER
CODE_COMBINATION_ID	NUMBER	(15)
LOCATION_ID	NUMBER	(15)
TRANSACTION_HEADER_ID_IN	NUMBER	(15)
DIST_DATE_EFFECTIVE	DATE
DIST_DATE_INEFFECTIVE	DATE
ASSIGNED_TO	NUMBER	(15)
TRANSACTION_HEADER_ID_OUT	NUMBER	(15)
TRANSACTION_UNITS	NUMBER
RETIREMENT_ID	NUMBER	(15)
PERSON_ID	NUMBER
EFFECTIVE_START_DATE	DATE
EFFECTIVE_END_DATE	DATE
BUSINESS_GROUP_ID	NUMBER
PERSON_TYPE_ID	NUMBER
LAST_NAME	VARCHAR2	(150)
START_DATE	DATE
APPLICANT_NUMBER	VARCHAR2	(30)
COMMENT_ID	NUMBER
CURRENT_APPLICANT_FLAG	VARCHAR2	(30)
CURRENT_EMP_OR_APL_FLAG	VARCHAR2	(30)
CURRENT_EMPLOYEE_FLAG	VARCHAR2	(30)
DATE_EMPLOYEE_DATA_VERIFIED	DATE
DATE_OF_BIRTH	DATE
EMAIL_ADDRESS	VARCHAR2	(240)
EMPLOYEE_NUMBER	VARCHAR2	(30)
EXPENSE_CHECK_SEND_TO_ADDRESS	VARCHAR2	(30)
FIRST_NAME	VARCHAR2	(150)
FULL_NAME	VARCHAR2	(240)
KNOWN_AS	VARCHAR2	(80)
MARITAL_STATUS	VARCHAR2	(30)
MIDDLE_NAMES	VARCHAR2	(60)
NATIONALITY	VARCHAR2	(30)
NATIONAL_IDENTIFIER	VARCHAR2	(30)
PREVIOUS_LAST_NAME	VARCHAR2	(150)
REGISTERED_DISABLED_FLAG	VARCHAR2	(30)
SEX	VARCHAR2	(30)
TITLE	VARCHAR2	(30)
VENDOR_ID	NUMBER
WORK_TELEPHONE	VARCHAR2	(60)
PER_INFORMATION_CATEGORY	VARCHAR2	(30)
PER_INFORMATION1	VARCHAR2	(150)
PER_INFORMATION2	VARCHAR2	(150)
PER_INFORMATION3	VARCHAR2	(150)
PER_INFORMATION4	VARCHAR2	(150)
PER_INFORMATION5	VARCHAR2	(150)
PER_INFORMATION6	VARCHAR2	(150)
PER_INFORMATION7	VARCHAR2	(150)
PER_INFORMATION8	VARCHAR2	(150)
PER_INFORMATION9	VARCHAR2	(150)
PER_INFORMATION10	VARCHAR2	(150)
PER_INFORMATION11	VARCHAR2	(150)
PER_INFORMATION12	VARCHAR2	(150)
PER_INFORMATION13	VARCHAR2	(150)
PER_INFORMATION14	VARCHAR2	(150)
PER_INFORMATION15	VARCHAR2	(150)
PER_INFORMATION16	VARCHAR2	(150)
PER_INFORMATION17	VARCHAR2	(150)
PER_INFORMATION18	VARCHAR2	(150)
PER_INFORMATION19	VARCHAR2	(150)
PER_INFORMATION20	VARCHAR2	(150)
ASSET_ID	NUMBER	(15)
ASSET_NUMBER	VARCHAR2	(15)
ASSET_KEY_CCID	NUMBER	(15)
CURRENT_UNITS	NUMBER
ASSET_TYPE	VARCHAR2	(11)
TAG_NUMBER	VARCHAR2	(15)
ASSET_DESCRIPTION	VARCHAR2	(80)
ASSET_CATEGORY_ID	NUMBER	(15)
PARENT_ASSET_ID	NUMBER	(15)
MANUFACTURER_NAME	VARCHAR2	(360)
SERIAL_NUMBER	VARCHAR2	(35)
MODEL_NUMBER	VARCHAR2	(40)
PROPERTY_TYPE_CODE	VARCHAR2	(10)
PROPERTY_1245_1250_CODE	VARCHAR2	(4)
IN_USE_FLAG	VARCHAR2	(3)
OWNED_LEASED	VARCHAR2	(15)
NEW_USED	VARCHAR2	(4)
UNIT_ADJUSTMENT_FLAG	VARCHAR2	(3)
ADD_COST_JE_FLAG	VARCHAR2	(3)
LEASE_ID	NUMBER	(15)
CATEGORY_TYPE	VARCHAR2	(30)
CAPITALIZE_FLAG	VARCHAR2	(3)
ASSET_KEY	VARCHAR2	(310)
CATEGORY	VARCHAR2	(61)
LOC_CONC_SEGMENTS	VARCHAR2	(123)
ACCT_CONC_SEGMENTS	VARCHAR2	(155)

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_EMP_ASSET_WEB_V references the following:

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