VIEW: APPS.ARBV_CUSTOMER_SITES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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