VIEW: APPS.CN_SRP_PAYEE_ASSIGNS_V

Source

View Text - Preformatted

SELECT p.srp_payee_assign_id, p.srp_quota_assign_id, p.payee_id, p.quota_id, p.salesrep_id, p.start_date, p.end_date, s.name, s.employee_number from cn_srp_payee_assigns p, cn_salesreps s WHERE p.payee_id = s.salesrep_id

View Text - HTML Formatted

SELECT P.SRP_PAYEE_ASSIGN_ID
, P.SRP_QUOTA_ASSIGN_ID
, P.PAYEE_ID
, P.QUOTA_ID
, P.SALESREP_ID
, P.START_DATE
, P.END_DATE
, S.NAME
, S.EMPLOYEE_NUMBER
FROM CN_SRP_PAYEE_ASSIGNS P
, CN_SALESREPS S
WHERE P.PAYEE_ID = S.SALESREP_ID