3 Replies Latest reply on Dec 26, 2015 5:11 PM by AlexAnd

    r12 wf_notifications to po_requisition_lines_all / po_requisition_headers_all

    AlexAnd

      hi all

       

      can anybody help in understanding for r12 relationship between wf_notifications and po_requisition_lines_all / po_requisition_headers_all

       

      i found case like

       

      from

      po_requisition_headers_all p

      ...

      where

      ...

      wf_item_key in

      (

      select item_key         

      from wf_notifications

      ....

      )

      but it's not working in my case


      any ideas, queries, docs, blogs ?


       

      thanks

        • 1. Re: r12 wf_notifications to po_requisition_lines_all / po_requisition_headers_all
          Bashar.

          Hi,

           

          Have a look at this query:

           

          select n.*

          from wf_notifications n, wf_item_activity_statuses wias, po_requisition_headers_all rh

          where n.notification_id = wias.notification_id

            and wias.item_type = rh.wf_item_type

            and wias.item_key = rh.wf_item_key;

           

          Regards,

          Bashar

          • 2. Re: Re: r12 wf_notifications to po_requisition_lines_all / po_requisition_headers_all
            AlexAnd

            thanks for reply

             

            look at

            SQL> select wias.item_type , wias.item_key

              2  from wf_notifications n, wf_item_activity_statuses wias

              3  where n.notification_id = wias.notification_id

              4    and n.notification_id = 7090595

              5  /

             

            ITEM_TYPE ITEM_KEY

            --------- --------------------------------------------------------------------------------

            REQAPPRV  178035-901367

             

            SQL>

            SQL> select rh.wf_item_type, rh.wf_item_key

              2  from  po_requisition_headers_all rh

              3  where rh.requisition_header_id=178035

              4  /

             

            WF_ITEM_TYPE WF_ITEM_KEY

            ------------ --------------------------------------------------------------------------------

            REQAPPRV    178035901366

             

            SQL>

            so your query returns 0 row

            looks like there are other relations

             

            any ideas ?

            • 3. Re: Re: r12 wf_notifications to po_requisition_lines_all / po_requisition_headers_all
              AlexAnd

              also interesting info

              select * from WF_NOTIFICATION_ATTRIBUTES

              where notification_id = 7090595

              gives some info in which

               

              EDIT_REQ_URL

              JSP:/OA_HTML/OA.jsp?OAFunc=ICX_POR_LAUNCH_IP&porMode=approverCheckout&porReqHeaderId=178035&_OrgId=90&item_key=178035-901367

               

               

              DOCUMENT_ID

              178035

               

               

              VIEW_REQ_DTLS_URL

              JSP:/OA_HTML/OA.jsp?OAFunc=ICX_POR_LAUNCH_IP&porMode=viewReq&porReqHeaderId=178035&_OrgId=90&addBreadCrumb=Y&item_key=178035-901367

              it's interesting but how it is used by oaf ?