[Home] [Help]
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,
309: preserve_credit_override_flag cn_comm_lines_api.preserve_credit_override_flag%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,
494: terr_id cn_comm_lines_api.terr_id%TYPE,
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
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(+) '||