[Home] [Help]
View: AR_ADJ_INF_V
View Text
SELECT ADJ.ADJUSTMENT_ID
, PTY.PARTY_NAME
, CA.ACCOUNT_NUMBER
, ADJ.ADJUSTMENT_NUMBER
, ADJ.DOC_SEQUENCE_VALUE
, ADJ.CREATION_DATE
, ADJ.TYPE
FROM AR_ADJUSTMENTS_ALL ADJ
, RA_CUSTOMER_TRX_ALL TRX
, HZ_CUST_ACCOUNTS CA
, HZ_PARTIES PTY
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
Columns
| Name |
| ADJUSTMENT_ID |
| CUSTOMER_NAME |
| CUSTOMER_NUMBER |
| ADJUSTMENT_NUMBER |
| ADJUSTMENT_DOCUMENT_NUMBER |
| ADJUSTMENT_CREATION_DATE |
| ADJUSTMENT_TYPE |
APPS.AR_ADJ_INF_V