DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on AR_LOOKUPS

Line 1395: FROM ar_lookups

1391: BEGIN
1392:
1393: OPEN x_locationcode FOR
1394: SELECT lookup_code, meaning, description
1395: FROM ar_lookups
1396: WHERE lookup_type = 'FOB'
1397: AND nvl(start_date_active, sysdate)<=sysdate
1398: AND nvl(end_date_active,sysdate)>=sysdate
1399: AND enabled_flag = 'Y'

Line 1402: --Bug 2961355:Changed the query to query from ar_lookups as fnd_lookup_values_vl had duplicate entries based on application id

1398: AND nvl(end_date_active,sysdate)>=sysdate
1399: AND enabled_flag = 'Y'
1400: AND meaning like (p_location_code)
1401: ORDER BY Upper (lookup_code);
1402: --Bug 2961355:Changed the query to query from ar_lookups as fnd_lookup_values_vl had duplicate entries based on application id
1403: END get_locationcode_lov;
1404:
1405: /* Direct Shipping */
1406: