VIEW: APPS.AST_LOCATION_SITE_USE_V

Source

View Text - Preformatted

SELECT use.rowid, use.PARTY_SITE_USE_ID, use.PARTY_SITE_ID, use.PRIMARY_PER_TYPE, use.SITE_USE_TYPE, lkup.meaning, use.LAST_UPDATE_DATE, use.LAST_UPDATED_BY, use.LAST_UPDATE_LOGIN, use.CREATED_BY, use.CREATION_DATE, use.STATUS, use.object_version_number, use.created_by_module, use.application_id FROM HZ_PARTY_SITE_USES use, AR_LOOKUPS lkup WHERE use.site_use_type = lkup.lookup_code(+) AND lkup.lookup_type(+) = 'PARTY_SITE_USE_CODE' AND use.status IN ('A','I')

View Text - HTML Formatted

SELECT USE.ROWID
, USE.PARTY_SITE_USE_ID
, USE.PARTY_SITE_ID
, USE.PRIMARY_PER_TYPE
, USE.SITE_USE_TYPE
, LKUP.MEANING
, USE.LAST_UPDATE_DATE
, USE.LAST_UPDATED_BY
, USE.LAST_UPDATE_LOGIN
, USE.CREATED_BY
, USE.CREATION_DATE
, USE.STATUS
, USE.OBJECT_VERSION_NUMBER
, USE.CREATED_BY_MODULE
, USE.APPLICATION_ID
FROM HZ_PARTY_SITE_USES USE
, AR_LOOKUPS LKUP
WHERE USE.SITE_USE_TYPE = LKUP.LOOKUP_CODE(+)
AND LKUP.LOOKUP_TYPE(+) = 'PARTY_SITE_USE_CODE'
AND USE.STATUS IN ('A'
, 'I')