AR_ADJ_INF_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name
ADJUSTMENT_ID PARTY_NAME ACCOUNT_NUMBER ADJUSTMENT_NUMBER DOC_SEQUENCE_VALUE CREATION_DATE TYPE BU_NAME

Query

SQL_Statement

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