VIEW: APPS.FA_INVENTORY_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')