1 Reply Latest reply on Jun 30, 2020 12:02 PM by Mat Tyndall-Oracle

    Difference between complex and standard PO DB perspective

    user13394313

      Hello,

               How can I differentiate between complex and standard PO DB perspective in PO header level?

      Is there any value or column to differentiate between complex and standard PO in PO header level in database?

      Release: 12.2.5

       

      Best Regards,

        • 1. Re: Difference between complex and standard PO DB perspective
          Mat Tyndall-Oracle

          Use this query and table to link into po headers and find the style id

           

          select distinct h.STYLE_ID , ST.STYLE_NAME , st.style_description

          from po.po_headers_all h,

          PO_DOC_STYLE_HEADERS st

          where 1=1

          and h.creation_date > sysdate - 365   --use dates here if you want also

          AND st.style_id = h.style_id

          /

           

          Adjust dates above and data to get PO information - style_id column in the PO headers table indicates which style/type was used to create the PO.

           

          To get a list of all doc styles:

          SELECT * FROM PO_DOC_STYLE_HEADERS;