DBA Data[Home] [Help]

APPS.JAI_AR_SUP_TRX_PKG dependencies on RA_CUST_TRX_LINE_SALESREPS_ALL

Line 2070: RA_CUST_TRX_LINE_SALESREPS_ALL C

2066: a.INVENTORY_ITEM_ID,
2067: a.interface_line_attribute2
2068: from JAI_AR_SUP_HDRS_ALL b,
2069: JAI_AR_SUP_LINES a,
2070: RA_CUST_TRX_LINE_SALESREPS_ALL C
2071: where a.customer_trx_id = b.customer_trx_id
2072: and a.sup_inv_type = b.supp_inv_type
2073: and c.customer_trx_line_id = a.customer_Trx_line_id
2074: and b.set_of_books_id = sob_id

Line 2097: RA_CUST_TRX_LINE_SALESREPS_ALL C,

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

Line 2143: FROM RA_CUST_TRX_LINE_SALESREPS_ALL A,

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