APPS.JL_GLOBE_UTIL_PKG SQL Statements

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

Line: 20

         SELECT pol.item_id
           INTO l_item_id
           FROM po_lines_all pol
          WHERE pol.po_line_id = p_level_id;

Line: 35

            SELECT global_attribute2
              INTO l_trx_reason_code
              FROM mtl_system_items mtl
             WHERE mtl.organization_id = (SELECT inventory_organization_id
                                            FROM financials_system_parameters
                                           WHERE org_id = p_org_id)
               AND mtl.inventory_item_id = l_item_id
               AND ROWNUM = 1;

Line: 50

            SELECT global_attribute1
              INTO l_trx_reason_code
              FROM po_system_parameters
             WHERE ROWNUM = 1;

Line: 64

         UPDATE po_lines_all
            SET transaction_reason_code = l_trx_reason_code
          WHERE po_line_id = p_level_id;

Line: 102

         SELECT global_attribute3
           INTO l_trx_reason_def_rule
           FROM po_system_parameters_all
          WHERE org_id = p_org_id;

Line: 112

            SELECT global_attribute2
              INTO l_txn_reason_code
              FROM mtl_system_items mtl
             WHERE mtl.organization_id = l_def_from_org_id
               AND mtl.inventory_item_id = p_item_id
               AND ROWNUM = 1;

Line: 125

               SELECT inventory_organization_id
                 INTO l_def_from_org_id
                 FROM financials_system_parameters
                WHERE org_id = p_org_id;

Line: 130

               SELECT global_attribute2
                 INTO l_txn_reason_code
                 FROM mtl_system_items mtl
                WHERE mtl.organization_id = l_def_from_org_id
                  AND mtl.inventory_item_id = p_item_id
                  AND ROWNUM = 1;

Line: 148

            SELECT inventory_organization_id
              INTO l_def_from_org_id
              FROM financials_system_parameters
             WHERE org_id = p_org_id;

Line: 153

            SELECT global_attribute2
              INTO l_txn_reason_code
              FROM mtl_system_items mtl
             WHERE mtl.organization_id = l_def_from_org_id
               AND mtl.inventory_item_id = p_item_id
               AND ROWNUM = 1;

Line: 177

      SELECT global_attribute1
        INTO l_txn_reason_code
        FROM po_system_parameters_all
       WHERE org_id = p_org_id;