DBA Data[Home] [Help]

APPS.CN_GET_TX_DATA_PUB dependencies on JTF_RS_SALESREPS

Line 2806: jtf_rs_salesreps s,

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

Line 2824: jtf_rs_salesreps s,

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