APPS.GMD_QCR01USR_XMLP_PKG SQL Statements

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

Line: 37

        SELECT
          TEST_UNIT
        INTO QCUNIT
        FROM
          GMD_QC_TESTS_B
        WHERE TEST_CODE = ASSAY_CODE;

Line: 49

        SELECT
          TEST_UOM
        INTO QCUNIT
        FROM
          GMD_SPEC_TESTS_B
        WHERE SPEC_ID = QC_SPEC_ID
          AND TEST_ID = QCASSY_TYP_ID;

Line: 67

    SELECT
      '[' || TEST_DESC || ']'
    INTO ASSAYDESC
    FROM
      GMD_QC_TESTS
    WHERE TEST_CODE = ASSAY_CODE;

Line: 87

        SELECT
          MIN_VALUE_NUM
        INTO ACCEPTABLE_RANGE
        FROM
          GMD_QC_TESTS_B
        WHERE TEST_CODE = ASSAY_CODE;

Line: 118

        SELECT
          MAX_VALUE_NUM
        INTO ACCEPTABLE_RANGE
        FROM
          GMD_QC_TESTS_B
        WHERE TEST_CODE = ASSAY_CODE;

Line: 136

    SELECT
      DISTINCT
      GISV.START_DATE
    INTO FROMDATE
    FROM
      GMD_SAMPLES GS,
      GMD_SAMPLING_EVENTS GSE,
      GMD_CUSTOMER_SPEC_VRS GISV,
      GMD_EVENT_SPEC_DISP GES
    WHERE SAMPLE_NO = SAMPLE_NO_1
      AND GS.SAMPLING_EVENT_ID = GSE.SAMPLING_EVENT_ID
      AND GSE.SAMPLING_EVENT_ID = GES.SAMPLING_EVENT_ID
      AND GES.SPEC_USED_FOR_LOT_ATTRIB_IND = 'Y'
      AND GES.SPEC_VR_ID = GISV.SPEC_VR_ID;

Line: 158

    SELECT
      DISTINCT
      GISV.END_DATE
    INTO TODATE
    FROM
      GMD_SAMPLES GS,
      GMD_SAMPLING_EVENTS GSE,
      GMD_CUSTOMER_SPEC_VRS GISV,
      GMD_EVENT_SPEC_DISP GES
    WHERE SAMPLE_NO = SAMPLE_NO_1
      AND GS.SAMPLING_EVENT_ID = GSE.SAMPLING_EVENT_ID
      AND GSE.SAMPLING_EVENT_ID = GES.SAMPLING_EVENT_ID
      AND GES.SPEC_USED_FOR_LOT_ATTRIB_IND = 'Y'
      AND GES.SPEC_VR_ID = GISV.SPEC_VR_ID;

Line: 180

    SELECT
      '[' || TEST_DESC || ']'
    INTO ASSAYDESC
    FROM
      GMD_QC_TESTS
    WHERE TEST_CODE = ASSAY_CODE2;

Line: 198

        SELECT
          TEST_UNIT
        INTO QCUNIT
        FROM
          GMD_QC_TESTS_B
        WHERE TEST_CODE = ASSAY_CODE2;

Line: 210

        SELECT
          TEST_UOM
        INTO QCUNIT
        FROM
          GMD_SPEC_TESTS_B
        WHERE SPEC_ID = QC_SPEC_ID2
          AND TEST_ID = QCASSY_TYP_ID1;

Line: 234

        SELECT
          MIN_VALUE_NUM
        INTO ACCEPTABLE_RANGE
        FROM
          GMD_QC_TESTS_B
        WHERE TEST_CODE = ASSAY_CODE2;

Line: 265

        SELECT
          MAX_VALUE_NUM
        INTO ACCEPTABLE_RANGE
        FROM
          GMD_QC_TESTS_B
        WHERE TEST_CODE = ASSAY_CODE2;

Line: 283

    SELECT
      DISTINCT
      GISV.START_DATE
    INTO FROMDATE1
    FROM
      GMD_SAMPLES GS,
      GMD_SAMPLING_EVENTS GSE,
      GMD_SUPPLIER_SPEC_VRS GISV,
      GMD_EVENT_SPEC_DISP GES
    WHERE SAMPLE_NO = SAMPLE_NO2
      AND GS.SAMPLING_EVENT_ID = GSE.SAMPLING_EVENT_ID
      AND GSE.SAMPLING_EVENT_ID = GES.SAMPLING_EVENT_ID
      AND GES.SPEC_USED_FOR_LOT_ATTRIB_IND = 'Y'
      AND GES.SPEC_VR_ID = GISV.SPEC_VR_ID;

Line: 306

    SELECT
      DISTINCT
      GISV.END_DATE
    INTO TODATE1
    FROM
      GMD_SAMPLES GS,
      GMD_SAMPLING_EVENTS GSE,
      GMD_SUPPLIER_SPEC_VRS GISV,
      GMD_EVENT_SPEC_DISP GES
    WHERE SAMPLE_NO = SAMPLE_NO2
      AND GS.SAMPLING_EVENT_ID = GSE.SAMPLING_EVENT_ID
      AND GSE.SAMPLING_EVENT_ID = GES.SAMPLING_EVENT_ID
      AND GES.SPEC_USED_FOR_LOT_ATTRIB_IND = 'Y'
      AND GES.SPEC_VR_ID = GISV.SPEC_VR_ID;

