DBA Data[Home] [Help]

APPS.CN_GET_TX_DATA_PUB dependencies on JTF_RS_SALESREPS

Line 2807: jtf_rs_salesreps s,

2803: cch.invoice_number,cch.invoice_date,cch.quantity,
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

Line 2825: jtf_rs_salesreps s,

2821: ccla.invoice_number,ccla.invoice_date,ccla.quantity,
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