The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
TEST_UNIT
INTO QCUNIT
FROM
GMD_QC_TESTS_B
WHERE TEST_CODE = ASSAY_CODE;
SELECT
TEST_UOM
INTO QCUNIT
FROM
GMD_SPEC_TESTS_B
WHERE SPEC_ID = QC_SPEC_ID
AND TEST_ID = QCASSY_TYP_ID;
SELECT
'[' || TEST_DESC || ']'
INTO ASSAYDESC
FROM
GMD_QC_TESTS
WHERE TEST_CODE = ASSAY_CODE;
SELECT
MIN_VALUE_NUM
INTO ACCEPTABLE_RANGE
FROM
GMD_QC_TESTS_B
WHERE TEST_CODE = ASSAY_CODE;
SELECT
MAX_VALUE_NUM
INTO ACCEPTABLE_RANGE
FROM
GMD_QC_TESTS_B
WHERE TEST_CODE = ASSAY_CODE;
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;
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;
SELECT
'[' || TEST_DESC || ']'
INTO ASSAYDESC
FROM
GMD_QC_TESTS
WHERE TEST_CODE = ASSAY_CODE2;
SELECT
TEST_UNIT
INTO QCUNIT
FROM
GMD_QC_TESTS_B
WHERE TEST_CODE = ASSAY_CODE2;
SELECT
TEST_UOM
INTO QCUNIT
FROM
GMD_SPEC_TESTS_B
WHERE SPEC_ID = QC_SPEC_ID2
AND TEST_ID = QCASSY_TYP_ID1;
SELECT
MIN_VALUE_NUM
INTO ACCEPTABLE_RANGE
FROM
GMD_QC_TESTS_B
WHERE TEST_CODE = ASSAY_CODE2;
SELECT
MAX_VALUE_NUM
INTO ACCEPTABLE_RANGE
FROM
GMD_QC_TESTS_B
WHERE TEST_CODE = ASSAY_CODE2;
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;
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;
SELECT
TEXT
FROM
QC_TEXT_TBL
WHERE TEXT_CODE = TEXTCODECF
AND LINE_NO <> - 1
AND LANG_CODE = 'US';
SELECT
TEXT
FROM
QC_TEXT_TBL
WHERE TEXT_CODE = TEXTCODE1CF
AND LINE_NO <> - 1
AND LANG_CODE = 'US';
SELECT
TEXT
FROM
QC_TEXT_TBL
WHERE TEXT_CODE = TEXT_CODE_1
AND LINE_NO <> - 1
AND LANG_CODE = 'US';
SELECT
TEXT
FROM
QC_TEXT_TBL
WHERE TEXT_CODE = TEXT_CODE2
AND LINE_NO <> - 1
AND LANG_CODE = 'US';
SELECT
MEANING
INTO CUSTVENDTITLE
FROM
GEM_LOOKUPS
WHERE LOOKUP_TYPE = 'GMD_REPORT_TYPE'
AND LOOKUP_CODE = REPORT_TYPE;
SELECT
TEXT_CODE
INTO TEXTCODE
FROM
GMD_SPECIFICATIONS_B
WHERE SPEC_ID = QC_SPEC_ID;
SELECT
TEXT_CODE
INTO TEXTCODE1
FROM
GMD_SPECIFICATIONS_B
WHERE SPEC_ID = QC_SPEC_ID2;
SELECT
DISTINCT
CONCATENATED_SEGMENTS
INTO L_FROM_ITEM
FROM
MTL_SYSTEM_ITEMS_KFV
WHERE INVENTORY_ITEM_ID = FROM_ITEM;
SELECT
DISTINCT
CONCATENATED_SEGMENTS
INTO L_TO_ITEM
FROM
MTL_SYSTEM_ITEMS_KFV
WHERE INVENTORY_ITEM_ID = TO_ITEM;
SELECT
MEANING
INTO INCLUDE1
FROM
GEM_LOOKUPS
WHERE LOOKUP_CODE = '0'
AND LOOKUP_TYPE = 'QC_INCLUDE';
SELECT
MEANING
INTO INCLUDE1
FROM
GEM_LOOKUPS
WHERE LOOKUP_CODE = '1'
AND LOOKUP_TYPE = 'QC_INCLUDE';
SELECT
MEANING
INTO PRINT1
FROM
GEM_LOOKUPS
WHERE LOOKUP_CODE = '0'
AND LOOKUP_TYPE = 'QC_PRINT';
SELECT
MEANING
INTO PRINT1
FROM
GEM_LOOKUPS
WHERE LOOKUP_CODE = '1'
AND LOOKUP_TYPE = 'QC_PRINT';
SELECT
MEANING
INTO PRINT1
FROM
GEM_LOOKUPS
WHERE LOOKUP_CODE = '2'
AND LOOKUP_TYPE = 'QC_PRINT';
SELECT
MEANING
INTO PRINT1
FROM
GEM_LOOKUPS
WHERE LOOKUP_CODE = '3'
AND LOOKUP_TYPE = 'QC_PRINT';
SELECT
MEANING
INTO TEMP1
FROM
FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'GMD_QC_YES_NO'
AND LOOKUP_CODE = ACCEPT_ANYWAY
AND LANGUAGE = USERENV('LANG');
SELECT
MEANING
INTO TEMP2
FROM
FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'GMD_QC_YES_NO'
AND LOOKUP_CODE = FINAL_MARK
AND LANGUAGE = USERENV('LANG');
SELECT
MEANING
INTO TEMP1
FROM
FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'GMD_QC_YES_NO'
AND LOOKUP_CODE = ACCEPT_ANYWAY1
AND LANGUAGE = USERENV('LANG');
SELECT
MEANING
INTO TEMP2
FROM
FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'GMD_QC_YES_NO'
AND LOOKUP_CODE = FINAL_MARK1
AND LANGUAGE = USERENV('LANG');
SELECT
DISTINCT
TEST_TYPE
INTO ASSAYTYPE
FROM
GMD_QC_TESTS_B
WHERE TEST_CODE = ASSAY_CODE;
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 );
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 );
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 );
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 );
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 );
SELECT
DISTINCT
TEST_TYPE
INTO ASSAYTYPE
FROM
GMD_QC_TESTS_B
WHERE TEST_CODE = ASSAY_CODE2;
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 );
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 );
SELECT
distinct DISPLAY_LABEL_NUMERIC_RANGE -- 12575637 added distinct
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 );
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';
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';
SELECT
NAME
INTO OP_UNIT
FROM
HR_OPERATING_UNITS
WHERE ORGANIZATION_ID = ORDER_ORG_ID;
SELECT
DISTINCT
ORGANIZATION_CODE
INTO ORG_CODE
FROM
MTL_PARAMETERS
WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;