VIEW: APPS.AST_SALES_GROUP_ADMINS_V

Source

View Text - Preformatted

SELECT sales.rowid row_id ,sales.sales_group_id ,sales.person_id ,sales.salesforce_id ,sales.last_update_date ,sales.last_updated_by ,sales.creation_date ,sales.created_by ,sales.last_update_login ,sales.attribute_category ,sales.attribute1 ,sales.attribute2 ,sales.attribute3 ,sales.attribute4 ,sales.attribute5 ,sales.attribute6 ,sales.attribute7 ,sales.attribute8 ,sales.attribute9 ,sales.attribute10 ,sales.attribute11 ,sales.attribute12 ,sales.attribute13 ,sales.attribute14 ,sales.attribute15 ,people.first_name ,people.last_name ,people.full_name ,people.email_address ,people.work_telephone ,force.status_code FROM AS_SALES_GRP_ADMIN SALES, PER_PEOPLE_X PEOPLE, AS_SALESFORCE FORCE WHERE sales.person_id = people.person_id and sales.salesforce_id = force.salesforce_id

View Text - HTML Formatted

SELECT SALES.ROWID ROW_ID
, SALES.SALES_GROUP_ID
, SALES.PERSON_ID
, SALES.SALESFORCE_ID
, SALES.LAST_UPDATE_DATE
, SALES.LAST_UPDATED_BY
, SALES.CREATION_DATE
, SALES.CREATED_BY
, SALES.LAST_UPDATE_LOGIN
, SALES.ATTRIBUTE_CATEGORY
, SALES.ATTRIBUTE1
, SALES.ATTRIBUTE2
, SALES.ATTRIBUTE3
, SALES.ATTRIBUTE4
, SALES.ATTRIBUTE5
, SALES.ATTRIBUTE6
, SALES.ATTRIBUTE7
, SALES.ATTRIBUTE8
, SALES.ATTRIBUTE9
, SALES.ATTRIBUTE10
, SALES.ATTRIBUTE11
, SALES.ATTRIBUTE12
, SALES.ATTRIBUTE13
, SALES.ATTRIBUTE14
, SALES.ATTRIBUTE15
, PEOPLE.FIRST_NAME
, PEOPLE.LAST_NAME
, PEOPLE.FULL_NAME
, PEOPLE.EMAIL_ADDRESS
, PEOPLE.WORK_TELEPHONE
, FORCE.STATUS_CODE
FROM AS_SALES_GRP_ADMIN SALES
, PER_PEOPLE_X PEOPLE
, AS_SALESFORCE FORCE
WHERE SALES.PERSON_ID = PEOPLE.PERSON_ID
AND SALES.SALESFORCE_ID = FORCE.SALESFORCE_ID