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.

APPS.CN_MASS_ADJUST_UTIL dependencies on CN_SALESREPS

Line 300: direct_salesrep_number cn_salesreps.employee_number%TYPE,

296: sales_channel cn_comm_lines_api.sales_channel%TYPE,
297: object_version_number cn_comm_lines_api.object_version_number%TYPE,
298: split_pct cn_comm_lines_api.split_pct%TYPE,
299: split_status cn_comm_lines_api.split_status%TYPE,
300: direct_salesrep_number cn_salesreps.employee_number%TYPE,
301: direct_salesrep_name cn_salesreps.name%TYPE,
302: period_name cn_period_statuses.period_name%TYPE,
303: trx_type_disp cn_lookups.meaning%TYPE,
304: reason cn_lookups.meaning%TYPE,

Line 301: direct_salesrep_name cn_salesreps.name%TYPE,

297: object_version_number cn_comm_lines_api.object_version_number%TYPE,
298: split_pct cn_comm_lines_api.split_pct%TYPE,
299: split_status cn_comm_lines_api.split_status%TYPE,
300: direct_salesrep_number cn_salesreps.employee_number%TYPE,
301: direct_salesrep_name cn_salesreps.name%TYPE,
302: period_name cn_period_statuses.period_name%TYPE,
303: trx_type_disp cn_lookups.meaning%TYPE,
304: reason cn_lookups.meaning%TYPE,
305: revenue_class_name cn_revenue_classes.name%TYPE,

Line 484: direct_salesrep_number cn_salesreps.employee_number%TYPE,

480: sales_channel cn_commission_headers.sales_channel%TYPE,
481: object_version_number cn_commission_headers.object_version_number%TYPE,
482: split_pct cn_commission_headers.split_pct%TYPE,
483: split_status cn_commission_headers.split_status%TYPE,
484: direct_salesrep_number cn_salesreps.employee_number%TYPE,
485: direct_salesrep_name cn_salesreps.name%TYPE,
486: period_name cn_period_statuses.period_name%TYPE,
487: status_disp cn_lookups.meaning%TYPE,
488: trx_type_disp cn_lookups.meaning%TYPE,

Line 485: direct_salesrep_name cn_salesreps.name%TYPE,

481: object_version_number cn_commission_headers.object_version_number%TYPE,
482: split_pct cn_commission_headers.split_pct%TYPE,
483: split_status cn_commission_headers.split_status%TYPE,
484: direct_salesrep_number cn_salesreps.employee_number%TYPE,
485: direct_salesrep_name cn_salesreps.name%TYPE,
486: period_name cn_period_statuses.period_name%TYPE,
487: status_disp cn_lookups.meaning%TYPE,
488: trx_type_disp cn_lookups.meaning%TYPE,
489: reason cn_lookups.meaning%TYPE,

Line 608: 'FROM cn_period_statuses CPSP, cn_salesreps RSD, cn_commission_headers_all CCH, '||

604: 'CLRV.meaning revenue_type_disp, CLAD.meaning adjust_status_disp, '||
605: 'CTB.trx_batch_name, '||
606: --Added for Crediting bug
607: 'API.terr_id, NVL(API.preserve_credit_override_flag,''N'') '||
608: 'FROM cn_period_statuses CPSP, cn_salesreps RSD, cn_commission_headers_all CCH, '||
609: 'cn_lookups CLT, cn_lookups CLR, cn_lookups CLS, cn_lookups CLRV, '||
610: 'cn_lookups CLAD, cn_revenue_classes CNR, cn_quotas CQ, cn_trx_batches CTB, '||
611: -- Modified for Crediting Bug
612: 'cn_comm_lines_api API '||

Line 695: 'cn_period_statuses CPSP, cn_salesreps RSD, '||

691: 'CLRV.meaning revenue_type_disp, CLAD.meaning adjust_status_disp, '||
692: --Modified for Crediting Bug
693: 'CCLA.terr_id, NVL(CCLA.preserve_credit_override_flag,''N'') '||
694: 'FROM cn_comm_lines_api_all CCLA, '||
695: 'cn_period_statuses CPSP, cn_salesreps RSD, '||
696: 'cn_revenue_classes CNR, cn_lookups CLT, '||
697: 'cn_lookups CLRV, cn_lookups CLAD,cn_lookups CLR '||
698: 'WHERE RSD.salesrep_id = CCLA.salesrep_id '||
699: 'AND CCLA.processed_period_id = CPSP.period_id '||