Skip to main content

Useful Views in Fusion Receivables



  • AR_TRX_INFO_V

SELECT trx.customer_trx_id CUSTOMER_TRX_ID,
pty.party_name CUSTOMER_NAME,
ca.account_number CUSTOMER_NUMBER,
trx.trx_number TRX_NUMBER,
trx.doc_sequence_value TRX_DOCUMENT_NUMBER,
trx.trx_date TRX_DATE,
tty.name TRX_TYPE,
bs.name TRX_BATCH_SOURCE,
bu.bu_name BU_NAME
FROM ra_customer_trx_all trx ,
hz_cust_accounts ca ,
hz_parties pty ,
ra_cust_trx_types_all tty,
ra_batch_sources_all bs,
fun_all_business_units_v bu
WHERE DECODE(trx.drawee_id, NULL, trx.bill_to_customer_id, trx.drawee_id) = ca.cust_account_id
AND ca.party_id = pty.party_id
AND trx.cust_trx_type_seq_id = tty.cust_trx_type_seq_id
AND trx.batch_source_seq_id = bs.batch_source_seq_id
AND trx.org_id = bu.bu_id

  • AR_CR_INFO_V

SELECT cr.cash_receipt_id ,
pty.party_name ,
ca.account_number ,
cr.receipt_number ,
cr.doc_sequence_value,
cr.receipt_date ,
arm.NAME ,
bu.bu_name
FROM ar_cash_receipts_all cr,
hz_cust_accounts ca ,
hz_parties pty ,
ar_receipt_methods arm ,
fun_all_business_units_v bu
WHERE cr.pay_from_customer = ca.cust_account_id(+)
AND ca.party_id = pty.party_id(+)
AND cr.receipt_method_id = arm.receipt_method_id
AND cr.org_id = bu.bu_id

  • AR_ADJ_INFO_V

SELECT adj.adjustment_id ,
pty.party_name ,
ca.account_number ,
adj.adjustment_number,
adj.doc_sequence_value,
adj.creation_date,
adj.type,
bu.bu_name
FROM ar_adjustments_all adj,
ra_customer_trx_all trx,
hz_cust_accounts ca ,
hz_parties pty,
fun_all_business_units_v bu
WHERE adj.customer_trx_id = trx.customer_trx_id
AND trx.bill_to_customer_id = ca.cust_account_id
AND ca.party_id = pty.party_id
AND adj.org_id = bu.bu_id


For more information
https://docs.oracle.com/en/cloud/saas/financials/18c/oedmf/AR-tables.html

Popular posts from this blog

Important Tables and Views in Oracle Fusion Inventory

INV_ORG_PARAMETERS INV_ITEM_LOCATIONS INV_PHYSICAL_INVENTORIES INV_SECONDARY_INVENTORIES INV_SECONDARY_LOCATORS INV_ORGANIZATION_DEFINITIONS_V INV_ONHAND_QUANTITIES_DETAIL INV_RULES_VL INV_ACTIONS_VL INV_SERIAL_NUMBERS INV_LOT_NUMBERS INV_UNITS_OF_MEASURES_B INV_MATERIAL_STATUSES_TL INV_TRANSACTION_TYPES_TL INV_MATERIAL_TXNS INV_SALES_ORDERS INV_TXN_SOURCE_TYPES_TL INV_TXN_REQUEST_HEADERS INV_TRANSFER_ORDER_HEADERA INV_TRANSFER_ORDER_LINES INV_TRANSFER_ORDER_DISTRIBS