[Home] [Help] [Dependency Information]
Object Name: | FA_DISTRIBUTION_HIST_WEB_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OFA.FA_DISTRIBUTION_HIST_WEB_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
This web inquiry view contains historical distribution information for
an asset.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Refer to base table | |
DISTRIBUTION_ID | NUMBER | (15) | Yes | Refer to base table |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Refer to base table |
ASSET_ID | NUMBER | (15) | Yes | Refer to base table |
UNITS_ASSIGNED | NUMBER | Yes | Refer to base table | |
DATE_EFFECTIVE | DATE | Yes | Refer to base table | |
CODE_COMBINATION_ID | NUMBER | (15) | Yes | Refer to base table |
LOCATION_ID | NUMBER | (15) | Yes | Refer to base table |
TRANSACTION_HEADER_ID_IN | NUMBER | (15) | Yes | Refer to base table |
LAST_UPDATE_DATE | DATE | Yes | Refer to base table | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Refer to base table |
DATE_INEFFECTIVE | DATE | Refer to base table | ||
ASSIGNED_TO | NUMBER | (15) | Refer to base table | |
TRANSACTION_HEADER_ID_OUT | NUMBER | (15) | Refer to base table | |
TRANSACTION_UNITS | NUMBER | Refer to base table | ||
RETIREMENT_ID | NUMBER | (15) | Refer to base table | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Refer to base table | |
ASSIGNED_TO_NUMBER | VARCHAR2 | (30) | Refer to base table | |
ASSIGNED_TO_NAME | VARCHAR2 | (240) | Refer to base table | |
EMPLOYEE_NUMBER | VARCHAR2 | (30) | Refer to base table | |
FULL_NAME | VARCHAR2 | (240) | Refer to base table | |
ACCT_CONC_SEGMENTS | VARCHAR2 | (155) | Refer to base table | |
LOC_CONC_SEGMENTS | VARCHAR2 | (123) | Refer to base table | |
ACCOUNTING_CONCATENATED | VARCHAR2 | (155) | Refer to base table | |
LOCATION_CONCATENATED | VARCHAR2 | (123) | Refer to base table |
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
, EMPLOYEE_NUMBER
, FULL_NAME
, ACCT_CONC_SEGMENTS
, LOC_CONC_SEGMENTS
, ACCOUNTING_CONCATENATED
, LOCATION_CONCATENATED
FROM APPS.FA_DISTRIBUTION_HIST_WEB_V;
APPS.FA_DISTRIBUTION_HIST_WEB_V is not referenced by any database object
|
|
|