DBA Data[Home] [Help]

APPS.JAI_AR_SUP_TRX_PKG dependencies on RA_SALESREPS_ALL

Line 2098: ra_salesreps_all d

2094: D.SALES_CREDIT_TYPE_ID
2095: from JAI_AR_SUP_HDRS_ALL b,
2096: JAI_AR_SUP_LINES a,
2097: RA_CUST_TRX_LINE_SALESREPS_ALL C,
2098: ra_salesreps_all d
2099: where a.customer_trx_id = b.customer_trx_id
2100: and a.sup_inv_type = b.supp_inv_type
2101: and c.customer_trx_line_id = a.customer_Trx_line_id
2102: and c.salesrep_id = d.salesrep_id

Line 2145: RA_SALESREPS_ALL C

2141: C.sales_credit_type_id,
2142: A.cust_trx_line_salesrep_id
2143: FROM RA_CUST_TRX_LINE_SALESREPS_ALL A,
2144: JAI_AR_SUP_LINES B,
2145: RA_SALESREPS_ALL C
2146: WHERE A.CUSTOMER_TRX_LINE_ID =INVLNO
2147: AND C.salesrep_id = A.salesrep_id;
2148:
2149: CURSOR GET_CONVERSION_RATE(id number) IS