How to get the BPA number against to PO Number in Fusion:


SELECT        
  FromBlanketHeader.SEGMENT1 AS BPANUMBER,
        FromBlanketHeader.attribute1 
  FROM
  PO_LINES_ALL PurchasingDocumentLine,
  PO_HEADERS_ALL PurchasingDocumentHeader,
  PO_HEADERS_ALL ContractHeader,
  PO_HEADERS_ALL FromBlanketHeader
  WHERE
  PurchasingDocumentLine.PO_HEADER_ID = PurchasingDocumentHeader.PO_HEADER_ID
  AND PurchasingDocumentLine.CONTRACT_ID = ContractHeader.PO_HEADER_ID(+)
  AND PurchasingDocumentLine.FROM_HEADER_ID = FromBlanketHeader.PO_HEADER_ID(+)
  AND PurchasingDocumentHeader.SEGMENT1=:P_YOUR_PONUMBER

select * from iby_pay_service_requests

where CALL_APP_PAY_SERVICE_REQ_CODE like 'PPR Fille name'

Best way to get the Payment extract from back end tables in Fusion:

Fusion: Generate IBY PPR Diagnostic Report (Doc ID 1377744.1)

How to configure the Payments  Process Profile in Fusion:

Manage Transmission Configuration to setup all FTP and file format details.

Security details report:

BI Publisher - Fusion Apps - How Can A BI Publisher Report Based On A SQL Query Use The Security Roles In Fusion Applications? (Doc ID 1537196.1)

Print receivable by BU name : View Image » By Business Unit (Doc ID 2188688.1) 

second highest date:

WITH T AS
(select creation_date,DENSE_RANK() OVER (ORDER BY CREATION_DATE asc) AS Rnk from (select unique to_char(RCT.CREATION_DATE,'YYYY-MM-DD') as "CREATION_DATE" from
EGP_SYSTEM_ITEMS_VL ESI,
PO_LINES_ALL PLA,
RCV_TRANSACTIONS RCT
where PLA.item_id=esi.inventory_item_id
and RCT.PO_LINE_ID=pla.PO_LINE_ID
and item_number='92737'
order by CREATION_DATE asc))
select creation_date from T
WHERE Rnk =2