This view retrieves the Item subscription defining item that we are currently displaying in the shopping cart for self service use
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT NAME NAME , VALUE SUBSCRIPTION , VALUE_TYPE VALUE_TYPE , LTRIM(RTRIM(C.PADDED_CONCATENATED_SEGMENTS)) RELATED_ITEM_NAME , C.DESCRIPTION RELATED_ITEM_DESCRIPTION , A.STATUS STATUS , A.LINE_ATTRIBUTE_ID LINE_ATTRIBUTE_ID , C.INVENTORY_ITEM_ID RELATED_ITEM_ID , A.QUOTE_HEADER_ID QUOTE_HEADER_ID , A.QUOTE_LINE_ID QUOTE_LINE_ID , C.ORGANIZATION_ID ORGANIZATION_ID , D.INVENTORY_ITEM_ID FROM ASO_QUOTE_LINE_ATTRIBS_EXT A , ASO_QUOTE_LINES_ALL B , MTL_SYSTEM_ITEMS_KFV C , MTL_RELATED_ITEMS_ALL_V D WHERE A.QUOTE_LINE_ID = B.QUOTE_LINE_ID AND A.VALUE_TYPE = 'SUBSCRIPTION_DEFINE' AND A.NAME = 'SUBSCRIPTION' AND C.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND D.RELATED_ITEM_ID = C.INVENTORY_ITEM_ID AND D.RELATIONSHIP_TYPE_ID = 6