APPS.WSH_REPORTS_MLS_LANG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 6

      v_SelectStmt 		VARCHAR2(800);

Line: 30

      SELECT language_code INTO l_base_lang FROM fnd_languages
      WHERE installed_flag = 'B';

Line: 34

      v_SelectStmt := 'SELECT DISTINCT a.language
         FROM ra_addresses a,
            wsh_departures dp,
            wsh_deliveries dl,
            ra_site_uses_all su
         WHERE a.address_id = su.address_id
            AND su.site_use_id = dl.ultimate_ship_to_id
            AND dl.actual_departure_id = dp.departure_id
            AND dp.status_code = ''CL''
            AND dp.organization_id = :v_warehouse_id';

Line: 47

         v_SelectStmt := v_SelectStmt||' AND dp.departure_id = :v_departure_id';

Line: 51

         v_SelectStmt := v_SelectStmt||' AND dl.delivery_id = :v_delivery_id';

Line: 55

         v_SelectStmt := v_SelectStmt||' AND dp.freight_carrier_code = :v_freight_carrier';

Line: 61

            v_SelectStmt := v_SelectStmt||' AND trunc(dp.actual_departure_date) <= :v_departure_date_hi';

Line: 63

            v_SelectStmt := v_SelectStmt||' AND trunc(dp.actual_departure_date) >= :v_departure_date_lo';

Line: 65

            v_SelectStmt := v_SelectStmt||' AND trunc(dp.actual_departure_date) BETWEEN :v_departure_date_lo AND :v_departure_date_hi';

Line: 73

      DBMS_SQL.PARSE(l_CursorID, v_SelectStmt, DBMS_SQL.V7);