Line: 413

      SELECT
        TEXT
      FROM
        QC_TEXT_TBL
      WHERE TEXT_CODE = TEXTCODECF
        AND LINE_NO <> - 1
        AND LANG_CODE = 'US';

Line: 442

      SELECT
        TEXT
      FROM
        QC_TEXT_TBL
      WHERE TEXT_CODE = TEXTCODE1CF
        AND LINE_NO <> - 1
        AND LANG_CODE = 'US';

Line: 497

      SELECT
        TEXT
      FROM
        QC_TEXT_TBL
      WHERE TEXT_CODE = TEXT_CODE_1
        AND LINE_NO <> - 1
        AND LANG_CODE = 'US';

Line: 526

      SELECT
        TEXT
      FROM
        QC_TEXT_TBL
      WHERE TEXT_CODE = TEXT_CODE2
        AND LINE_NO <> - 1
        AND LANG_CODE = 'US';

Line: 604

    SELECT
      MEANING
    INTO CUSTVENDTITLE
    FROM
      GEM_LOOKUPS
    WHERE LOOKUP_TYPE = 'GMD_REPORT_TYPE'
      AND LOOKUP_CODE = REPORT_TYPE;

Line: 616

    SELECT
      TEXT_CODE
    INTO TEXTCODE
    FROM
      GMD_SPECIFICATIONS_B
    WHERE SPEC_ID = QC_SPEC_ID;

Line: 631

    SELECT
      TEXT_CODE
    INTO TEXTCODE1
    FROM
      GMD_SPECIFICATIONS_B
    WHERE SPEC_ID = QC_SPEC_ID2;

Line: 656

      SELECT
        DISTINCT
        CONCATENATED_SEGMENTS
      INTO L_FROM_ITEM
      FROM
        MTL_SYSTEM_ITEMS_KFV
      WHERE INVENTORY_ITEM_ID = FROM_ITEM;

Line: 673

      SELECT
        DISTINCT
        CONCATENATED_SEGMENTS
      INTO L_TO_ITEM
      FROM
        MTL_SYSTEM_ITEMS_KFV
      WHERE INVENTORY_ITEM_ID = TO_ITEM;

Line: 744

      SELECT
        MEANING
      INTO INCLUDE1
      FROM
        GEM_LOOKUPS
      WHERE LOOKUP_CODE = '0'
        AND LOOKUP_TYPE = 'QC_INCLUDE';

Line: 752

      SELECT
        MEANING
      INTO INCLUDE1
      FROM
        GEM_LOOKUPS
      WHERE LOOKUP_CODE = '1'
        AND LOOKUP_TYPE = 'QC_INCLUDE';

Line: 766

      SELECT
        MEANING
      INTO PRINT1
      FROM
        GEM_LOOKUPS
      WHERE LOOKUP_CODE = '0'
        AND LOOKUP_TYPE = 'QC_PRINT';

Line: 774

      SELECT
        MEANING
      INTO PRINT1
      FROM
        GEM_LOOKUPS
      WHERE LOOKUP_CODE = '1'
        AND LOOKUP_TYPE = 'QC_PRINT';

Line: 782

      SELECT
        MEANING
      INTO PRINT1
      FROM
        GEM_LOOKUPS
      WHERE LOOKUP_CODE = '2'
        AND LOOKUP_TYPE = 'QC_PRINT';

Line: 790

      SELECT
        MEANING
      INTO PRINT1
      FROM
        GEM_LOOKUPS
      WHERE LOOKUP_CODE = '3'
        AND LOOKUP_TYPE = 'QC_PRINT';

Line: 805

    SELECT
      MEANING
    INTO TEMP1
    FROM
      FND_LOOKUP_VALUES
    WHERE LOOKUP_TYPE = 'GMD_QC_YES_NO'
      AND LOOKUP_CODE = ACCEPT_ANYWAY
      AND LANGUAGE = USERENV('LANG');

Line: 814

    SELECT
      MEANING
    INTO TEMP2
    FROM
      FND_LOOKUP_VALUES
    WHERE LOOKUP_TYPE = 'GMD_QC_YES_NO'
      AND LOOKUP_CODE = FINAL_MARK
      AND LANGUAGE = USERENV('LANG');

Line: 831

    SELECT
      MEANING
    INTO TEMP1
    FROM
      FND_LOOKUP_VALUES
    WHERE LOOKUP_TYPE = 'GMD_QC_YES_NO'
      AND LOOKUP_CODE = ACCEPT_ANYWAY1
      AND LANGUAGE = USERENV('LANG');

Line: 840

    SELECT
      MEANING
    INTO TEMP2
    FROM
      FND_LOOKUP_VALUES
    WHERE LOOKUP_TYPE = 'GMD_QC_YES_NO'
      AND LOOKUP_CODE = FINAL_MARK1
      AND LANGUAGE = USERENV('LANG');

