View: FA_INV_INTERFACE_V

Product:	OFA - Assets
Description:	- Retrofitted
Implementation/DBA Data:	APPS.FA_INV_INTERFACE_V

View Text

SELECT ITF.INVENTORY_NAME
, ITF.ASSET_ID
, ITF.ASSET_NUMBER
, ITF.TAG_NUMBER
, ITF.DESCRIPTION
, ITF.MODEL_NUMBER
, ITF.SERIAL_NUMBER
, ITF.MANUFACTURER_NAME
, ITF.UNITS
, LU.MEANING STATUS
, LU2.MEANING UNIT_RECONCILE_MTH
, LU3.MEANING LOC_RECONCILE_MTH
, ITF.DISTRIBUTION_ID
, ITF.INVENTORY_ID
, ITF.RECONCILIATION_ID
, LOC.SEGMENT1 LOC_SEGMENT1
, LOC.SEGMENT2 LOC_SEGMENT2
, LOC.SEGMENT3 LOC_SEGMENT3
, LOC.SEGMENT4 LOC_SEGMENT4
, LOC.SEGMENT5 LOC_SEGMENT5
, LOC.SEGMENT6 LOC_SEGMENT6
, LOC.SEGMENT7 LOC_SEGMENT7
, CAT.SEGMENT1 CAT_SEGMENT1
, CAT.SEGMENT2 CAT_SEGMENT2
, CAT.SEGMENT3 CAT_SEGMENT3
, CAT.SEGMENT4 CAT_SEGMENT4
, CAT.SEGMENT5 CAT_SEGMENT5
, CAT.SEGMENT6 CAT_SEGMENT6
, CAT.SEGMENT7 CAT_SEGMENT7
, KEY.SEGMENT1 KEY_SEGMENT1
, KEY.SEGMENT2 KEY_SEGMENT2
, KEY.SEGMENT3 KEY_SEGMENT3
, KEY.SEGMENT4 KEY_SEGMENT4
, KEY.SEGMENT5 KEY_SEGMENT5
, KEY.SEGMENT6 KEY_SEGMENT6
, KEY.SEGMENT7 KEY_SEGMENT7
, KEY.SEGMENT8 KEY_SEGMENT8
, KEY.SEGMENT9 KEY_SEGMENT9
FROM FA_INV_INTERFACE ITF
, FA_DISTRIBUTION_HISTORY DH
, FA_LOOKUPS LU
, FA_LOOKUPS LU2
, FA_LOOKUPS LU3
, FA_CATEGORIES CAT
, FA_LOCATIONS LOC
, FA_ASSET_KEYWORDS KEY
WHERE ITF.ASSET_ID = DH.ASSET_ID(+)
AND ITF.DISTRIBUTION_ID = DH.DISTRIBUTION_ID(+)
AND ITF.STATUS = LU.LOOKUP_CODE(+)
AND LU.LOOKUP_TYPE(+) = 'INVENTORY STATUS'
AND ITF.UNIT_RECONCILE_MTH = LU2.LOOKUP_CODE(+)
AND LU2.LOOKUP_TYPE(+) LIKE 'INVENTORY UNIT METHOD%'
AND LU3.LOOKUP_TYPE(+) LIKE 'INVENTORY LOCATION METHOD'
AND ITF.LOC_RECONCILE_MTH = LU3.LOOKUP_CODE(+)
AND ITF.ASSET_CATEGORY_ID = CAT.CATEGORY_ID(+)
AND ITF.LOCATION_ID = LOC.LOCATION_ID(+)
AND ITF.ASSET_KEY_CCID = KEY.CODE_COMBINATION_ID(+)

Columns