VIEW: APPS.CN_SALESREPS

Source

View Text - Preformatted

SELECT re.resource_name name, s.salesrep_id , s.resource_id, s.salesrep_number employee_number, /* re.source_number */ s.person_id , re.source_id, s.sales_credit_type_id , s.status , s.start_date_active , s.end_date_active , re.assigned_to_group_id assigned_to_user_id, u.user_name assigned_to_user_name, decode(re.category, 'OTHER' , s.email_address, re.source_email) email_address , re.cost_center , re.charge_to_cost_center , re.compensation_currency_code currency_code, s.set_of_books_id , re.category type, re.commissionable_flag, re.hold_payment, re.hold_reason_code, s.org_id , s.attribute_category , s.attribute1 , s.attribute2 , s.attribute3 , s.attribute4 , s.attribute5 , s.attribute6 , s.attribute7 , s.attribute8 , s.attribute9 , s.attribute10 , s.attribute11 , s.attribute12 , s.attribute13 , s.attribute14 , s.attribute15 , s.last_update_date , s.creation_date , s.created_by , s.last_update_login, s.last_updated_by from jtf_rs_resource_extns_vl re, jtf_rs_salesreps_mo_v s, fnd_user u WHERE re.resource_id = s.resource_id and re.assigned_to_group_id = u.user_id ( + ) and re.category <> 'TBH'

View Text - HTML Formatted

SELECT RE.RESOURCE_NAME NAME
, S.SALESREP_ID
, S.RESOURCE_ID
, S.SALESREP_NUMBER EMPLOYEE_NUMBER
, /* RE.SOURCE_NUMBER */ S.PERSON_ID
, RE.SOURCE_ID
, S.SALES_CREDIT_TYPE_ID
, S.STATUS
, S.START_DATE_ACTIVE
, S.END_DATE_ACTIVE
, RE.ASSIGNED_TO_GROUP_ID ASSIGNED_TO_USER_ID
, U.USER_NAME ASSIGNED_TO_USER_NAME
, DECODE(RE.CATEGORY
, 'OTHER'
, S.EMAIL_ADDRESS
, RE.SOURCE_EMAIL) EMAIL_ADDRESS
, RE.COST_CENTER
, RE.CHARGE_TO_COST_CENTER
, RE.COMPENSATION_CURRENCY_CODE CURRENCY_CODE
, S.SET_OF_BOOKS_ID
, RE.CATEGORY TYPE
, RE.COMMISSIONABLE_FLAG
, RE.HOLD_PAYMENT
, RE.HOLD_REASON_CODE
, S.ORG_ID
, S.ATTRIBUTE_CATEGORY
, S.ATTRIBUTE1
, S.ATTRIBUTE2
, S.ATTRIBUTE3
, S.ATTRIBUTE4
, S.ATTRIBUTE5
, S.ATTRIBUTE6
, S.ATTRIBUTE7
, S.ATTRIBUTE8
, S.ATTRIBUTE9
, S.ATTRIBUTE10
, S.ATTRIBUTE11
, S.ATTRIBUTE12
, S.ATTRIBUTE13
, S.ATTRIBUTE14
, S.ATTRIBUTE15
, S.LAST_UPDATE_DATE
, S.CREATION_DATE
, S.CREATED_BY
, S.LAST_UPDATE_LOGIN
, S.LAST_UPDATED_BY
FROM JTF_RS_RESOURCE_EXTNS_VL RE
, JTF_RS_SALESREPS_MO_V S
, FND_USER U
WHERE RE.RESOURCE_ID = S.RESOURCE_ID
AND RE.ASSIGNED_TO_GROUP_ID = U.USER_ID ( + )
AND RE.CATEGORY <> 'TBH'