VIEW: APPS.AR_STATEMENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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