View: FA_INVENTORY_V

Product:	OFA - Assets
Description:	This view shows reconciliation information on assets that have been included in physical inventory
Implementation/DBA Data:	APPS.FA_INVENTORY_V

View Text

SELECT INV.ROWID ROW_ID
, INV.INVENTORY_ID
, INV.INVENTORY_NAME
, INV.ASSET_NUMBER ASSET_NUMBER
, INV.ASSET_ID ASSET_ID
, INV.UNITS INV_UNITS
, INV.LOCATION_ID INV_LOCATION_ID
, INV.UNIT_ADJ UNIT_ADJ
, LU2.LOOKUP_CODE UNIT_REC_MTH_LOOKUP_CODE
, LU2.MEANING UNIT_RECONCILE_MTH
, INV.LOCATION_ADJ
, LU3.LOOKUP_CODE LOC_REC_MTH_LOOKUP_CODE
, LU3.MEANING LOC_RECONCILE_MTH
, LU.LOOKUP_CODE STATUS_LOOKUP_CODE
, LU.MEANING STATUS
, INV.DISTRIBUTION_ID
, DH.LOCATION_ID DH_LOCATION_ID
, DH.UNITS_ASSIGNED
, A.TAG_NUMBER
, AT.DESCRIPTION
, A.ASSET_CATEGORY_ID
, A.ASSET_KEY_CCID
, A.CURRENT_UNITS
, A.MANUFACTURER_NAME
, A.SERIAL_NUMBER
, A.MODEL_NUMBER
, INV.LAST_UPDATE_DATE
, INV.LAST_UPDATED_BY
, INV.LAST_UPDATE_LOGIN
FROM FA_INV_INTERFACE INV
, FA_DISTRIBUTION_HISTORY DH
, FA_ADDITIONS_B A
, FA_ADDITIONS_TL AT
, FA_LOOKUPS LU
, FA_LOOKUPS LU2
, FA_LOOKUPS LU3
WHERE INV.ASSET_ID = DH.ASSET_ID(+)
AND INV.DISTRIBUTION_ID = DH.DISTRIBUTION_ID(+)
AND INV.STATUS IN ('DIFFERENCE'
, 'TO RECONCILE'
, 'RECONCILED')
AND INV.ASSET_ID = A.ASSET_ID(+)
AND INV.STATUS = LU.LOOKUP_CODE
AND LU.LOOKUP_TYPE = 'INVENTORY STATUS'
AND INV.UNIT_RECONCILE_MTH = LU2.LOOKUP_CODE
AND LU2.LOOKUP_TYPE LIKE 'INVENTORY UNIT METHOD%'
AND INV.LOC_RECONCILE_MTH = LU3.LOOKUP_CODE
AND LU3.LOOKUP_TYPE = 'INVENTORY LOCATION METHOD'
AND AT.ASSET_ID(+) = A.ASSET_ID
AND AT.LANGUAGE(+) = USERENV('LANG')

Columns