View: AR_STATEMENTS_V

Product:	AR - Receivables
Description:	(Release 11.5 Only)
Implementation/DBA Data:	APPS.AR_STATEMENTS_V

View Text

SELECT SH.ROWID
, SH.STATEMENT_DATE
, SC.NAME
, NVL(SU.LOCATION
, SH.BILL_TO_LOCATION)
, SH.FINANCE_CHARGES
, PARTY.PARTY_NAME
, CUST_ACCT.ACCOUNT_NUMBER
, SH.BILL_TO_LOCATION
, SH.CUSTOMER_ID
, SH.CURRENCY_CODE
, SH.TOTAL_AMOUNT_DUE
, SH.IS_IT_A_REPRINT
, SH.LINE_CLUSTER_ID
, SH.LAST_UPDATED_BY
, SH.LAST_UPDATE_DATE
, SH.LAST_UPDATE_LOGIN
, SH.CREATED_BY
, SH.CREATION_DATE
FROM AR_STATEMENTS_HISTORY SH
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
, HZ_CUSTOMER_PROFILES CP
, AR_STATEMENT_CYCLES SC
, HZ_CUST_SITE_USES SU
, HZ_CUST_SITE_USES SU2
, HZ_CUST_ACCT_SITES ACCT_SITE
WHERE CUST_ACCT.CUST_ACCOUNT_ID = SH.CUSTOMER_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND CP.CUST_ACCOUNT_PROFILE_ID = DECODE(HZP_CUST_PKG.GET_STATEMENT_SITE( CUST_ACCT.CUST_ACCOUNT_ID)
, NULL
, SH.SITE_CUSTOMER_PROFILE_ID
, SH.CUST_CUSTOMER_PROFILE_ID)
AND SC.STATEMENT_CYCLE_ID = NVL(SH.STATEMENT_CYCLE_ID
, CP.STATEMENT_CYCLE_ID)
AND SU.SITE_USE_ID (+) = HZP_CUST_PKG.GET_STATEMENT_SITE(CUST_ACCT.CUST_ACCOUNT_ID)
AND ACCT_SITE.CUST_ACCOUNT_ID = SH.CUSTOMER_ID
AND SU2.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
AND SU2.SITE_USE_CODE IN ('BILL_TO'
, 'DRAWEE') /* 18-MAY-2000 J RAUTIAINEN BR IMPLEMENTATION */
AND SU2.LOCATION = SH.BILL_TO_LOCATION

Columns