Line: 900

    SELECT
      DISTINCT
      TEST_TYPE
    INTO ASSAYTYPE
    FROM
      GMD_QC_TESTS_B
    WHERE TEST_CODE = ASSAY_CODE;

Line: 909

        SELECT
          DISPLAY_LABEL_NUMERIC_RANGE
        INTO ASSAYVALUE
        FROM
          GMD_QC_TEST_VALUES
        WHERE TEST_ID = QCASSY_TYP_ID
          AND ( MIN_NUM <= TARGETCF
        OR MIN_NUM IS NULL )
          AND ( MAX_NUM >= TARGETCF
        OR MAX_NUM IS NULL );

Line: 934

        SELECT
          DISPLAY_LABEL_NUMERIC_RANGE
        INTO ASSAYVALUE
        FROM
          GMD_QC_TEST_VALUES
        WHERE TEST_ID = QCASSY_TYP_ID
          AND ( MIN_NUM <= MIN_SPECCF
        OR MIN_NUM IS NULL )
          AND ( MAX_NUM >= MIN_SPECCF
        OR MAX_NUM IS NULL );

Line: 957

        SELECT
          DISPLAY_LABEL_NUMERIC_RANGE
        INTO ASSAYVALUE
        FROM
          GMD_QC_TEST_VALUES
        WHERE TEST_ID = QCASSY_TYP_ID
          AND ( MIN_NUM <= MAX_SPECCF
        OR MIN_NUM IS NULL )
          AND ( MAX_NUM >= MAX_SPECCF
        OR MAX_NUM IS NULL );

Line: 980

        SELECT
          DISPLAY_LABEL_NUMERIC_RANGE
        INTO ASSAYVALUE
        FROM
          GMD_QC_TEST_VALUES
        WHERE TEST_ID = QCASSY_TYP_ID1
          AND ( MIN_NUM <= MAX_SPEC1CF
        OR MIN_NUM IS NULL )
          AND ( MAX_NUM >= MAX_SPEC1CF
        OR MAX_NUM IS NULL );

Line: 1004

        SELECT
          DISPLAY_LABEL_NUMERIC_RANGE
        INTO ASSAYVALUE
        FROM
          GMD_QC_TEST_VALUES
        WHERE TEST_ID = QCASSY_TYP_ID1
          AND ( MIN_NUM <= MIN_SPEC1CF
        OR MIN_NUM IS NULL )
          AND ( MAX_NUM >= MIN_SPEC1CF
        OR MAX_NUM IS NULL );

Line: 1030

    SELECT
      DISTINCT
      TEST_TYPE
    INTO ASSAYTYPE
    FROM
      GMD_QC_TESTS_B
    WHERE TEST_CODE = ASSAY_CODE2;

Line: 1039

        SELECT
          DISPLAY_LABEL_NUMERIC_RANGE
        INTO ASSAYVALUE
        FROM
          GMD_QC_TEST_VALUES
        WHERE TEST_ID = QCASSY_TYP_ID1
          AND ( MIN_NUM <= TARGET1CF
        OR MIN_NUM IS NULL )
          AND ( MAX_NUM >= TARGET1CF
        OR MAX_NUM IS NULL );

Line: 1063

        SELECT
          DISPLAY_LABEL_NUMERIC_RANGE
        INTO ASSAYVALUE
        FROM
          GMD_QC_TEST_VALUES
        WHERE TEST_ID = QCASSY_TYP_ID1
          AND ( MIN_NUM <= NUM_RESULT2
        OR MIN_NUM IS NULL )
          AND ( MAX_NUM >= NUM_RESULT2
        OR MAX_NUM IS NULL );

Line: 1086

        SELECT
          DISPLAY_LABEL_NUMERIC_RANGE
        INTO ASSAYVALUE
        FROM
          GMD_QC_TEST_VALUES
        WHERE TEST_ID = QCASSY_TYP_ID
          AND ( MIN_NUM <= NUM_RESULT
        OR MIN_NUM IS NULL )
          AND ( MAX_NUM >= NUM_RESULT
        OR MAX_NUM IS NULL );

Line: 1215

        SELECT
          S.LOCATION
        INTO LOCATION
        FROM
          HZ_CUST_SITE_USES_ALL S
        WHERE S.SITE_USE_ID = SHIP_TO_SITE_ID
          AND S.SITE_USE_CODE = 'SHIP_TO';

Line: 1238

        SELECT
          H.ORDER_NUMBER,
          T.NAME
        INTO ORDER_NUMBER,ORDER_TYPE_NAME
        FROM
          OE_ORDER_HEADERS_ALL H,
          OE_TRANSACTION_TYPES_TL T
        WHERE H.HEADER_ID = ORDER_HEADER_ID
          AND H.ORDER_TYPE_ID = T.TRANSACTION_TYPE_ID
          AND T.LANGUAGE = 'US';

Line: 1265

        SELECT
          NAME
        INTO OP_UNIT
        FROM
          HR_OPERATING_UNITS
        WHERE ORGANIZATION_ID = ORDER_ORG_ID;

Line: 1359

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