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

VIEW: APPS.FA_DISTRIBUTION_HISTORY_V

Object Details
Object Name: FA_DISTRIBUTION_HISTORY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOFA.FA_DISTRIBUTION_HISTORY_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
DISTRIBUTION_ID NUMBER (15) Yes
BOOK_TYPE_CODE VARCHAR2 (15) Yes
ASSET_ID NUMBER (15) Yes
UNITS_ASSIGNED NUMBER
Yes
DATE_EFFECTIVE DATE
Yes
CODE_COMBINATION_ID NUMBER (15) Yes
LOCATION_ID NUMBER (15) Yes
TRANSACTION_HEADER_ID_IN NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
DATE_INEFFECTIVE DATE

ASSIGNED_TO NUMBER (15)
TRANSACTION_HEADER_ID_OUT NUMBER (15)
TRANSACTION_UNITS NUMBER

RETIREMENT_ID NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
ASSIGNED_TO_NUMBER VARCHAR2 (30)
ASSIGNED_TO_NAME VARCHAR2 (240)
Query Text

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


SELECT ROW_ID
,      DISTRIBUTION_ID
,      BOOK_TYPE_CODE
,      ASSET_ID
,      UNITS_ASSIGNED
,      DATE_EFFECTIVE
,      CODE_COMBINATION_ID
,      LOCATION_ID
,      TRANSACTION_HEADER_ID_IN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      DATE_INEFFECTIVE
,      ASSIGNED_TO
,      TRANSACTION_HEADER_ID_OUT
,      TRANSACTION_UNITS
,      RETIREMENT_ID
,      LAST_UPDATE_LOGIN
,      ASSIGNED_TO_NUMBER
,      ASSIGNED_TO_NAME
FROM APPS.FA_DISTRIBUTION_HISTORY_V;

Dependencies

[top of page]

APPS.FA_DISTRIBUTION_HISTORY_V references the following:

SchemaAPPS
SynonymFA_DISTRIBUTION_HISTORY
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPER_PEOPLE_X
SynonymPER_PERIODS_OF_SERVICE

APPS.FA_DISTRIBUTION_HISTORY_V is not referenced by any database object