1 Reply Latest reply on Dec 28, 2016 12:20 PM by Bommi

    How to make join between RFQ and Requistion after PO generation

    Hmusman

      I USE THIS QUERY FOR EXTRACT RFQ AGAINST DEMANDS RIGHT ?

       

      SELECT   RH.SEGMENT1 REQ_NUM,

                 RL.REQUISITION_LINE_ID,

                 RL.REQUISITION_HEADER_ID,

                 PH.SEGMENT1 RFQ_NUM,

                 PL.PO_HEADER_ID,

                 PL.PO_LINE_ID

          FROM   PO_REQUISITION_HEADERS_ALL RH,

                 PO_REQUISITION_LINES_ALL RL,

                 PO_HEADERS_ALL PH,

                 PO_LINES_ALL PL

         WHERE       RH.REQUISITION_HEADER_ID = RL.REQUISITION_HEADER_ID

                 AND RL.LAST_UPDATE_DATE = PL.CREATION_DATE

                 AND PL.PO_HEADER_ID = PH.PO_HEADER_ID

                 AND RL.ON_RFQ_FLAG = 'Y'

      ORDER BY   REQUISITION_LINE_ID DESC;

       

      BUT AS YOU SEEN RL.LAST_UPDATE_DATE=PL.CREATION_DATE, IF WE MAKE AUTO PO ON THE BASES OF THIS RFQ THEN, CAN i need to MODIFY this QUERY Or SAME JOIN WORK I THINK THIS JOIN CAN't work