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_SCA_TRX_PROC_PVT dependencies on CN_SALESREPS

Line 1259: cn_sca_lines_output CSLO, cn_salesreps CS, cn_comm_lines_api CCLA, cn_sca_headers_interface CSHI

1255: CCLA.SPLIT_PCT,
1256: CCLA.SPLIT_status,
1257: ccla.org_id
1258: from
1259: cn_sca_lines_output CSLO, cn_salesreps CS, cn_comm_lines_api CCLA, cn_sca_headers_interface CSHI
1260: where CS.resource_id = CSLO.resource_id -- added org_id join, since one resource can belong to more than one org
1261: and cslo.org_id = cs.org_id
1262: and ccla.org_id = cslo.org_id
1263: and CCLA.comm_lines_api_id = CSLO.source_trx_id

Line 3275: FROM cn_commission_headers CCH, cn_salesreps CS

3271: CCH.OBJECT_VERSION_NUMBER,
3272: CCH.SPLIT_PCT,
3273: CCH.SPLIT_status,
3274: cch.org_id
3275: FROM cn_commission_headers CCH, cn_salesreps CS
3276: WHERE CCH.adj_comm_lines_api_id = sca_rollback_lines(j)
3277: AND CS.salesrep_id = CCH.direct_salesrep_id
3278: AND ((CCH.adjust_status IS NULL) or (CCH.adjust_status <> 'FROZEN')));
3279:

Line 3831: FROM cn_commission_headers CCH, cn_salesreps CS

3827: CCH.OBJECT_VERSION_NUMBER,
3828: CCH.SPLIT_PCT,
3829: CCH.SPLIT_status,
3830: cch.org_id
3831: FROM cn_commission_headers CCH, cn_salesreps CS
3832: WHERE CCH.adj_comm_lines_api_id = sca_lines_rollback(j)
3833: AND CS.salesrep_id = CCH.direct_salesrep_id
3834: AND ((CCH.adjust_status IS NULL) or (CCH.adjust_status <> 'FROZEN')));
3835: