VIEW: APPS.AST_ACCT_SITE_USES_V

Source

View Text - Preformatted

SELECT CUST.ROWID ,CUST.SITE_USE_ID ,CUST.CUST_ACCT_SITE_ID ,CUST.BILL_TO_SITE_USE_ID ,CUST.SITE_USE_CODE ,lookup.MEANING ,CUST.PRIMARY_FLAG ,CUST.STATUS ,CUST.LOCATION ,CUST.LAST_UPDATE_DATE ,CUST.LAST_UPDATED_BY ,CUST.CREATION_DATE ,CUST.CREATED_BY ,CUST.LAST_UPDATE_LOGIN ,cust.attribute_category ,cust.attribute1 ,cust.attribute2 ,cust.attribute3 ,cust.attribute4 ,cust.attribute5 ,cust.attribute6 ,cust.attribute7 ,cust.attribute8 ,cust.attribute9 ,cust.attribute10 ,cust.attribute11 ,cust.attribute12 ,cust.attribute13 ,cust.attribute14 ,cust.attribute15 ,cust.object_version_number ,cust.created_by_module ,application_id ,cust.payment_term_id FROM HZ_CUST_SITE_USES_ALL cust, AR_LOOKUPS lookup WHERE cust.site_use_code = lookup.lookup_code AND lookup.lookup_type = 'SITE_USE_CODE'

View Text - HTML Formatted

SELECT CUST.ROWID
, CUST.SITE_USE_ID
, CUST.CUST_ACCT_SITE_ID
, CUST.BILL_TO_SITE_USE_ID
, CUST.SITE_USE_CODE
, LOOKUP.MEANING
, CUST.PRIMARY_FLAG
, CUST.STATUS
, CUST.LOCATION
, CUST.LAST_UPDATE_DATE
, CUST.LAST_UPDATED_BY
, CUST.CREATION_DATE
, CUST.CREATED_BY
, CUST.LAST_UPDATE_LOGIN
, CUST.ATTRIBUTE_CATEGORY
, CUST.ATTRIBUTE1
, CUST.ATTRIBUTE2
, CUST.ATTRIBUTE3
, CUST.ATTRIBUTE4
, CUST.ATTRIBUTE5
, CUST.ATTRIBUTE6
, CUST.ATTRIBUTE7
, CUST.ATTRIBUTE8
, CUST.ATTRIBUTE9
, CUST.ATTRIBUTE10
, CUST.ATTRIBUTE11
, CUST.ATTRIBUTE12
, CUST.ATTRIBUTE13
, CUST.ATTRIBUTE14
, CUST.ATTRIBUTE15
, CUST.OBJECT_VERSION_NUMBER
, CUST.CREATED_BY_MODULE
, APPLICATION_ID
, CUST.PAYMENT_TERM_ID
FROM HZ_CUST_SITE_USES_ALL CUST
, AR_LOOKUPS LOOKUP
WHERE CUST.SITE_USE_CODE = LOOKUP.LOOKUP_CODE
AND LOOKUP.LOOKUP_TYPE = 'SITE_USE_CODE'