DBA Data[Home] [Help]

APPS.GML_MOBILE_SHIP_CONFIRM dependencies on FND_LOOKUP_VALUES_VL

Line 500: from fnd_lookup_values_vl

496: return '';
497: else
498: select meaning
499: into l_ship_method_meaning
500: from fnd_lookup_values_vl
501: where lookup_type = 'SHIP_METHOD'
502: and view_application_id = 3
503: and lookup_code = p_ship_method_code;
504: end if;

Line 803: from fnd_lookup_values_vl flv

799: meaning,
800:
801: description,
802: lookup_code ship_method_code
803: from fnd_lookup_values_vl flv
804: where lookup_type = 'SHIP_METHOD'
805: and view_application_id = 3
806: and nvl(start_date_active,sysdate)<=sysdate
807: AND nvl(end_date_active,sysdate)>=sysdate