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 Archives - 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 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