View: HZ_WSRVC_ACCT_SITE_USES_V

Product:	AR - Receivables
Description:	Internal view for Account Site Use
Implementation/DBA Data:	APPS.HZ_WSRVC_ACCT_SITE_USES_V

View Text

SELECT CSU.SITE_USE_ID SITE_USE_ID
, CSU.CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID
, CSU.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CSU.LAST_UPDATED_BY LAST_UPDATED_BY
, CSU.CREATION_DATE CREATION_DATE
, CSU.CREATED_BY CREATED_BY
, CSU.SITE_USE_CODE SITE_USE_CODE
, CSU.PRIMARY_FLAG PRIMARY_FLAG
, CSU.STATUS STATUS
, CSU.LOCATION LOCATION
, CSU.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CSU.CONTACT_ID CONTACT_ID
, CSU.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, CSU.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, CSU.SIC_CODE SIC_CODE
, CSU.PAYMENT_TERM_ID PAYMENT_TERM_ID
, CSU.GSA_INDICATOR GSA_INDICATOR
, CSU.SHIP_PARTIAL SHIP_PARTIAL
, CSU.SHIP_VIA SHIP_VIA
, CSU.FOB_POINT FOB_POINT
, CSU.ORDER_TYPE_ID ORDER_TYPE_ID
, CSU.PRICE_LIST_ID PRICE_LIST_ID
, CSU.FREIGHT_TERM FREIGHT_TERM
, CSU.WAREHOUSE_ID WAREHOUSE_ID
, CSU.TERRITORY_ID TERRITORY_ID
, CSU.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CSU.ATTRIBUTE1 ATTRIBUTE1
, CSU.ATTRIBUTE2 ATTRIBUTE2
, CSU.ATTRIBUTE3 ATTRIBUTE3
, CSU.ATTRIBUTE4 ATTRIBUTE4
, CSU.ATTRIBUTE5 ATTRIBUTE5
, CSU.ATTRIBUTE6 ATTRIBUTE6
, CSU.ATTRIBUTE7 ATTRIBUTE7
, CSU.ATTRIBUTE8 ATTRIBUTE8
, CSU.ATTRIBUTE9 ATTRIBUTE9
, CSU.ATTRIBUTE10 ATTRIBUTE10
, CSU.REQUEST_ID REQUEST_ID
, CSU.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CSU.PROGRAM_ID PROGRAM_ID
, CSU.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CSU.TAX_REFERENCE TAX_REFERENCE
, CSU.SORT_PRIORITY SORT_PRIORITY
, CSU.TAX_CODE TAX_CODE
, CSU.ATTRIBUTE11 ATTRIBUTE11
, CSU.ATTRIBUTE12 ATTRIBUTE12
, CSU.ATTRIBUTE13 ATTRIBUTE13
, CSU.ATTRIBUTE14 ATTRIBUTE14
, CSU.ATTRIBUTE15 ATTRIBUTE15
, CSU.ATTRIBUTE16 ATTRIBUTE16
, CSU.ATTRIBUTE17 ATTRIBUTE17
, CSU.ATTRIBUTE18 ATTRIBUTE18
, CSU.ATTRIBUTE19 ATTRIBUTE19
, CSU.ATTRIBUTE20 ATTRIBUTE20
, CSU.ATTRIBUTE21 ATTRIBUTE21
, CSU.ATTRIBUTE22 ATTRIBUTE22
, CSU.ATTRIBUTE23 ATTRIBUTE23
, CSU.ATTRIBUTE24 ATTRIBUTE24
, CSU.ATTRIBUTE25 ATTRIBUTE25
, CSU.LAST_ACCRUE_CHARGE_DATE LAST_ACCRUE_CHARGE_DATE
, CSU.SECOND_LAST_ACCRUE_CHARGE_DATE SECOND_LAST_ACCRUE_CHARGE_DATE
, CSU.LAST_UNACCRUE_CHARGE_DATE LAST_UNACCRUE_CHARGE_DATE
, CSU.SECOND_LAST_UNACCRUE_CHRG_DATE SECOND_LAST_UNACCRUE_CHRG_DATE
, CSU.DEMAND_CLASS_CODE DEMAND_CLASS_CODE
, CSU.ORG_ID ORG_ID
, CSU.TAX_HEADER_LEVEL_FLAG TAX_HEADER_LEVEL_FLAG
, CSU.TAX_ROUNDING_RULE TAX_ROUNDING_RULE
, CSU.WH_UPDATE_DATE WH_UPDATE_DATE
, CSU.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, CSU.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, CSU.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, CSU.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, CSU.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, CSU.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, CSU.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, CSU.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, CSU.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, CSU.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, CSU.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, CSU.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, CSU.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, CSU.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, CSU.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, CSU.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, CSU.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, CSU.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, CSU.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, CSU.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, CSU.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, CSU.PRIMARY_SALESREP_ID PRIMARY_SALESREP_ID
, CSU.FINCHRG_RECEIVABLES_TRX_ID FINCHRG_RECEIVABLES_TRX_ID
, CSU.DATES_NEGATIVE_TOLERANCE DATES_NEGATIVE_TOLERANCE
, CSU.DATES_POSITIVE_TOLERANCE DATES_POSITIVE_TOLERANCE
, CSU.DATE_TYPE_PREFERENCE DATE_TYPE_PREFERENCE
, CSU.OVER_SHIPMENT_TOLERANCE OVER_SHIPMENT_TOLERANCE
, CSU.UNDER_SHIPMENT_TOLERANCE UNDER_SHIPMENT_TOLERANCE
, CSU.ITEM_CROSS_REF_PREF ITEM_CROSS_REF_PREF
, CSU.OVER_RETURN_TOLERANCE OVER_RETURN_TOLERANCE
, CSU.UNDER_RETURN_TOLERANCE UNDER_RETURN_TOLERANCE
, CSU.SHIP_SETS_INCLUDE_LINES_FLAG SHIP_SETS_INCLUDE_LINES_FLAG
, CSU.ARRIVALSETS_INCLUDE_LINES_FLAG ARRIVALSETS_INCLUDE_LINES_FLAG
, CSU.SCHED_DATE_PUSH_FLAG SCHED_DATE_PUSH_FLAG
, CSU.INVOICE_QUANTITY_RULE INVOICE_QUANTITY_RULE
, CSU.PRICING_EVENT PRICING_EVENT
, CSU.GL_ID_REC GL_ID_REC
, CSU.GL_ID_REV GL_ID_REV
, CSU.GL_ID_TAX GL_ID_TAX
, CSU.GL_ID_FREIGHT GL_ID_FREIGHT
, CSU.GL_ID_CLEARING GL_ID_CLEARING
, CSU.GL_ID_UNBILLED GL_ID_UNBILLED
, CSU.GL_ID_UNEARNED GL_ID_UNEARNED
, CSU.GL_ID_UNPAID_REC GL_ID_UNPAID_REC
, CSU.GL_ID_REMITTANCE GL_ID_REMITTANCE
, CSU.GL_ID_FACTOR GL_ID_FACTOR
, CSU.TAX_CLASSIFICATION TAX_CLASSIFICATION
, CSU.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CSU.CREATED_BY_MODULE CREATED_BY_MODULE
, CSU.APPLICATION_ID APPLICATION_ID
, (SELECT ORIG_SYSTEM
FROM HZ_ORIG_SYS_REFERENCES MOSR
WHERE MOSR.ORIG_SYSTEM_REFERENCE = CSU.ORIG_SYSTEM_REFERENCE
AND MOSR.OWNER_TABLE_NAME='HZ_CUST_SITE_USES_ALL'
AND MOSR.OWNER_TABLE_ID = CSU.SITE_USE_ID
AND MOSR.STATUS = 'A') ORIG_SYSTEM
, PROF.CUST_ACCOUNT_PROFILE_ID PROF_CUST_ACCOUNT_PROFILE_ID
, PROF.LAST_UPDATED_BY PROF_LAST_UPDATED_BY
, PROF.LAST_UPDATE_DATE PROF_LAST_UPDATE_DATE
, PROF.LAST_UPDATE_LOGIN PROF_LAST_UPDATE_LOGIN
, PROF.CREATED_BY PROF_CREATED_BY
, PROF.CREATION_DATE PROF_CREATION_DATE
, PROF.CUST_ACCOUNT_ID PROF_CUST_ACCOUNT_ID
, PROF.STATUS PROF_STATUS
, PROF.COLLECTOR_ID PROF_COLLECTOR_ID
, PROF.CREDIT_ANALYST_ID PROF_CREDIT_ANALYST_ID
, PROF.CREDIT_CHECKING PROF_CREDIT_CHECKING
, PROF.NEXT_CREDIT_REVIEW_DATE PROF_NEXT_CREDIT_REVIEW_DATE
, PROF.TOLERANCE PROF_TOLERANCE
, PROF.DISCOUNT_TERMS PROF_DISCOUNT_TERMS
, PROF.DUNNING_LETTERS PROF_DUNNING_LETTERS
, PROF.INTEREST_CHARGES PROF_INTEREST_CHARGES
, PROF.PREF_FUNCTIONAL_CURRENCY PROF_PREF_FUNCTIONAL_CURRENCY
, PROF.SEND_STATEMENTS PROF_SEND_STATEMENTS
, PROF.CREDIT_BALANCE_STATEMENTS PROF_CREDIT_BALANCE_STATEMENTS
, PROF.CREDIT_HOLD PROF_CREDIT_HOLD
, PROF.PROFILE_CLASS_ID PROF_PROFILE_CLASS_ID
, PROF.SITE_USE_ID PROF_SITE_USE_ID
, PROF.CREDIT_RATING PROF_CREDIT_RATING
, PROF.RISK_CODE PROF_RISK_CODE
, PROF.STANDARD_TERMS PROF_STANDARD_TERMS
, PROF.OVERRIDE_TERMS PROF_OVERRIDE_TERMS
, PROF.DUNNING_LETTER_SET_ID PROF_DUNNING_LETTER_SET_ID
, PROF.INTEREST_PERIOD_DAYS PROF_INTEREST_PERIOD_DAYS
, PROF.PAYMENT_GRACE_DAYS PROF_PAYMENT_GRACE_DAYS
, PROF.DISCOUNT_GRACE_DAYS PROF_DISCOUNT_GRACE_DAYS
, PROF.STATEMENT_CYCLE_ID PROF_STATEMENT_CYCLE_ID
, PROF.ACCOUNT_STATUS PROF_ACCOUNT_STATUS
, PROF.PERCENT_COLLECTABLE PROF_PERCENT_COLLECTABLE
, PROF.AUTOCASH_HIERARCHY_ID PROF_AUTOCASH_HIERARCHY_ID
, PROF.ATTRIBUTE_CATEGORY PROF_ATTRIBUTE_CATEGORY
, PROF.ATTRIBUTE1 PROF_ATTRIBUTE1
, PROF.ATTRIBUTE2 PROF_ATTRIBUTE2
, PROF.ATTRIBUTE3 PROF_ATTRIBUTE3
, PROF.ATTRIBUTE4 PROF_ATTRIBUTE4
, PROF.ATTRIBUTE5 PROF_ATTRIBUTE5
, PROF.ATTRIBUTE6 PROF_ATTRIBUTE6
, PROF.ATTRIBUTE7 PROF_ATTRIBUTE7
, PROF.ATTRIBUTE8 PROF_ATTRIBUTE8
, PROF.ATTRIBUTE9 PROF_ATTRIBUTE9
, PROF.ATTRIBUTE10 PROF_ATTRIBUTE10
, PROF.PROGRAM_APPLICATION_ID PROF_PROGRAM_APPLICATION_ID
, PROF.PROGRAM_ID PROF_PROGRAM_ID
, PROF.PROGRAM_UPDATE_DATE PROF_PROGRAM_UPDATE_DATE
, PROF.REQUEST_ID PROF_REQUEST_ID
, PROF.WH_UPDATE_DATE PROF_WH_UPDATE_DATE
, PROF.ATTRIBUTE11 PROF_ATTRIBUTE11
, PROF.ATTRIBUTE12 PROF_ATTRIBUTE12
, PROF.ATTRIBUTE13 PROF_ATTRIBUTE13
, PROF.ATTRIBUTE14 PROF_ATTRIBUTE14
, PROF.ATTRIBUTE15 PROF_ATTRIBUTE15
, PROF.AUTO_REC_INCL_DISPUTED_FLAG AUTO_REC_INCL_DISPUTED_FLAG
, PROF.TAX_PRINTING_OPTION PROF_TAX_PRINTING_OPTION
, PROF.CHARGE_ON_FINANCE_CHARGE_FLAG CHARGE_ON_FINANCE_CHARGE_FLAG
, PROF.GROUPING_RULE_ID PROF_GROUPING_RULE_ID
, PROF.CLEARING_DAYS PROF_CLEARING_DAYS
, PROF.JGZZ_ATTRIBUTE_CATEGORY PROF_JGZZ_ATTRIBUTE_CATEGORY
, PROF.JGZZ_ATTRIBUTE1 PROF_JGZZ_ATTRIBUTE1
, PROF.JGZZ_ATTRIBUTE2 PROF_JGZZ_ATTRIBUTE2
, PROF.JGZZ_ATTRIBUTE3 PROF_JGZZ_ATTRIBUTE3
, PROF.JGZZ_ATTRIBUTE4 PROF_JGZZ_ATTRIBUTE4
, PROF.JGZZ_ATTRIBUTE5 PROF_JGZZ_ATTRIBUTE5
, PROF.JGZZ_ATTRIBUTE6 PROF_JGZZ_ATTRIBUTE6
, PROF.JGZZ_ATTRIBUTE7 PROF_JGZZ_ATTRIBUTE7
, PROF.JGZZ_ATTRIBUTE8 PROF_JGZZ_ATTRIBUTE8
, PROF.JGZZ_ATTRIBUTE9 PROF_JGZZ_ATTRIBUTE9
, PROF.JGZZ_ATTRIBUTE10 PROF_JGZZ_ATTRIBUTE10
, PROF.JGZZ_ATTRIBUTE11 PROF_JGZZ_ATTRIBUTE11
, PROF.JGZZ_ATTRIBUTE12 PROF_JGZZ_ATTRIBUTE12
, PROF.JGZZ_ATTRIBUTE13 PROF_JGZZ_ATTRIBUTE13
, PROF.JGZZ_ATTRIBUTE14 PROF_JGZZ_ATTRIBUTE14
, PROF.JGZZ_ATTRIBUTE15 PROF_JGZZ_ATTRIBUTE15
, PROF.GLOBAL_ATTRIBUTE1 PROF_GLOBAL_ATTRIBUTE1
, PROF.GLOBAL_ATTRIBUTE2 PROF_GLOBAL_ATTRIBUTE2
, PROF.GLOBAL_ATTRIBUTE3 PROF_GLOBAL_ATTRIBUTE3
, PROF.GLOBAL_ATTRIBUTE4 PROF_GLOBAL_ATTRIBUTE4
, PROF.GLOBAL_ATTRIBUTE5 PROF_GLOBAL_ATTRIBUTE5
, PROF.GLOBAL_ATTRIBUTE6 PROF_GLOBAL_ATTRIBUTE6
, PROF.GLOBAL_ATTRIBUTE7 PROF_GLOBAL_ATTRIBUTE7
, PROF.GLOBAL_ATTRIBUTE8 PROF_GLOBAL_ATTRIBUTE8
, PROF.GLOBAL_ATTRIBUTE9 PROF_GLOBAL_ATTRIBUTE9
, PROF.GLOBAL_ATTRIBUTE10 PROF_GLOBAL_ATTRIBUTE10
, PROF.GLOBAL_ATTRIBUTE11 PROF_GLOBAL_ATTRIBUTE11
, PROF.GLOBAL_ATTRIBUTE12 PROF_GLOBAL_ATTRIBUTE12
, PROF.GLOBAL_ATTRIBUTE13 PROF_GLOBAL_ATTRIBUTE13
, PROF.GLOBAL_ATTRIBUTE14 PROF_GLOBAL_ATTRIBUTE14
, PROF.GLOBAL_ATTRIBUTE15 PROF_GLOBAL_ATTRIBUTE15
, PROF.GLOBAL_ATTRIBUTE16 PROF_GLOBAL_ATTRIBUTE16
, PROF.GLOBAL_ATTRIBUTE17 PROF_GLOBAL_ATTRIBUTE17
, PROF.GLOBAL_ATTRIBUTE18 PROF_GLOBAL_ATTRIBUTE18
, PROF.GLOBAL_ATTRIBUTE19 PROF_GLOBAL_ATTRIBUTE19
, PROF.GLOBAL_ATTRIBUTE20 PROF_GLOBAL_ATTRIBUTE20
, PROF.GLOBAL_ATTRIBUTE_CATEGORY PROF_GLOBAL_ATTRIBUTE_CATEGORY
, PROF.CONS_INV_FLAG PROF_CONS_INV_FLAG
, PROF.CONS_INV_TYPE PROF_CONS_INV_TYPE
, PROF.AUTOCASH_HIERARCHY_ID_FOR_ADR AUTOCASH_HIERARCHY_ID_FOR_ADR
, PROF.LOCKBOX_MATCHING_OPTION PROF_LOCKBOX_MATCHING_OPTION
, PROF.OBJECT_VERSION_NUMBER PROF_OBJECT_VERSION_NUMBER
, PROF.CREATED_BY_MODULE PROF_CREATED_BY_MODULE
, PROF.APPLICATION_ID PROF_APPLICATION_ID
, PROF.REVIEW_CYCLE PROF_REVIEW_CYCLE
, PROF.LAST_CREDIT_REVIEW_DATE PROF_LAST_CREDIT_REVIEW_DATE
, PROF.PARTY_ID PROF_PARTY_ID
, PROF.CREDIT_CLASSIFICATION PROF_CREDIT_CLASSIFICATION
FROM HZ_CUST_SITE_USES CSU
, HZ_CUSTOMER_PROFILES PROF
WHERE PROF.SITE_USE_ID (+) = CSU.SITE_USE_ID

Columns