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 , CONCATENATED_SEGMENTS ITEM_NAME , DESCRIPTION ITEM_DESCRIPTION , A.STATUS STATUS , A.LINE_ATTRIBUTE_ID LINE_ATTRIBUTE_ID , C.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , A.QUOTE_HEADER_ID QUOTE_HEADER_ID , A.QUOTE_LINE_ID QUOTE_LINE_ID , C.ORGANIZATION_ID ORGANIZATION_ID FROM ASO_QUOTE_LINE_ATTRIBS_EXT A , ASO_QUOTE_LINES_ALL B , MTL_SYSTEM_ITEMS_KFV C WHERE A.QUOTE_LINE_ID = B.QUOTE_LINE_ID AND NAME = 'SUBSCRIPTION' AND C.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID