You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need the tables that stores AR Receipts: Receipt Type, Status and Refundable deposit status

Hi Experts,

I need the table names that stores Receipt Type, Status and Refundable deposit status in Manage Receipts UI in oracle fusion.

I used,

AR_CASH_RECEIPTS_ALL

AR_RECEIPT_METHODS

HZ_CUST_ACCOUNTS

HZ_PARTIES

HR_ALL_ORGANIZATION_UNITS_F_VL

tables for other needed columns,

SQL:

SELECT    ACRA.RECEIPT_NUMBER             RECEIPT_NUMBER,    ACRA.DOC_SEQUENCE_VALUE         DOCUMENT_NUMBER,    ARM.NAME                        RECEIPT_METHOD,    HP.PARTY_NAME                   CUSTOMER_NAME,    HCA.ACCOUNT_NUMBER              CUSTOMER_ACCOUNT_NUMBER,    ACRA.AMOUNT                     ENTERED_AMOUNT,    HAOU.NAME                       BUFROM    AR_CASH_RECEIPTS_ALL            ACRA,    AR_RECEIPT_METHODS              ARM,    HZ_CUST_ACCOUNTS    

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!