VIEW: APPS.CSC_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, ORGANIZATION_ID ORG_ID, ORG.NAME OPERATING_UNIT, CUST.LAST_UPDATE_DATE, CUST.LAST_UPDATED_BY, CUST.CREATION_DATE, CUST.CREATED_BY, CUST.LAST_UPDATE_LOGIN, CUST.OBJECT_VERSION_NUMBER, 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 FROM HZ_CUST_SITE_USES cust, AR_LOOKUPS lookup, HR_OPERATING_UNITS ORG WHERE cust.site_use_code = lookup.lookup_code AND lookup.lookup_type = 'SITE_USE_CODE' AND cust.org_id = org.organization_id

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
, ORGANIZATION_ID ORG_ID
, ORG.NAME OPERATING_UNIT
, CUST.LAST_UPDATE_DATE
, CUST.LAST_UPDATED_BY
, CUST.CREATION_DATE
, CUST.CREATED_BY
, CUST.LAST_UPDATE_LOGIN
, CUST.OBJECT_VERSION_NUMBER
, 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
FROM HZ_CUST_SITE_USES CUST
, AR_LOOKUPS LOOKUP
, HR_OPERATING_UNITS ORG
WHERE CUST.SITE_USE_CODE = LOOKUP.LOOKUP_CODE
AND LOOKUP.LOOKUP_TYPE = 'SITE_USE_CODE'
AND CUST.ORG_ID = ORG.ORGANIZATION_ID