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_INVOICE_CHANGES_PVT dependencies on CN_COMMISSION_HEADERS

Line 840: FROM cn_commission_headers h,

836: l_line_number NUMBER,
837: l_revenue_type VARCHAR2,
838: l_split_pct NUMBER) IS
839: SELECT h.*, api.terr_id, api.terr_name, NVL(api.preserve_credit_override_flag,'N') preserve_credit_override_flag
840: FROM cn_commission_headers h,
841: cn_comm_lines_api api
842: WHERE h.direct_salesrep_id = l_salesrep_id
843: AND h.invoice_number = l_invoice_number
844: AND h.line_number = l_line_number

Line 1457: 'FROM cn_period_statuses CPSP, cn_salesreps RSD, cn_commission_headers CCH, '||

1453: 'CCH.direct_salesrep_id,CCH.invoice_number,CCH.line_number, '||
1454: 'CCH.revenue_type,CCH.split_pct,RSD.employee_number, CCH.comm_lines_api_id, '||
1455: --Modified for Crediting Bug
1456: 'API.terr_id, NVL(API.preserve_credit_override_flag,''N'') '||
1457: 'FROM cn_period_statuses CPSP, cn_salesreps RSD, cn_commission_headers CCH, '||
1458: 'cn_lookups CLT, cn_lookups CLR, cn_lookups CLS, cn_lookups CLRV, '||
1459: 'cn_lookups CLAD, cn_revenue_classes CNR, cn_quotas CQ, cn_trx_batches CTB, '||
1460: -- Modified for Crediting Bug
1461: 'cn_comm_lines_api API '||

Line 1730: FROM cn_commission_headers_all ch

1726: SELECT comm_lines_api_id,
1727: invoice_number,
1728: line_number,
1729: revenue_type
1730: FROM cn_commission_headers_all ch
1731: WHERE ch.invoice_number = p_invoice_number
1732: AND ch.trx_type = p_trx_type
1733: AND ch.org_id = p_org_id
1734: AND (ch.adjust_status NOT IN ('FROZEN','REVERSAL')); -- OR