View: ARBV_CUSTOMER_SITES

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.ARBV_CUSTOMER_SITES

View Text

SELECT /* UNIQUE ATTRIBUTES */ SUA.SITE_USE_ID
, /* REGULAR ATTRIBUTES */ '_LA:SUA.SITE_USE_CODE:AR_LOOKUPS:SITE_USE_CODE:MEANING'
, SUA.LOCATION
, '_LA:SUA.PRIMARY_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, '_LA:SUA.STATUS:AR_LOOKUPS:CODE_STATUS:MEANING'
, SUA.TAX_CODE
, SUA.TAX_REFERENCE
, SUA.SIC_CODE
, '_LA:SUA.FOB_POINT:AR_LOOKUPS:FOB:MEANING'
, '_LA:SUA.SHIP_PARTIAL:AR_LOOKUPS:YES/NO:MEANING'
, SUA.SHIP_VIA
, '_LA:SUA.GSA_INDICATOR:AR_LOOKUPS:YES/NO:MEANING'
, '_LA:SUA.DEMAND_CLASS_CODE:FND_COMMON_LOOKUPS:DEMAND_CLASS:MEANING'
, '_LA:SUA.FREIGHT_TERM:OE_LOOKUPS:FREIGHT_TERMS:MEANING'
, '_LA:SUA.TAX_CLASSIFICATION:AR_LOOKUPS:AR_TAX_CLASSIFICATION:MEANING'
, '_LA:SUA.TAX_HEADER_LEVEL_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, '_LA:SUA.TAX_ROUNDING_RULE:AR_LOOKUPS:AR_TAX_ROUNDING_RULE:MEANING'
, /* IDS */ SUA.ORG_ID
, SUA.CUST_ACCT_SITE_ID
, SUA.BILL_TO_SITE_USE_ID
, SUA.CONTACT_ID
, SUA.WAREHOUSE_ID
, SUA.TERRITORY_ID
, SUA.ORDER_TYPE_ID
, SUA.PRICE_LIST_ID
, SUA.PRIMARY_SALESREP_ID
, /* WHO COLUMNS */ SUA.LAST_UPDATE_DATE
, SUA.LAST_UPDATED_BY
, SUA.CREATION_DATE
, SUA.CREATED_BY
FROM HZ_CUST_SITE_USES_ALL SUA
WHERE '_SEC:SUA.ORG_ID' IS NOT NULL WITH READ ONLY

Columns