Oracle SOA Interview questions will be discussed in this article, because of technology improvements, the market is seeing a tremendous growth in the demand for Oracle-skilled candidates. we’ve compiled a list of interview SOA questions and their responses. Q1. What does SOA mean to you, and what are the advantages of implementing this architecture? Service
Uncategorized Archives - Orapoint
Query to Get PO, Receipt, Invoice Number in Oracle Apps R12
Query to Get PO, Receipt, Invoice Number in Oracle Apps R12 This query will extract Receipt number and Invoice Number which are raised against PO number in Oracle R12 Application SELECT DISTINCT pha.segment1 po_number, aia.invoice_num invoice_number, rsh.receipt_num receipt_number FROM po_headers_all pha, po_distributions_all pda, ap_invoice_distributions_all aida, ap_invoices_all aia, rcv_shipment_lines rsl, rcv_shipment_headers rsh WHERE pha.po_header_id = pda.po_header_id