Product: | CUN - Network Logistics - NATS (obsolete) |
---|---|
Description: | Asset unit information-- 07/27/2000 New STATUS types are included in the fnd_lookup_values, there for this view now search thru fnd_lookup_values for CUN_UNIT_STATUS type and consider all valid STATUS in the view query |
Implementation/DBA Data: | Not implemented in this database |
SELECT CIV.UNIT_ID
, CIV.INV_ITEM_ID
, CIV.INV_ITEM
, CIV.DESCRIPTION
, CIV.INVENTORY_ORG_ID
, CIV.INV_ORGANIZATION_NAME
, CIV.QUANTITY
, CIV.STATUS
, CIV.INV_STATUS_NAME
, CIV.STATUS_DESCRIPTION
, CIV.SUBINVENTORY
, CIV.LOCATOR_ID
, CIV.LOCATOR
, CIV.REVISION
, CIV.LOT_NUMBER
, CIV.FA_DISTRIBUTION_ID
, CIV.FA_DIST_LOCATION_ID
, CIV.FIXED_ASSET_LOCATION
, CIV.ASSET_ID
, CIV.ASSET_NUMBER
, CIV.ASSET_DESCRIPTION
, CIV.ASSET_TAG_NUMBER
, CIV.ASSET_SERIAL_NUMBER
, CIV.ASSET_TYPE
, CIV.CURRENT_UNITS
, CIV.CATEGORY_TYPE
, CIV.ASSET_MANUFACTURER_NAME
, CIV.HZ_LOCATION_ID
, CIV.CLLI_CODE
, CIV.LOC_DESCRIPTION
, CIV.PROJECT_ID
, CIV.PROJECT_NUMBER
, CIV.PROJECT_TASK_ID
, CIV.TASK_NUMBER
, CIV.SERIAL_NUMBER
, CIV.VENDOR_SERIAL_NUMBER
, CIV.NETWORK_NUMBER
, CIV.VENDOR_ID
, CIV.VENDOR_NAME
, CIV.ASSET_GROUPING_ELEMENT1
, CIV.ASSET_GROUPING_ELEMENT2
, CIV.ASSET_GROUPING_ELEMENT3
, CIV.LAST_TRANSACTION_ID
, CIV.REFERENCE_DATA
, CIV.CREATION_DATE
, CIV.CREATED_BY
, CIV.LAST_UPDATE_DATE
, CIV.LAST_UPDATED_BY
, CIV.LAST_UPDATE_LOGIN
, CTV.IN_SERVICE_DATE
, CTV.ASSET_RETIREMENT_DATE
, CTV.TRANSACTION_DATE
, CTV.WORK_ORDER_NUMBER
, CTV.INSTALLED_DATE
, CTV.EFFECTIVE_DATE
FROM CUN_ITEMS_V CIV
, CUN_TRANSACTIONS_V CTV
, FND_LOOKUP_VALUES FLV
WHERE CIV.LAST_TRANSACTION_ID = CTV.TRANSACTION_ID (+)
AND FLV.LOOKUP_TYPE(+)='CUN_UNIT_STATUS'
AND FLV.LOOKUP_CODE(+)=CIV.STATUS
AND FLV.LANGUAGE = USERENV('LANG') --AND CIV.STATUS IN ('IN_SERVICE'
, 'OUT_OF_SERVICE'
, 'RETIRED'
, 'IN_INV_DEPR'
, 'ISSUED'
, 'INSTALLED')