Current Position:Home > 3 way match question

3 way match question

Update:11-30Source: network consolidation
Advertisement
Hi,
In Oracle, we have the 3 way match process
Can anyone please provide the query behind how the 3 way match process can be verified.
I mean we verify if the
Quantity billed <=Quantity Ordered
Invoice price <=Purchase Order price
Quantity billed <= “Quantity ordered
Where do we get the values from. i mean which column and which table we get these quantity_Billed, quantity_ordered etc..
Thank you

The Best Answer

Advertisement
The best way to determine if the 3-WAY match process is followed or an Invoice is a 3-way MATCH or not is using the
INSPECTION_REQUIRED_FLAG and RECEIPT_REQUIRED_FLAG from PO_LINE_LOCATIONS_ALL
INSPECTION_REQUIRED_FLAG
RECEIPT_REQUIRED_FLAG
Match Approval
N
N
2-Way
N
Y
3-Way
Y
Y
4-Way
SELECT  AIA.*
FROM    AP_INVOICE_DISTRIBUTIONS_ALL  APD
            ,PO_DISTRIBUTIONS_ALL POD
            ,PO_LINE_LOCATIONS_ALL POLL
,AP_INVOICES_ALL AIA
     WHERE APD.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID
     AND   POD.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
     AND   APD.invoice_id = p_invoice_id
AND   APD.invoice_id = AIA.invoice_id
     AND   APD.line_type_lookup_code <> 'TAX'
     AND   NVL(POLL.INSPECTION_REQUIRED_FLAG,'N') = 'N'
     AND   POLL.RECEIPT_REQUIRED_FLAG = 'Y';
  • How do I change the font color for numbering in a matching question slide? Update:10-11

    I have a grey image on a question slide, but the numbering for the answers in a matching question is defaulting to grey so learners can't see to match up.  How can I change the font color of these choices?  Thanks.You probably edited the master slide

  • Review for matching question? Update:11-30

    I have a quiz that has a few multiple choice, a few true / false, and one matching question. When the user finishes the quiz, the Review button takes them to the first question and tells them if they got the answer right or wrong (if they got it wron

  • Review Quiz - Matching Question Update:11-30

    Hi fellow Captivate-rs! I'm urgently hoping for some help... I've got a four-question "Knowledge Check" (quiz), complete with a "Results" slide, at the end of my project. When clicking the "Review Quiz" button, the correct an

  • Placing an image on matching Questions Update:11-30

    Using Captivate 3, I would like to use the matching question to match images, such as icons, with their usage. Is it possible to insert small images in one of the column and how. Any suggestions will be much appreciated.function(){return A.apply(null

  • C5.5 Issue with color/colour in matching question drop down list Update:11-30

    Hi is there a way to change the colour of the letters that appear in the drop down lists for a matching question in 5.5? I'm using white text on a grey background for my quiz slides, which is nice and easy to read, but then in the preview the letters

  • Adding variables to match question slides Update:11-30

    Hi All, I am using Captivate 7 and need your help/idea/expertise on this. I am trying the following: Adding a drag and drop slide wherein I should be able to drop the source to any target. If the drop happens on the correct option (this is the challe

  • Matching Question Slides Update:11-30

    Help I am creating a matching questions slide with 6 selections. Everytime I try to drag the last selection a box (similar to the submit box) appears.Not enough information, my friend, though I appreciate the offer of a beer. What might be "similar t

  • Matching Question--possible bug Update:11-30

    Here's an issue that's been reported and verified by both technical support and myself. In matching questions, if you drag incorrectly from one column to the other and then correct your mistake--the question is marked incorrect even if the end result

  • Quizzing problems - Matching question - answers not accurate ++ Update:11-30

    Really getting frustrated with proofing a matching question (have tried it in both Cpt3 and 4) Attempting to use:  Drop down style 1. Correct answers not reproducing Correct response. in Capt 4 2. in Capt 3,  the answers are not showing up at all in

  • ITunes match question (manual sync and iTunes library) Update:10-11

    Hi all Just noticed that iTunes match is now avaliable in Denmark, and therefore I have a few questions that I can't seem to find answers for elsewhere. My situation is that I have all my music on a NAS (and on at USB backup drive). Some of the music