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
0