Search This Blog

Monday, March 1, 2021

Query To Get Payment Method for Supplier in Account Payables in Oracle Apps R12

     SELECT DISTINCT pmthds.Payment_Method_Name, pmthds.Payment_Method_Code--, pmthds.inactive_date inactive_date, 'N'
    FROM IBY_APPLICABLE_PMT_MTHDS apmthds, IBY_PAYMENT_METHODS_VL pmthds
    WHERE apmthds.payment_method_Code = pmthds.payment_method_code
    AND apmthds.Payment_flow = 'DISBURSEMENTS'
    AND NVL(pmthds.inactive_date,trunc(sysdate)) >= trunc(sysdate)
    --AND apmthds.APPLICATION_ID = :1
    AND (apmthds.applicable_type_code = 'PAYEE')
    AND NOT EXISTS( SELECT 1 FROM IBY_EXT_PARTY_PMT_MTHDS PmtMthdAssignmentsEO
    WHERE apmthds.payment_method_Code = PmtMthdAssignmentsEO.payment_method_code
    AND apmthds.Payment_flow = PmtMthdAssignmentsEO.Payment_flow
    AND PmtMthdAssignmentsEO.EXT_Pmt_party_ID --= 66991
    IN (SELECT EXT_PAYEE_ID FROM IBY_EXTERNAL_PAYEES_ALL WHERE PAYEE_PARTY_ID = (SELECT PARTY_ID FROM AP_SUPPLIERS WHERE VENDOR_ID = 871744) AND ROWNUM = 1))
    ;

No comments:

Post a Comment