DBA Data[Home] [Help]

APPS.JAI_AR_SUP_TRX_PKG dependencies on RA_SALESREPS_ALL

Line 1969: ra_salesreps_all d

1965: D.SALES_CREDIT_TYPE_ID
1966: from JAI_AR_SUP_HDRS_ALL b,
1967: JAI_AR_SUP_LINES a,
1968: RA_CUST_TRX_LINE_SALESREPS_ALL C,
1969: ra_salesreps_all d
1970: where a.customer_trx_id = b.customer_trx_id
1971: and a.sup_inv_type = b.supp_inv_type
1972: and c.customer_trx_line_id = a.customer_Trx_line_id
1973: and c.salesrep_id = d.salesrep_id

Line 2016: RA_SALESREPS_ALL C

2012: C.sales_credit_type_id,
2013: A.cust_trx_line_salesrep_id
2014: FROM RA_CUST_TRX_LINE_SALESREPS_ALL A,
2015: JAI_AR_SUP_LINES B,
2016: RA_SALESREPS_ALL C
2017: WHERE A.CUSTOMER_TRX_LINE_ID =INVLNO
2018: AND C.salesrep_id = A.salesrep_id;
2019:
2020: CURSOR GET_CONVERSION_RATE(id number) IS