View: CSP_SEC_INVENTORIES_V

Product:	CSP - Spares Management
Description:	Subinventory Details
Implementation/DBA Data:	APPS.CSP_SEC_INVENTORIES_V

View Text

SELECT B.ROWID
, B.SECONDARY_INVENTORY_ID
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.ORGANIZATION_ID
, B.PARTS_LOOP_ID
, B.HIERARCHY_NODE_ID
, MTL.LOCATION_ID
, B.CONDITION_TYPE
, B.AUTORECEIPT_FLAG
, B.SPARES_LOCATION_FLAG
, HL.LOCATION_CODE DESCRIPTION
, HL.ADDRESS_LINE_1
, HL.ADDRESS_LINE_2
, HL.ADDRESS_LINE_3
, HL.TOWN_OR_CITY CITY
, HL.POSTAL_CODE
, HL.COUNTRY
, HL.STYLE
, FTV.TERRITORY_SHORT_NAME
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.SECONDARY_INVENTORY_NAME
, L.MEANING
, B.RETURN_ORGANIZATION_ID
, B.RETURN_SUBINVENTORY_NAME
, OD.ORGANIZATION_NAME
, OD.ORGANIZATION_CODE
, B.OWNER_RESOURCE_TYPE
, B.OWNER_RESOURCE_ID FROM CSP_SEC_INVENTORIES B
, FND_LOOKUPS L
, ORG_ORGANIZATION_DEFINITIONS OD
, FND_TERRITORIES_VL FTV
, HR_LOCATIONS_ALL HL
, MTL_SECONDARY_INVENTORIES MTL
WHERE MTL.SECONDARY_INVENTORY_NAME=B.SECONDARY_INVENTORY_NAME AND MTL.ORGANIZATION_ID = B.ORGANIZATION_ID AND MTL.LOCATION_ID = HL.LOCATION_ID(+)
AND B.CONDITION_TYPE = L.LOOKUP_CODE
AND L.LOOKUP_TYPE LIKE 'CSP_CONDITION_TYPE'
AND B.ORGANIZATION_ID = OD.ORGANIZATION_ID
AND HL.COUNTRY = FTV.TERRITORY_CODE(+)

Columns