Sample Code for API AR_CASH_RECEIPT_API.PUB by Pranay Tiwari
AR_CASH_RECEIPT_API.PUB is the API to create receipts in Oracle , And below is the sample API code. Mandatory Input Parameters for API Currency Amount Receipt Method Id Customer Id Customer Site Use id Org Id Query to derive Receipt Method id SELECT receipt_method_id FROM ar_receipt_methods WHERE name = <Receipt Method Name > Query to derive Cust Account and Site Use id SELECT hca.cust_Account_id, hcsu.site_use_id FROM HZ_PARTIES HP, HZ_CUST_ACCOUNTS HCA, HZ_CUST_ACCT_SITES_ALL HCAS, HZ_CUST_SITE_USES_ALL HCSU WHERE HP.PARTY_ID = HCA.PARTY_ID AND HCA.CUST_ACCOUNT_ID = HCAS.CUST_ACCOUNT_ID ...