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_GET_TX_DATA_PUB dependencies on CN_LOOKUPS

Line 740: cn_lookups clad,

736: clad.meaning adjust_status_disp,
737: clt.meaning trx_type_disp
738: FROM cn_comm_lines_api l,
739: cn_salesreps s,
740: cn_lookups clad,
741: cn_lookups clt
742: WHERE l.trx_type = clt.lookup_code(+)
743: AND clt.lookup_type (+)= 'TRX TYPES'
744: AND l.adjust_status = clad.lookup_code(+)

Line 741: cn_lookups clt

737: clt.meaning trx_type_disp
738: FROM cn_comm_lines_api l,
739: cn_salesreps s,
740: cn_lookups clad,
741: cn_lookups clt
742: WHERE l.trx_type = clt.lookup_code(+)
743: AND clt.lookup_type (+)= 'TRX TYPES'
744: AND l.adjust_status = clad.lookup_code(+)
745: AND clad.lookup_type (+)= 'ADJUST_STATUS'

Line 758: cn_lookups clad,

754: clad.meaning adjust_status_disp,
755: clt.meaning trx_type_disp
756: FROM cn_commission_headers h,
757: cn_salesreps s,
758: cn_lookups clad,
759: cn_lookups clt
760: WHERE h.trx_type = clt.lookup_code(+)
761: AND clt.lookup_type (+)= 'TRX TYPES'
762: AND h.adjust_status = clad.lookup_code(+)

Line 759: cn_lookups clt

755: clt.meaning trx_type_disp
756: FROM cn_commission_headers h,
757: cn_salesreps s,
758: cn_lookups clad,
759: cn_lookups clt
760: WHERE h.trx_type = clt.lookup_code(+)
761: AND clt.lookup_type (+)= 'TRX TYPES'
762: AND h.adjust_status = clad.lookup_code(+)
763: AND clad.lookup_type (+)= 'ADJUST_STATUS'

Line 2807: cn_lookups clt,

2803: cch.transaction_amount,cch.transaction_amount_orig
2804: FROM cn_commission_headers cch,
2805: jtf_rs_resource_extns_vl re,
2806: jtf_rs_salesreps s,
2807: cn_lookups clt,
2808: cn_period_statuses cpsp
2809: WHERE cch.direct_salesrep_id = s.salesrep_id
2810: AND s.resource_id = re.resource_id
2811: AND cch.processed_period_id = cpsp.period_id

Line 2825: cn_lookups clt,

2821: ccla.acctd_transaction_amount,ccla.transaction_amount
2822: FROM cn_comm_lines_api ccla,
2823: jtf_rs_resource_extns_vl re,
2824: jtf_rs_salesreps s,
2825: cn_lookups clt,
2826: cn_period_statuses cpsp
2827: WHERE ccla.salesrep_id = s.salesrep_id
2828: AND s.resource_id = re.resource_id
2829: AND ccla.processed_period_id = cpsp.period_id