In this post, I’ll go over some of the most common Oracle Payables interview questions. For most of these questions, I’ve attempted to combine the details answers with a working example in order to help interviewers in their preparations. (1) What are the different types of invoices in Oracle Apps? Ans: Below are the different
Oracle R12 - Orapoint
Query to get PO Number Raised Against Requisition in Oracle Apps R12
This Query will get the PO number which is raised on Requisition in Oracle Application R12
|
1 2 3 4 5 6 7 8 9 10 11 12 |
SELECT DISTINCT pha.segment1 po_num FROM po_headers_all pha, po_distributions_all pda, po_req_distributions_all rda, po_requisition_headers_all rha, po_requisition_lines_all rla WHERE 1=1 AND pha.po_header_id=pda.po_header_id AND pda.req_distribution_id=rda.distribution_id AND rda.requisition_line_id=rla.requisition_line_id AND rla.requisition_header_id=rha.requisition_header_id AND rha.requisition_header_id= 100131; --pass the requisition header id |