DBA Data[Home] [Help]

APPS.ARP_UTIL dependencies on RA_CUSTOMER_TRX

Line 1607: ra_customer_trx_lines l

1603: l.line_type,
1604: l.extended_amount,
1605: il.promised_commitment_amount
1606: FROM ra_interface_lines_gt il,
1607: ra_customer_trx_lines l
1608: WHERE l.customer_trx_id = l_customer_trx_id
1609: AND l.customer_trx_line_id = il.interface_line_id (+)
1610: ORDER BY l.line_type ;
1611:

Line 1887: from RA_CUSTOMER_TRX

1883: IF p_customer_trx_id IS NOT NULL THEN
1884:
1885: select INITIAL_CUSTOMER_TRX_ID, PREVIOUS_CUSTOMER_TRX_ID, TRX_DATE
1886: into l_initial_customer_trx_id, l_previous_customer_trx_id, p_start_date
1887: from RA_CUSTOMER_TRX
1888: where CUSTOMER_TRX_ID = p_customer_trx_id;
1889:
1890: END IF;
1891:

Line 1992: from RA_CUSTOMER_TRX

1988: l_date := null;
1989:
1990: select TRX_DATE, ORG_ID
1991: into l_date, l_org_id
1992: from RA_CUSTOMER_TRX
1993: where CUSTOMER_TRX_ID = p_customer_trx_id;
1994:
1995: return Get_Default_SalesGroup(p_salesrep_id, l_org_id, l_date);
1996: