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 741: cn_lookups clad,

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

Line 742: cn_lookups clt

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

Line 759: cn_lookups clad,

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

Line 760: cn_lookups clt

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

Line 2808: cn_lookups clt,

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

Line 2826: cn_lookups clt,

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