APPS.GMD_QCR05USR_XMLP_PKG SQL Statements

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

Line: 109

                                              (select test_id
                           		     from gmd_results r
                           		      where
                                                  r.result_date > ''' || TO_CHAR(SYSDATE - NVL(EXCLUSIVE_WITHIN
                                      ,0)) || ''')';

Line: 215

        SELECT
        STATUS_ID
        INTO  L_FROM_STATUS_ID
        FROM
        MTL_MATERIAL_STATUSES
        WHERE STATUS_CODE = FROM_LOTSTATUS;

Line: 228

        SELECT
        STATUS_ID
        INTO  L_TO_STATUS_ID
        FROM
        MTL_MATERIAL_STATUSES
        WHERE STATUS_CODE = TO_LOTSTATUS;

Line: 391

    SELECT
      DISTINCT
      ORGANIZATION_CODE
    INTO ORG_CODE
    FROM
      MTL_PARAMETERS
    WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;