eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CNSBPS_INTERNAL_V

Source

View Text - Preformatted


SELECT sheet.salesrep_id, sheet.payrun_id, quota.quota_id, quota.name, pay.accounting_period_id FROM CN_PAYMENT_WORKSHEETS SHEET,CN_PAYRUNS PAY,CN_SRP_PERIOD_QUOTAS SRP,CN_QUOTAS QUOTA WHERE pay.payrun_id = sheet.payrun_id AND srp.period_id = pay.accounting_period_id AND srp.salesrep_id = sheet.salesrep_id AND quota.quota_id = srp.quota_id AND quota.quota_type_code = 'MANUAL'

View Text - HTML Formatted

SELECT SHEET.SALESREP_ID
, SHEET.PAYRUN_ID
, QUOTA.QUOTA_ID
, QUOTA.NAME
, PAY.ACCOUNTING_PERIOD_ID
FROM CN_PAYMENT_WORKSHEETS SHEET
, CN_PAYRUNS PAY
, CN_SRP_PERIOD_QUOTAS SRP
, CN_QUOTAS QUOTA
WHERE PAY.PAYRUN_ID = SHEET.PAYRUN_ID
AND SRP.PERIOD_ID = PAY.ACCOUNTING_PERIOD_ID
AND SRP.SALESREP_ID = SHEET.SALESREP_ID
AND QUOTA.QUOTA_ID = SRP.QUOTA_ID
AND QUOTA.QUOTA_TYPE_CODE = 'MANUAL'