DBA Data[Home] [Help]

APPS.ARP_UTIL dependencies on RA_CUSTOMER_TRX

Line 1666: ra_customer_trx_lines l

1662: l.line_type,
1663: l.extended_amount,
1664: il.promised_commitment_amount
1665: FROM ra_interface_lines_gt il,
1666: ra_customer_trx_lines l
1667: WHERE l.customer_trx_id = l_customer_trx_id
1668: AND l.customer_trx_line_id = il.interface_line_id (+)
1669: ORDER BY l.line_type ;
1670:

Line 1946: from RA_CUSTOMER_TRX

1942: IF p_customer_trx_id IS NOT NULL THEN
1943:
1944: select INITIAL_CUSTOMER_TRX_ID, PREVIOUS_CUSTOMER_TRX_ID, TRX_DATE
1945: into l_initial_customer_trx_id, l_previous_customer_trx_id, p_start_date
1946: from RA_CUSTOMER_TRX
1947: where CUSTOMER_TRX_ID = p_customer_trx_id;
1948:
1949: END IF;
1950:

Line 2051: from RA_CUSTOMER_TRX

2047: l_date := null;
2048:
2049: select TRX_DATE, ORG_ID
2050: into l_date, l_org_id
2051: from RA_CUSTOMER_TRX
2052: where CUSTOMER_TRX_ID = p_customer_trx_id;
2053:
2054: return Get_Default_SalesGroup(p_salesrep_id, l_org_id, l_date);
2055: