DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on AR_LOOKUPS

Line 1427: FROM ar_lookups

1423: BEGIN
1424:
1425: OPEN x_locationcode FOR
1426: SELECT lookup_code, meaning, description
1427: FROM ar_lookups
1428: WHERE lookup_type = 'FOB'
1429: AND nvl(start_date_active, sysdate)<=sysdate
1430: AND nvl(end_date_active,sysdate)>=sysdate
1431: AND enabled_flag = 'Y'

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

1430: AND nvl(end_date_active,sysdate)>=sysdate
1431: AND enabled_flag = 'Y'
1432: AND meaning like (p_location_code)
1433: ORDER BY Upper (lookup_code);
1434: --Bug 2961355:Changed the query to query from ar_lookups as fnd_lookup_values_vl had duplicate entries based on application id
1435: END get_locationcode_lov;
1436:
1437: /* Direct Shipping */
1438: