Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_LOCATION_SITE_USE_V |
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')