APPS.QA_ERES_PKG SQL Statements

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

Line: 59

            SELECT MCK.concatenated_segments
            FROM   mtl_categories_kfv MCK, MTL_CATEGORY_SETS_B CSET
            WHERE  CSET.CATEGORY_SET_ID = p_category_set_id AND
                   MCK.STRUCTURE_ID = CSET.STRUCTURE_ID AND
                   MCK.CATEGORY_ID = p_category_id;

Line: 77

            SELECT MCK.description
            FROM   mtl_categories_vl MCK, MTL_CATEGORY_SETS_B CSET
            WHERE  CSET.CATEGORY_SET_ID = p_category_set_id AND
                   MCK.STRUCTURE_ID = CSET.STRUCTURE_ID AND
                   MCK.CATEGORY_ID = p_category_id;

Line: 107

         SELECT DECODE(qc.hardcoded_column, NULL, qpc.result_column_name, qc.developer_name) rescol
         FROM QA_PLAN_CHARS qpc,
              QA_CHARS qc
         WHERE qc.char_id = qpc.char_id AND
               qpc.plan_id = c_plan_id AND
               qpc.char_id = c_char_id;

Line: 141

      l_stmt := 'SELECT '||l_rescol||' FROM QA_RESULTS_FULL_V WHERE plan_id = :2 and collection_id = :3 and occurrence = :4';

Line: 167

            SELECT meaning
               INTO   l_return_str
               FROM   wsh_lookups
               WHERE  lookup_type = 'PICK_STATUS'
               AND    lookup_code = 'I';

Line: 185

         SELECT DECODE(rt.source_document_code, 'RMA', MSI.HAZARD_CLASS_ID, NVL(POL.HAZARD_CLASS_ID, MSI.HAZARD_CLASS_ID)) HAZARD_CLASS_ID
         FROM RCV_TRANSACTIONS_INTERFACE RT, MTL_SYSTEM_ITEMS MSI, PO_LINES_ALL POL
         WHERE rt.interface_transaction_id = p_interface_transaction_id AND
               rt.to_organization_id = MSI.ORGANIZATION_ID(+) AND
               rt.item_id = MSI.INVENTORY_ITEM_ID(+) AND
               rt.po_line_id = POL.PO_LINE_ID(+);

Line: 193

         SELECT HAZARD_CLASS
         FROM PO_HAZARD_CLASSES_VL
         WHERE HAZARD_CLASS_ID = p_hazard_class_id;

Line: 229

         SELECT DECODE(rt.source_document_code, 'RMA', MSI.UN_NUMBER_ID, NVL(POL.UN_NUMBER_ID, MSI.UN_NUMBER_ID)) UN_NUMBER_ID
         FROM RCV_TRANSACTIONS_INTERFACE RT, MTL_SYSTEM_ITEMS MSI, PO_LINES_ALL POL
         WHERE rt.interface_transaction_id = p_interface_transaction_id AND
               rt.to_organization_id = MSI.ORGANIZATION_ID(+) AND
               rt.item_id = MSI.INVENTORY_ITEM_ID(+) AND
               rt.po_line_id = POL.PO_LINE_ID(+);

Line: 237

         SELECT UN_NUMBER
         FROM PO_UN_NUMBERS_VL
         WHERE UN_NUMBER_ID = p_un_number_id;

Line: 310

         l_stmt := 'SELECT DISTINCT '||l_rescol||' FROM QA_RESULTS_FULL_V WHERE plan_id = :1 and collection_id = :2 and occurrence = NVL(:3, occurrence)';