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_LOOKUPS

Line 303: trx_type_disp cn_lookups.meaning%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,
306: revenue_type_disp cn_lookups.meaning%TYPE,
307: adjust_status_disp cn_lookups.meaning%TYPE,

Line 304: reason cn_lookups.meaning%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,
306: revenue_type_disp cn_lookups.meaning%TYPE,
307: adjust_status_disp cn_lookups.meaning%TYPE,
308: terr_id cn_comm_lines_api.terr_id%TYPE,

Line 306: revenue_type_disp cn_lookups.meaning%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,
306: revenue_type_disp cn_lookups.meaning%TYPE,
307: adjust_status_disp cn_lookups.meaning%TYPE,
308: terr_id cn_comm_lines_api.terr_id%TYPE,
309: preserve_credit_override_flag cn_comm_lines_api.preserve_credit_override_flag%TYPE);
310: l_api_rec api_rec;

Line 307: adjust_status_disp cn_lookups.meaning%TYPE,

303: trx_type_disp cn_lookups.meaning%TYPE,
304: reason cn_lookups.meaning%TYPE,
305: revenue_class_name cn_revenue_classes.name%TYPE,
306: revenue_type_disp cn_lookups.meaning%TYPE,
307: adjust_status_disp cn_lookups.meaning%TYPE,
308: terr_id cn_comm_lines_api.terr_id%TYPE,
309: preserve_credit_override_flag cn_comm_lines_api.preserve_credit_override_flag%TYPE);
310: l_api_rec api_rec;
311:

Line 487: status_disp cn_lookups.meaning%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,
490: revenue_class_name cn_revenue_classes.name%TYPE,
491: revenue_type_disp cn_lookups.meaning%TYPE,

Line 488: trx_type_disp cn_lookups.meaning%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,
490: revenue_class_name cn_revenue_classes.name%TYPE,
491: revenue_type_disp cn_lookups.meaning%TYPE,
492: adjust_status_disp cn_lookups.meaning%TYPE,

Line 489: reason cn_lookups.meaning%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,
490: revenue_class_name cn_revenue_classes.name%TYPE,
491: revenue_type_disp cn_lookups.meaning%TYPE,
492: adjust_status_disp cn_lookups.meaning%TYPE,
493: trx_batch_name cn_trx_batches.trx_batch_name%TYPE,

Line 491: revenue_type_disp cn_lookups.meaning%TYPE,

487: status_disp cn_lookups.meaning%TYPE,
488: trx_type_disp cn_lookups.meaning%TYPE,
489: reason cn_lookups.meaning%TYPE,
490: revenue_class_name cn_revenue_classes.name%TYPE,
491: revenue_type_disp cn_lookups.meaning%TYPE,
492: adjust_status_disp cn_lookups.meaning%TYPE,
493: trx_batch_name cn_trx_batches.trx_batch_name%TYPE,
494: terr_id cn_comm_lines_api.terr_id%TYPE,
495: preserve_credit_override_flag cn_comm_lines_api.preserve_credit_override_flag%TYPE

Line 492: adjust_status_disp cn_lookups.meaning%TYPE,

488: trx_type_disp cn_lookups.meaning%TYPE,
489: reason cn_lookups.meaning%TYPE,
490: revenue_class_name cn_revenue_classes.name%TYPE,
491: revenue_type_disp cn_lookups.meaning%TYPE,
492: adjust_status_disp cn_lookups.meaning%TYPE,
493: trx_batch_name cn_trx_batches.trx_batch_name%TYPE,
494: terr_id cn_comm_lines_api.terr_id%TYPE,
495: preserve_credit_override_flag cn_comm_lines_api.preserve_credit_override_flag%TYPE
496: );

Line 609: 'cn_lookups CLT, cn_lookups CLR, cn_lookups CLS, cn_lookups CLRV, '||

605: 'CTB.trx_batch_name, '||
606: --Added for Crediting bug
607: 'API.terr_id, API.preserve_credit_override_flag '||
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 '||
613: 'WHERE CCH.direct_salesrep_id = RSD.salesrep_id '||

Line 610: 'cn_lookups CLAD, cn_revenue_classes CNR, cn_quotas CQ, cn_trx_batches CTB, '||

606: --Added for Crediting bug
607: 'API.terr_id, API.preserve_credit_override_flag '||
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 '||
613: 'WHERE CCH.direct_salesrep_id = RSD.salesrep_id '||
614: --Modified for Crediting Bug

Line 696: 'cn_revenue_classes CNR, cn_lookups CLT, '||

692: --Modified for Crediting Bug
693: 'CCLA.terr_id, CCLA.preserve_credit_override_flag '||
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 '||
700: 'AND CCLA.revenue_class_id = CNR.revenue_class_id(+) '||

Line 697: 'cn_lookups CLRV, cn_lookups CLAD,cn_lookups CLR '||

693: 'CCLA.terr_id, CCLA.preserve_credit_override_flag '||
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 '||
700: 'AND CCLA.revenue_class_id = CNR.revenue_class_id(+) '||
701: 'AND CCLA.reason_code = CLR.lookup_code(+) '||