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

VIEW: APPS.FA_HIERARCHY_DISTRIBUTIONS_V

Object Details
Object Name: FA_HIERARCHY_DISTRIBUTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOFA.FA_HIERARCHY_DISTRIBUTIONS_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 Mandatory Comments
ROW_ID ROWID (10)
ASSET_HIERARCHY_PURPOSE_ID NUMBER

ASSET_HIERARCHY_ID NUMBER

DISTRIBUTION_ID NUMBER

DIST_SET_ID NUMBER

BOOK_TYPE_CODE VARCHAR2 (15)
DISTRIBUTION_LINE_PERCENT NUMBER

CODE_COMBINATION_ID NUMBER

LOCATION_ID NUMBER

ASSIGNED_TO NUMBER

EMPLOYEE_NUMBER VARCHAR2 (30)
EMPLOYEE_NAME VARCHAR2 (240)
CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

Query Text

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


SELECT ROW_ID
,      ASSET_HIERARCHY_PURPOSE_ID
,      ASSET_HIERARCHY_ID
,      DISTRIBUTION_ID
,      DIST_SET_ID
,      BOOK_TYPE_CODE
,      DISTRIBUTION_LINE_PERCENT
,      CODE_COMBINATION_ID
,      LOCATION_ID
,      ASSIGNED_TO
,      EMPLOYEE_NUMBER
,      EMPLOYEE_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.FA_HIERARCHY_DISTRIBUTIONS_V;

Dependencies

[top of page]

APPS.FA_HIERARCHY_DISTRIBUTIONS_V references the following:

SchemaAPPS
SynonymFA_ASSET_HIERARCHY
SynonymFA_ASSET_HIERARCHY_PURPOSE
SynonymFA_ASSET_HIERARCHY_VALUES
PL/SQL PackageFA_CUA_HIERARCHY_PKG - show dependent code
SynonymFA_DISTRIBUTION_HISTORY
ViewFA_EMPLOYEES
SynonymFA_HIERARCHY_DISTRIBUTIONS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code

APPS.FA_HIERARCHY_DISTRIBUTIONS_V is not referenced by any database object