Sourcing

Get Involved. Join the Conversation.

Topic

    Niamath Jeddy
    Table which stores Attribute List's attributes
    Topic posted August 1, 2019 by Niamath JeddyGold Trophy: 10,000+ Points, tagged Negotiation Creation, OTBI 
    9 Views, 3 Comments
    Title:
    Table which stores Attribute List's attributes
    Summary:
    Table which stores Attribute List's attributes
    Content:

    Hi,

    Attribute lists are stored in PON_ATTRIBUTE_LISTS.

    Does anyone know which table stores the list's related attributes?

    Regards,

    Niamath

    Image:

    Comment

     

    • Nishanth B Jain

      Hi,

      i think it stores in the same table, check this column to identify parent or child

      ATTR_LEVEL VARCHAR2 25     Stores the level of the attribute list - HEADER or LINE
    • Niamath Jeddy

      Got the answer. it is in PON_AUCTION_ATTRIBUTES.

      PON_AUCTION_ATTRIBUTES stores item-specific attributes defined by the negotiation owner for auctions, RFQ, and RFIs. These attributes enable buyers to request information with more detail than is possible with the standard fields. COPIED_FROM_CAT_FLAG indicates whether the attributes was copied from the category definition in the catalog. If ATTRIBUTE_LIST_ID is populated, then the attribute belongs to a reusable attributes list. Otherwise, if AUCTION_HEADER_ID is populated, then the attribute belongs to a negotiation or a negotiation template. Only one of these two columns is populated for any single record.