Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT RTRIM(SUBSTRB(PARTY.PARTY_NAME
, 1
, 50))
, CUST_ACCT.ACCOUNT_NUMBER
, ACCT_SITE.CUST_ACCOUNT_ID
, PARTY.JGZZ_FISCAL_CODE
, PARTY.TAX_REFERENCE
, SU.SITE_USE_ID
, SU.LOCATION
, ACCT_SITE.CUST_ACCT_SITE_ID
, SUBSTR(RTRIM(LOC.ADDRESS1) || DECODE(RTRIM(LOC.ADDRESS2)
, NULL
, ' '
, '
, ' || RTRIM(LOC.ADDRESS2)) || DECODE(RTRIM(LOC.CITY)
, NULL
, ' '
, '
, ' || RTRIM(LOC.CITY)) || DECODE(RTRIM(LOC.PROVINCE)
, NULL
, ' '
, '
, '||RTRIM(LOC.PROVINCE)) || DECODE(RTRIM(LOC.STATE)
, NULL
, ' '
, '
, '||RTRIM(LOC.STATE))
, 1
, 30)
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.CITY || ' ' || NVL(LOC.STATE
, LOC.PROVINCE) || ' ' || LOC.POSTAL_CODE ADDRESS3
, CUST_ACCT.CREATED_BY
, CUST_ACCT.CREATION_DATE
, CUST_ACCT.LAST_UPDATE_DATE
, CUST_ACCT.LAST_UPDATE_LOGIN
, CUST_ACCT.LAST_UPDATED_BY
, CUST_ACCT.ROWID
, NULL
, NULL
, SOB.CURRENCY_CODE
, DECODE(RC.TYPE
, 'STATIC'
, RC.RISK_COMMENT
, NULL)
FROM HZ_CUST_SITE_USES SU
, HZ_CUST_ACCT_SITES ACCT_SITE
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
, AR_TA_RISK_COMENT RC
, GL_SETS_OF_BOOKS SOB
, AR_SYSTEM_PARAMETERS SP
WHERE ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND SU.SITE_USE_CODE = 'BILL_TO'
AND ACCT_SITE.CUST_ACCOUNT_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND SU.SITE_USE_ID = RC.CUSTOMER_SITE_USE_ID(+)
AND SP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID