Total Pageviews

Showing posts with label EBS : FND : Query. Show all posts
Showing posts with label EBS : FND : Query. Show all posts

Saturday, 29 July 2023

EBS : Useful AOL Query in Oracle Apps (r12)

Query to find Concurrent Request Details against input Concurrent Program

SELECT concurrent_program_name, fcr.*
  FROM fnd_concurrent_programs fcp, fnd_concurrent_requests fcr
 WHERE fcp.concurrent_program_id = fcr.concurrent_program_id
   AND fcp.concurrent_program_name = 'XX_TECHHARDS';











***********************************************************************************
#Oracle Apps #EBS #Concurrent Request #Concurrent Programs

#How to get concurrent Request Details



FUSION: Purchasing Query

  1) ---------CPA to PO Amount---------- select poh.segment1, (select sum(nvl(cpol.quantity,1)* cpol.unit_price) from po_headers_all cpoh,po...