APPS.JAI_AR_SUP_TRX_PKG dependencies on RA_CUST_TRX_LINE_SALESREPS_ALL

Line 1941: RA_CUST_TRX_LINE_SALESREPS_ALL C

1937: a.INVENTORY_ITEM_ID,
1938: a.interface_line_attribute2
1939: from JAI_AR_SUP_HDRS_ALL b,
1940: JAI_AR_SUP_LINES a,
1941: RA_CUST_TRX_LINE_SALESREPS_ALL C
1942: where a.customer_trx_id = b.customer_trx_id
1943: and a.sup_inv_type = b.supp_inv_type
1944: and c.customer_trx_line_id = a.customer_Trx_line_id
1945: and b.set_of_books_id = sob_id

Line 1968: RA_CUST_TRX_LINE_SALESREPS_ALL C,

1964: INVENTORY_ITEM_ID,
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

Line 2014: FROM RA_CUST_TRX_LINE_SALESREPS_ALL A,

2010: SELECT DISTINCT A.salesrep_id,
2011: A.revenue_percent_split,
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;